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"
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"
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: oracle, sql developer, tips
Entries (RSS)
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!
I’m glad it helped!
Thanks a lot…Vista users, you will find this folder at the following location..
C:\Users\\AppData\Roaming\SQL Developer\system…..
Thank you, I appreciate sharing this!
Thanks alot.
now, I can let the users&I upgrade with no worries. 🙂
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.
Thanks, just what i needed!
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.
Thanks man.
Thanks a lot..it solved my issue…
You saved my day 🙂
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.
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!
Thanks a lot. It saves my time. Appreciate it.
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.
Even in 2012 very helpful !
“Oracle SQL Developer” “verbindungen weg” ? => look above.
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
Awesome – worked like a charm
Thank You !!!
Simple but Solid tip.
Thank you sir.
Thanks a lot, great tip when you are configuring a new machine too.
Thanks a lot.
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