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.
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.
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:
- Source File
- Password Handling
- Select Connections