« 
 »
12 06 2008

Oracle SQL Developer import connections

Posted by: andreiash in Database, Oracle

SQL Developer screenshot

Sometimes, upgrading Oracle SQL Developer will not import your existing connections. You can have in the end an empty connection list. In order to import it, you just need to copy the connections.xml file from your old location like this:

"c:\Documents and Settings\[user]\Application Data\SQL Developer\system1.5.0.53.38\
o.jdeveloper.db.connection.11.1.1.0.22.49.35\connections.xml"

to your new location like this:

"c:\Documents and Settings\[user]\Application Data\SQL Developer\system1.5.1.54.40\
o.jdeveloper.db.connection.11.1.1.0.22.49.35\connections.xml"

Another version would be, when upgraded version of SQL Developer is asking for the path to the connections file, just provide him the path to the old version.

Good luck!

Tags: , ,

This entry was posted on Thursday, June 12th, 2008 at 11:35 am and is filed under Database, Oracle.You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

12 Responses to “Oracle SQL Developer import connections”
  1. prabhu says:
    June 19th, 2009 at 6:46 pm

    thanks for the quick tip and for stopping me going crazeee! … i did not see this even in the sql developer manual… i mean the path to the file. thanks!

  2. andreiash says:
    June 19th, 2009 at 7:48 pm

    I’m glad it helped!

  3. Gourija says:
    July 18th, 2009 at 12:26 am

    Thanks a lot…Vista users, you will find this folder at the following location..

    C:\Users\\AppData\Roaming\SQL Developer\system…..

  4. andreiash says:
    July 18th, 2009 at 1:38 pm

    Thank you, I appreciate sharing this!

  5. Waleed says:
    October 3rd, 2009 at 9:16 am

    Thanks alot.

    now, I can let the users&I upgrade with no worries. :)

  6. gopal says:
    January 18th, 2010 at 10:10 am

    I want to use the connection.xml file from sql developer in sql navigator. is it possible.?
    As I dont want to create the conections manually in nav.
    What are the ways to import connection files to Nav.

  7. Ricardo says:
    January 19th, 2010 at 1:56 pm

    Thanks, just what i needed!

  8. andreiash says:
    January 22nd, 2010 at 11:42 pm

    I am not very familiar with SQL Navigator.
    try to find out where it’s keeping the connections file and then copy and paste from SQL Developer’s conection.xml file.

  9. Can Cetin says:
  10. kalyan says:
    February 16th, 2010 at 1:39 pm

    Thanks a lot..it solved my issue…

  11. Magnus says:
    April 21st, 2011 at 9:43 am

    You saved my day :-)

  12. Peter says:
    July 12th, 2011 at 6:19 pm

    Thanks, this saved me from having to dig through e-mails for IP addresses and service names, saved me hours of work! This was perfect.

Leave a Reply