CompareMyDB Comparison and synchronization of Oracle® databases What is it?CompareMyDB is a powerful tool designed to compare Oracle® databases. CompareMyDB creates SQL Scripts that make schema synchronization easy. What does it do?CompareMyDB retrieves schema information from your databases or previously taken snapshots. CompareMyDB compares the schema information, displays the differences and generates SQL Script to recreate and synchronize your databases. What is my benefit?Many organizations use a range of databases for the different stages of their development process. They might use a development, a staging and a production database. Once a new version of the application is finished, the changes of the development database have to be moved to the staging and the production database. Developers have several alternatives to do this:

• Drop the target database and replace it with the new one.
• Use a GUI tool to apply the changes.
• Create a script to synchronize one database to another.

Creating a script is clearly the best option. It allows you to do keep track of the changes between database versions and the changes can be reproduced. Moreover you can apply the script to several target databases. But even this process poses a number of challenges. First of all the migration scripts have to be error free. The second problem is making sure that they are complete. The larger your database is and the more changes have been made, the harder it will be to create accurate and complete scripts.

By automating the error-prone task of creating migration scripts CompareMyDB offers the following benefits:

• CompareMyDB gives you visual indications of differences in database objects.
• CompareMyDB creates migration scripts for database objects that have been changed.
• CompareMyDB improves the quality of your migration process.
• CompareMyDB increases your efficiency by saving you time and valuable man power.