SQL-Developer: Migrate settings files (settings, code templates, snippets, connections etc.)

If you, like me, have a lot of personal settings, code templates, snippets, connections etc. in SQL-Developer, you may want to migrate them to a new version or another computer from time to time. Here are the most important configuration files of SQL-Developer for migrations and backup:

User dependent files

  • Code templates:
    %USERPROFILE%\Application Data\SQL Developer\CodeTemplate.xml
  • Snippets:
    %USERPROFILE%\Application Data\SQL Developer\UserSnippets.xml
  • SQL history:
    %USERPROFILE%\Application Data\SQL Developer\SqlHistory.xml

SQL-Developer version dependent files

The numbers in the following paths vary with the version of SQL-Developer you have installed!
Please look for the appropriate directories of your installation.

  • Accelerators:
    %USERPROFILE%\Application Data\SQL Developer\system3.0.04.34\o.ide.\settings.xml
  • Connections:
    %USERPROFILE%\Application Data\SQL Developer\system3.0.04.34\o.jdeveloper.db.connection.\connections.xml
  • Syntax highlights:
    %USERPROFILE%\Application Data\SQL Developer\system3.0.04.34\o.sqldeveloper.\product-preferences.xml

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s