Oracle SQL Developer: Export/Import Connections Makes Migration Easier

Recently, I need to retire an old laptop and backup all necessary software pieces from one Windows to another Windows.

A connection is a SQL Developer object that specifies the necessary information for connecting to a specific database as a specific user of that database.

In this article, we will describe how to migrate existing Connections in Oracle SQL Developer from one laptop to another.

Export Connections

The Export Connections wizard exports information about one or more database connections to an XML file.

For migration, you would select all connections like below.  In the next step, you then specify an output XML file.

Extra care should be taken when exporting connections that contain passwords. In the next step, you are allowed to encrypt all passwords with a key.

Import Connections

The Import Connections wizard imports connections that have been exported. Database connections that you import are added to any connections that already exist.

Without much ado, you just  follow the reverse order of export steps to import:

1. Source File
2. Password Handling
3. Select Connections
4. Summary

References

1. Oracle SQL Developer