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 2008, 2005 and 2000.

Keywords: SQL, compare SQL, compare database, database, database utility, schema, DDL, relational, MS SQL, MS SQL Server, SQL Server
|

Click to enlarge
|