Clever Database Comparer

From CleverComponents:

Database Comparer helps to compare, synchronize and update databases structure. You can compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts!

Database Comparer implements highly intelligent and robust synchronization algorithm. During first comparison step it takes Target database or Target SQL/DDL script and compare it to the Master database or Master SQL/DDL script trying to locate all structure differences and prepare final SQL script which will be applied to the Target and make its structure equal to Master structure.

At this stage Database Comparer extracts all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from Target building final update SQL script. After final update SQL script is ready you can apply it to the Target database if it is available or just save it to the file and run it later.

Database Comparer also support batch mode so you can synchronize list of Target databases with given Master database or SQL/DDL script at one pass.

Features at a glance:

• Can compare database with database, database with SQL/DDL script and SQL/DDL script with SQL/DDL script.
• Can compare and synchronize data between two database tables.
• You can optionally select which objects (domains, tables, procedures, triggers etc.) should be compared.
• Batch mode for most operations.
• Ability to browse Master and Target structure trees and visually display the differences between them.
• Final update SQL script can be edited or broken onto separate steps using built-in SQL editor with highlight feature. You can manually change steps order or optionally disable selected steps.
• Build-in additional functionality such as: drop constraints, backup/restore, database validation and many other useful features.