AdeptSQL Diff
v1.98.104With 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 a...
Description
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.
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.