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

backup oracle-sqldeveloper connection
Satyendra picture Satyendra · Oct 9, 2013 · Viewed 91.3k times · Source

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 ?

Answer

Satyendra picture Satyendra · Oct 9, 2013

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.

Related questions

SQL Server: Database stuck in "Restoring" state

I backed up a database: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database And now the database …

Read More
Restore a postgres backup file using the command line?

I'm new to postgresql, and locally, I use pgadmin3. On the remote server, however, I have no such luxury. I've already created the backup of the database and copied it over, but, is there a way to restore a backup …

Read More
How to take backup of a single table in a MySQL database?

By default, mysqldump takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?

Read More