Oracle SQL Developer: Sharing Configuration Using Dropbox

Question

I would like to share my Oracle SQL Developer configuration on several computers using Dropbox.

How can i do this?

Answer 1

Here is what I did.

#!/bin/bash # share sqldeveloper config via dropbox # this is for sqldeveloper 1.5.4, change your paths as necessary # strace or dtruss sqldeveloper to see what config files are accessed ITEMS=" o.ide.11.1.1.0.22.49.48/preferences.xml o.ide.11.1.1.0.22.49.48/settings.xml o.jdeveloper.cvs.11.1.1.0.22.49.48/preferences.xml o.jdeveloper.subversion.11.1.1.0.22.49.48/preferences.xml o.jdeveloper.vcs.11.1.1.0.22.49.48/preferences.xml o.sqldeveloper.11.1.1.59.40/preferences.xml o.sqldeveloper.11.1.1.59.40/product-preferences.xml " INST=~/Library/Application\ Support/SQL\ Developer/system1.5.4.59.40 DROP=~/Dropbox/Library/SQL\ Developer/system1.5.4.59.40 # note, you can zap your configuration if you are not careful. # remove these exit lines when you're sure you understand what's # going on. exit # copy from real folder to dropbox for i in $ITEMS; do echo uncomment to do this once to bootstrap your dropbox #mkdir -p "`dirname "$DROP/$i":`" #cp -p "$INST/$i" "$DROP/$i" done exit # link from dropbox to real folder for i in $ITEMS; do rm "$INST/$i" ln -s "$DROP/$i" "$INST/$i" done 

Answer 2

In case someone comes here looking for the location of user-configurable options like me, they are hiding here:

 %appdata%\SQL Developer\ 

It is useful to know when copying your settings to a new computer. If you are looking for connection parameters, find connections.xml in this directory. There are also some other configuration files here:

 sqldeveloper.conf – <sqldeveloper dir>\sqldeveloper\bin\ ide.conf – <sqldeveloper dir>\ide\bin\ 

This is for Oracle SQL Developer 3.

Answer 3

Easy SQLDeveloper configuration setup on Dropbox, the easiest way for MACOSX -

 cd ~/Dropbox mkdir -p Library/SQLDeveloper cp -rp ~/.sqldeveloper/* Library/SQLDeveloper/ mv ~/.sqldeveloper ~/remove_when_sure_sqldeveloper ln -sf $PWD/Library/SQLDeveloper ~/.sqldeveloper 

Do it on your most important machine and on a machine that you can only share

 cd ~/Dropbox mv ~/.sqldeveloper ~/remove_when_sure_sqldeveloper ln -sf $PWD/Library/SQLDeveloper ~/.sqldeveloper 

It works like a charm.