SQL Developer Database Copy

Recently, my team has been involved in a pretty detailed migration from a Development Instance to our QA instance prior to a final promotion to Production.  In the past, some of the team members were moving PL/SQL packages between instances by doing this:

1. Opening them up
2. Copying to the clipboard
3. Open window in the target instance and schema
4. Paste from clipboard
5. Recompile

If you don’t know, I like using tools the way they were meant to be used. That said, I had the opportunity to show two really cool features of SQL Developer to a colleague.

While it seems like a bit much, you have the ability to select specific database characteristics.  Here is a basic example of what I am talking about:

 

Launch the Database Copy Wizard

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the Source and Destination Database Instances

 

 

 

 

 

 

 

 

 

 

 

 

 

Choose the Object Type(s) you want to copy to the next instance

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the targeted objects

 

 

 

 

 

 

 

 

 

 

 

 

 

Review the Summary Screen (If I were migrating a TABLE, the Specify Data screen would be next)

 

 

 

 

 

 

 

 

 

 

 

 

Click the Finish button, and SQL Developer will migrate those objects and produce a log file.

 

Once my colleague saw this, he said “I really like this tool! SQL Developer.”  I then went on to show him Database Diff … but I’ll save that for later.

 

Enjoy