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: , ,
22 Responses to “Oracle SQL Developer import connections”
  1. prabhuNo Gravatar says:

    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:

    I’m glad it helped!

  3. GourijaNo Gravatar says:

    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:

    Thank you, I appreciate sharing this!

  5. WaleedNo Gravatar says:

    Thanks alot.

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

  6. gopalNo Gravatar says:

    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:

    Thanks, just what i needed!

  8. andreiashNo Gravatar says:

    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:

    Thanks a lot..it solved my issue…

  11. MagnusNo Gravatar says:

    You saved my day 🙂

  12. PeterNo Gravatar says:

    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:

    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:

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

  15. JohnNo Gravatar says:

    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:

    Even in 2012 very helpful !

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

  17. BalazsNo Gravatar says:

    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:

    Awesome – worked like a charm
    Thank You !!!

  19. JayNo Gravatar says:

    Simple but Solid tip.

    Thank you sir.

  20. EvNo Gravatar says:

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

  21. SajithNo Gravatar says:
  22. Baljit SinghNo Gravatar says:

    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