Your database comparison
and synchronization tool
Diff tool:Introduction  Screenshots  Order now  Revision history  Documentation  
Adept SQL Tools
Diff tool  
Downloads
Ordering
Quotes
FAQ
Contact us

Comparing SQL schema and table data with AdeptSQL Diff

Click here to see the screenshot explainedAdeptSQL 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 regular OLE 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.

To learn more about AdeptSQL Diff, you can:


It's brilliant. I've evaluated other tools like SQL Compare but they fall apart on seriously large databases. Our main database contains 1800 tables; SQL Compare sits there grinding away and eventuall crashes with a GPF after about 3 hours. AdeptSQL Diff comes back neatly in under 3 minutes. Impressive stuff.

Joris Laperre,
Global Care Solutions,
Thailand

See all quotes

 


07 Feb 2007
AdeptSQL Diff 1.95 Build 88!

This is the most recent bugfix update recommended for all Diff users. Please see the revision history for the complete list.



28 July 2007
AdeptSQL Diff 1.95 Build 87!

This is just another bugfix release. Please see the revision history for the complete list of corrections.



22 May 2007
AdeptSQL Diff 1.95 Build 86!

This update contains a number of important corrections and improvements in the comparison and scripting engine. Please see the revision history for the complete list.




Copyright © Adept SQL Tools, 2002-2005
Designed by RaysLab