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 combined schema tree view, with all differences color-marked.
through the database schema tree, you can see SQL definitions for individual objects (tables,
view, stored procedures, etc) compared side-by-side in the larger panel to the right of the schema tree.
You can produce difference scripts
for any chosen part or for the whole schema. The schema matching engine
generates effective update SQL for any schema difference you need to
synchronize, trying to preserve the table data whenever possible.
The generated scripts are displayed in a separate
debugger-style popup window where you can edit them, execute them
either uninterrupted or step-by-step, set breakpoints, turn on transactions and
rollback on errors.
Even if you have only one database to work with, the drag&drop scripting
(you simply drag one or more schema items to any text editor supporting regular OLE
drag&drop) together with very flexible scripting options makes
AdeptSQL Diff a perfect tool to explore your database schema.
Currently, version for MS SQL Server is available.
Support for other SQL databases is planned.