« 
 »
12 06 2008

Oracle SQL Developer import connections

Posted by: Andrei 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!

Related Posts

Sovrn
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.

22 Responses to “Oracle SQL Developer import connections”
  1. prabhuNo Gravatar 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. andreiashNo Gravatar says:
    June 19th, 2009 at 7:48 pm

    I’m glad it helped!

  3. GourijaNo Gravatar 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. andreiashNo Gravatar says:
    July 18th, 2009 at 1:38 pm

    Thank you, I appreciate sharing this!

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

    Thanks alot.

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

  6. gopalNo Gravatar 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. RicardoNo Gravatar says:
    January 19th, 2010 at 1:56 pm

    Thanks, just what i needed!

  8. andreiashNo Gravatar 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 CetinNo Gravatar says:
  10. kalyanNo Gravatar says:
    February 16th, 2010 at 1:39 pm

    Thanks a lot..it solved my issue…

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

    You saved my day 🙂

  12. PeterNo Gravatar 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.

  13. KishoreNo Gravatar says:
    January 9th, 2012 at 6:23 pm

    Thanks a Ton! I am working in Prod support and I’ve got at least 70 connections. I am backing up all the data that is needed for my new laptop and was worried if I’ve to establish all the connections in my new one. This XML file is a surprise and it did the job in seconds.

    What a day!

  14. RathnaNo Gravatar says:
    March 28th, 2012 at 10:04 pm

    Thanks a lot. It saves my time. Appreciate it.

  15. JohnNo Gravatar says:
    May 19th, 2012 at 4:00 pm

    Salut, am o problema nu merge sa ma conectez la oracle SQL developer cu localhost, trebuie sa mai instalez alte programe pentru a ma conecta.

  16. PatrickNo Gravatar says:
    August 14th, 2012 at 9:21 am

    Even in 2012 very helpful !

    “Oracle SQL Developer” “verbindungen weg” ? => look above.

  17. BalazsNo Gravatar says:
    September 5th, 2012 at 7:44 am

    Thank you, your description helped me a lot to solve the problems after reinstalling the sql developer. Just one point to mention that I have had the connections grouped into folders, but after copying the connections.xml to the new location the folders were lost. But the connections with the saved credentials were transferred, which was the main goal

  18. William GNo Gravatar says:
    November 8th, 2012 at 5:23 pm

    Awesome – worked like a charm
    Thank You !!!

  19. JayNo Gravatar says:
    February 21st, 2013 at 10:44 pm

    Simple but Solid tip.

    Thank you sir.

  20. EvNo Gravatar says:
    May 21st, 2013 at 4:47 pm

    Thanks a lot, great tip when you are configuring a new machine too.

  21. SajithNo Gravatar says:
  22. Baljit SinghNo Gravatar says:
    January 26th, 2014 at 7:15 pm

    Right Click on Nvigator window Connections > Import COnnections (wizard will open)> choose the backed up location of your old connections.xml file and open > next > select [replace] or [rename] > finish…. and there you have it ….

    else you may endup placeing the old connection file in the worng folder with spurious name and hard to find e.g.
    o.jdeveloper.db.connection.11.1.1.4.37.59.48

    e.g.

    My location of the previous version of the COnnection file

    C:\Documents and Settings\bally\My Documents\BACKUP\bally\system3.2.09.30\o.jdeveloper.db.connection.11.1.1.4.37.59.48

Leave a Reply