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:
- Opening them up
- Copying to the clipboard
- Open window in the target instance and schema
- Paste from clipboard
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.