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

8 comments:

rmouniak said...

It 's amazing article and useful for developers
Sql server DBA Online Training Bangalore

divya said...
This comment has been removed by the author.
sheela rajesh said...

Nice idea,keep sharing your ideas with us.i hope this information's will be helpful for the new learners.
JAVA Training in Chennai
JAVA Course in Chennai
Digital Marketing Course in Chennai
Python Training in Chennai
Big data training in chennai
Selenium Training in Chennai
JAVA Training in Chennai
JAVA Course in Chennai

Hamza shaikh said...

import export data You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this...

Anand Shankar said...

Wonderful post. Keep posting such posts for us to read.
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge
one funnel away challenge

Anonymous said...

Thanks for sharing valuable information, keep us posted more Python Classes in Pune
python programming classes in Pune

IT Education said...

Nice post. Keep sharing Java Classes in Pune

SEO said...

Thanks for sharing information about import export document management ERP