ThatJeffSmith

Migrating Oracle SQL Developer Connections (with Passwords!)

So you just got your brand new machine at work. Party time, excellent*!

And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer.

But when you go to use it, none of your connections are there.

Or maybe the connections are there, but the connection passwords ARE not.

And really, who has the discipline to have 300 different passwords for all of the databases memorized and ready to recall at a moment’s notice? I thought so.

So, without further ado, here’s how to move those connections WITH their passwords intact, from your old machine to your new one.

Export Your Existing Connections

Right click on the connection tree - top bit of the tree that is

Right click on the connection tree – top bit of the tree that is

Select your connections to export

Select your connections to export

Save to an XML file

Save to an XML file

Provide a secure 'key' - you are password protecting your passwords and will need to know this 'later'

Provide a secure ‘key’ – you are password protecting your passwords and will need to know this ‘later’

yada, yada, yada - click OK/Finish

yada, yada, yada – click OK/Finish

Import Them Back

Get that XML file you just generated to your new machine. I just emailed it to myself, probably not the most secure thing in the world, but I’m just playing around here.

So on my new mac - so lonely, only 1 connection - I want to 'Import'

So on my new mac – so lonely, only 1 connection – I want to ‘Import’

Point it to the XML file and then you'll be prompted for the KEY

Point it to the XML file and then you’ll be prompted for the KEY

Select the connections to import

Select the connections to import

Note that I’m telling it to RENAME connections coming in if there’s a conflict – I don’t want to lose anything I already have. I’m not that creative with my connection names, so I’m taking the safe route here.

Voila! My connections are in! And the folder structure and passwords are both intact.

Voila! My connections are in! And the folder structure and passwords are both intact.

Happy Jeff! And happy DBAs that don’t have to reset my 300+ passwords.

A Few More Connection Things You Should Know