With AdeptSQL Diff, you can visually compare two MS SQL Server databases, then produce and execute difference scripts for a choosen part or for the whole schema. Also compares table data. Very fast and easy to operate.
Version: 1.98.104AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases.
License: Commercial $320.00
Operating System: Windows
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.