Pages

Sunday, March 2, 2014

Migrating/Transferring SQL Developer connections from one system to another system

Issue: Migrating SQL Developer connections from one system to another system

Solution: 
SQL Developer providing a cool option to export and import connections. 

Try this option for sure. Every one should know this tip.

Step 1: Open your SQL Developer. This will already contains configured database connections as below.


Step 2: Now right click on "Connections", select "Export Connections" as shown below.


Step 3: Provide a desired path to export the connections. Basically connections exported as XML file. Here you have an option to export 

a) all the connections (First Image) or b) Only selected connections (Second Image)



Step 4: Now transfer this XML file to your friend's computer. Use "Import connections" option in SQL Developer as follows.


Step 6: Select previously transferred XML to import the connections. This will lists all the connections available in XML file.


Step 7: Finally click "Ok" button to complete importing connections.


CHEERS :)


No comments:

Post a Comment