Search code examples
backuporacle-sqldeveloperconnection

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

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 7 / 10

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

    In old 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\

    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.

    PS : Careful, your password are NOT included.