Good news! You got a new computer!

Bad news…you now have to move all your stuff over.

For SQL Developer this is pretty straight forward. We’re going to have two steps:

  1. copy over your preferences
  2. import your connections

Copying over your preferences

We store these in one of two places, depending on your Operating System.

For Windows:

C:\Users\%USER%\AppData\Roaming\SQL Developer

For OSX and Linux:

/home/%USER%/.sqldeveloper

The ‘tricksy’ thing here is that Windows will generally hide the AppData folder from you, and unless you use the -a flag on your ls command, *NIX won’t show you .directories.

You can copy over the whole darned thing…or you could just grab the SqlHistory and systemMajor.minor.X.Y.Z directory for the version of SQL Developer you want to copy your preferences over from.

Windows

Each of these system directories represents the settings I’ve stored for a different version of SQL Developer on my machine.

NIX

I just have the one, really old version of SQLDev on my VBOX 🙁

When I say ‘copy over’, I mean, just copy them over to your new machine, in the equivalent new directory for whatever USER you have been given on your machine. You could go cross OS I believe for the most part…but I’ve never tried this.

Migrating Connections

Start SQL Developer up on your new machine, and import your preferences (you’ll have a file from doing an Export on your old machine).

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

You’ll have to supply a password to protect your connection passwords, and supply this on your new machine.

Once you’ve done your import, your connections AND they’re associated folders and sub folders, will all come over.

By default we’ll have all the connections come in, but you can choose now to weed out the ones you don’t use anymore.

Where is version 19.2?

With QA. We found a last minute show-stopper, and combined with Summer vacations and conferences travel, it’s just taking a bit longer than usual to get things out-the-door. Doing another set of tests, and we’ll have your latest and greatest set of tools and ORDS out the door, ‘shortly.’

No more Java 8 if you don’t want to, but we’ll still support Java 8 if you need it.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

10 Comments

  1. Hi Jeff, where does SQL Developer / Data Modeler store the User defined native types, that I define under Tools->Data Modeler->Types Administration? They disappear weekly due to local refresh (C:\Users\%USER%\AppData\Roaming\SQL Developer gets refreshed) and I would like to keep them. System is Windows 10.
    Where can I keep my settings in this case and make sure SQL developer reads them when it starts?
    Thanks
    Stephan

    • thatjeffsmith

      Can you tell your network team they’re killing you every week? So every week, you lose your connections, SQL history, etc? Have them put in an filter/exclusion for the SQL Dev folders under Roaming profiles.

    • Stephan Krushev

      Hi,
      thank you for your fast response and your advice. Probably it works in a small company with a local network team. What worked for me is to export the Data Modeler settings and then reload them:

      Tools->Preferences->Data Modeler-> Export and then Import after the refresh. All type settings and report settings are available again.

  2. is it possible to specify something other than C:\Users\%USER%\AppData\Roaming\SQL Developer for a SQL Developer home?

  3. Thanks. But I can’t export because the indexpreferencestask won’t stop running. Is there another way to get connections with passwords exported/imported?

    • thatjeffsmith

      It shouldn’t take a few more than a minute or so..and the answer is no.

      I might be to show you how to disable the preferences indexing if you need it.

  4. Great advice I had not known the portability of the systemVERSION folder, I have been using the export/import connections and one other thing, export your User Defined reports.

    • Actually, I left it to do its thing after 20 minutes. Eventually, sometime, the task completed and I was able to (slowly) export my connections and scrapped the whole installation for a fresh install.

      What is this index preferences task anyway? What is it for and why do I need it? If it is disabled, what trouble will I experience? If there is a way to disable it, yes please, provide me a link to your instructions.

Write A Comment