AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases.
The program scans both databases and displays the schema tree view, with all differences color-marked.
Navigating through the tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side and produce difference scripts for any choosen part or for the whole schema.
The program lets you execute the generated scripts either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on errors.
A unique schema matching engine generates the minimal non-destructive SQL for any schema changes you you need to synchronize, keeping your data safe. Starting with version 1.50, the program also includes DataDiff - a data comparison and synchronization module. The current version supports MS SQL Server 7, 2000 and 2005.
AdeptSQL Diff keywords: sql, compare sql, compare database, database, database utility, schema, ddl, relational, ms sql, ms sql server, sql server