Thursday, June 4, 2015

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 comment:

Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,packaged applications,business applications, Web services, data migration
Business intelligence, Business Development, Software Development etc.


Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp