AdeptSQL Diff is a tool to visually compare and synchronize schemas of two databases. It assists database administrators and developers who need to keep synchronized several versions of complex SQL databases. Separate versions of AdeptSQL are available supporting MS SQL (AdeptSQL Diff, for MS SQL 7, 2000) and InterBase (AdeptSQL Diff/IB, for InterBase 6.0). Support for older versions of InterBase and for FireBird is planned.
The program scans two databases and displays their schema in a tree view, with any 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 chosen 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 error.