Introduction.

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. You can produce difference scripts for any chosen part or for the whole schema using menu commands, conveniently placed toolbar buttons, hotkeys or drag-n-drop.

The Diff never changes your databases automatically. Instead, any generated SQL script is shown in the built-in SQL editor, where you can execute the scripts either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on errors.

The program also includes DataDiff - a subsystem to compare and synchronize data in any of the compared tables. Note that you have to run a regular schema comparison, then in the schema tree select a single pair of matched tables (at least one of them with data) before the comparison command will be enabled.

[Starting from version 1.90] The Diff treats connection parameters and other comparison-specific settings as a 'project' or 'document' which can be saved to a file and re-opened later. Such comparison document can also be specified at startup in the command line, along with various command-line parameters.

The reporting functionality, which also first appears in version 1.90, allows to print out the comparison results or export them in a number of common formats (PDF, HTML, RTF, etc). The reporting is provided for both schema- and data-comparison

Even if you have only one database to work with, the drag&drop scripting together with very flexible scripting options make AdeptSQL Diff a perfect tool to reverse-engineer the schema of your database.

Compatibility with MS SQL Server 2005

AdeptSQL Diff versions before 1.90 only supported MS SQL Server 7 and 2000. Version 1.90 has now basic support for MS SQL Server 2005 as well. It means that the Diff will correctly read, compare and script all SQL2000-level schema objects from an SQL2005 database. It will also understand SQL2005-specific additions to the existing objects, such as:

• Columns with XML data types,
• Named schemas instead of users,
• New syntax in procedures, functions and triggers ("WITH EXECUTE AS...")

Version 1.90 does not yet support a number of new schema objects, such as XML indexes or any .NET-related stuff. All this (and more) is planned for version 2.0.

Please contact us at the address below if you have any questions or ideas regarding the tool:

    support@adeptsql.com