Forum Stats

  • 3,768,260 Users
  • 2,252,769 Discussions
  • 7,874,508 Comments

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 (4.1.3.20) 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.

Thanks

Tagged:
thatJeffSmith-Oracle

Answers

  • 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.1.3.20.78) for the preferences

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

    Marcus

    * 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
    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.1.3.20.78) 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.