Migrate Settings and Preferences for SQL Developer

by Brandon 14. February 2012 23:24

I'm at the end of a very long day of dealing with a lot of Oracle B.S.  I'll get into that in another post but I hope to save some other poor sap at least some frustration.  I was lucky enough to get a nice new i7 at work this week and started migrating over my stuff.  Most of the time its a pst here or a folder there.  But of course, not Sql Developer.  Sql Developer spreads its config over a myriad of xml files in C:\Users\<user>\AppData\Roaming\SQL Developer\systemX.X.X.X.  (or C:\Documents and Settings\<user>\Application Data\SQL Developer\systemX.X.X.X in XP).  I suppose you could search for all xml files and drop them in their respective folders but I'm not sure it's save and I'm certain it's a total pain in the ass.  I tried myself and started with connections.xml which was easy enough but quickly abandoned this when I realized things like the folders for the connections were IN A SEPARATE CONFIG FILE!!!  Instead do the following:

  • Delete your existing systemY.Y.Y.Y folder from C:\Users\<user>\AppData\Roaming\SQL Developer
  • Copy your old systemX.X.X.X into C:\Users\<user>\AppData\Roaming\SQL Developer
  • Start up Sql Developer

This time Sql Developer should ask you if you'd like migrate your settings.

About the authors

Three brothers (yes we're really brothers) all writing and architecting .net solutions.  Our original inspiration for this blog was simply to give the same useful advice we receive from other blogs on a very regular basis.  Lets face it, thanks to the Internet and its contributors, we're a long way away from the days of shifting through a 900 page reference book to find that one line of code.  But lately we've also noticed the shift in the view of application development.   Where once we were the heros of optimization and efficiency, we're now seen a bunch of budget blowing goof-offs that nobody trusts.  We've got some ideas to change that and we'll try to share those thoughts between the short snips of code.