Forum Stats

  • 3,768,260 Users
  • 2,252,769 Discussions


Moving to a new computer

Jeffrey Kemp
Jeffrey Kemp Member Posts: 193 Red Ribbon
edited Jul 21, 2016 1:17AM in SQL Developer

Having been issued a new work PC I've just gone through the process of moving all my stuff across, including SQL Developer.

I would like to think that there is a smart way of doing this, but I didn't find it - instead I did multiple exports/imports, as well as copying over an xml file, in order to get most of my settings across. I think I've missed a few things but these are the main ones that I needed to bring across.

On the old machine:

1. Connections > Export Connections

2. Tools > Preferences > Data Modeler > Export

3. Take a copy of \sqldeveloper4.1.3\sqldeveloper\extensions\oracle.datamodeler\types\defaultdomains.xml

On the new machine:

1. Download & install SQL Developer ( on the new machine

2. Copy defaultdomains.xml into the appropriate folder

3. Connections > Import Connections

4. Tools > Preferences > Data Modeler > Import

5. Re-set all the other preferences throughout

Surely there is a simpler way? When you upgrade SQL Developer on the same machine, it gives the opportunity to migrate all the settings across. There should be a similar method to move from one machine to another.




  • Marwim
    Marwim Member Posts: 3,647 Gold Trophy
    edited Jul 7, 2016 3:10AM

    If I want to use the same version on another PC I usually

    - copy the folder where SQL Developer is installed to save the changes made to the config *

    - copy the config folder (e.g. system4. for the preferences

    This assumes that the file structure is the same on the target PC.


    * I usually set the following in sqldeveloper.conf

    AddVMOption -Dide.user.dir=<Directory where SQL Developer is installed>

    AddVMOption -Duser.language=en

    The first to have all necessary files in one place

    The second because it is easier to ask questions if you know how the menues etc. are named in English

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,057 Employee
    edited Jul 7, 2016 7:54AM

    Pretty much what @Marwim said.

    - copy the config folder (e.g. system4. for the preferences

    You'll want to export and import your connections from the GUI if you don't want to have to re-input all of your passwords.

  • Jeffrey Kemp
    Jeffrey Kemp Member Posts: 193 Red Ribbon
    edited Jul 21, 2016 1:17AM

    You'll note that that was already my very first step

This discussion has been closed.