| 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. Navigating 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
OLD drag&drop) together with very flexible scripting options
makes AdeptSQL Diff a perfect tool to reverse-engineer your
database schema. Currently, versions for MS SQL Server,
and Interbase are available. Support for other SQL databases
is planned. |