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:


...don't know how I lived without it! Your tool has saved me many, many painful hours since I got it.

Dan Terrill,
Corpit.com,
USA

See all quotes

 


07 Nov 2008
AdeptSQL Diff 1.96 Build 94!
This version contains a bug fix in schema reading on SQL2000 and improved code generation in certain synchronization scenarios. See the complete list of changes for more details.



05 Nov 2008
AdeptSQL Diff 1.96 Build 93!

This version contains some more bug fixes. Options to ignore triggers and indexes now work for both CREATE scripts and sycnhro scripts.

29 Oct 2008
AdeptSQL Diff 1.96 Build 92!

This update fixes a critical bug in scripting, that first appeared in Build 90 and affected the "Produce SQL/CREATE from..." and "Produce SQL/DROP from..." commands (not the regular synchro scripting).



19 Oct 2008
Support for WS2008 (Build 91)

Previous versions of AdeptSQL Diff were unable to start on some MS Windows Server 2008 machines. The problem was caused by Diff's DRM wrapper subsystem that didn't support the newest generation of MS operating systems. Now a new "flavor" of AdeptSQL Diff, that reliably runs on WinServer 2008, is available for download. The "classic" and the new setups have exactly the same functionality, but use incompatible activation keys. Existing users could either stick to the "classic" version, or individually request a replacement activation key (free of charge).

08 Oct 2008
AdeptSQL Diff 1.96 Build 90!

In this version, the Diff has been updated to work with MS SQL Server 2008. While previous versions of Diff were "mostly" compatible with SQL2008, we had to make a number of changes to support some of the new features.




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