[FIXED] How to take a backup for the 'connection details' in sqldeveloper?

Issue

What is the process to take a backup of all the connection-details (viz. host,port,sid,etc.) in 'oracle sqldeveloper' software.
How can we import these connection details to some other machine ?

Solution

The 'oracle sqldeveloper' stores all the connection details in an xml file ie. connections.xml.
If you want to have a backup for the connection details, you will have to navigate to

In windows XP
C:\Documents and Settings\<YourUserName>\Application Data\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\

In Windows 7
C:\Users\<YourUserName>\AppData\Roaming\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\

and take a backup of connections.xml .

Later, if you need to use the same connections on some other machine, you may simply copy the <Reference ...> tags for respective connections.

Answered By - Satyendra

Answer Checked By - Mildred Charles (PHPFixing Admin)