Comparing SQL schema and table data with AdeptSQL Diff
|
 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 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.
|
To learn more about AdeptSQL Diff, you can:
The evaluation version is fully functional: it has no "trial" restrictions
other than the 30-day / 50-runs (whichever lasts longer) time limit. The latest
version is AdeptSQL Diff 1.98 Build 100. It supports each of the following
versions of MS SQL Server:
- MS SQL Server 2008
- MS SQL Server 2005
- MS SQL Server 2000
- MS SQL Server 7.0
Support for MS SQL2008 was added in Q4 2008, starting
from Diff 1.96. Please note that updates within AdeptSQL Diff 1.xx version range are free for
all registered customers. Furthermore, we only provide technical support for
the most recent Diff version. Always make sure you have
the most recent version!
|
 |
Wow! If only everyone we purchased software from was so responsive,
friendly, and *particularly* helpful as yourself!!
Craig Penton,
AtosOrigin,
UK See all quotes |
 |
28 Dec 2009
AdeptSQL Diff 1.97 Build 100!
This is a must have update, with improved support for CLR data types, added
support for spatial indexes, many improvements in the Options dialog and a
number of bugs fixed.
See the complete list of changes
for more details.
Happy New Year to everyone!
15 sep 2009
AdeptSQL Diff 1.96 Build 98!
This version supports "table types" in SQL Server 2008, improved comparison of
SYNONYMs and a number of corrections.
31 July 2009
AdeptSQL Diff 1.96 Build 97!
This version contains a fix for a rare AV which occured when scripting
USERs from a single database.
27 July 2009
AdeptSQL Diff 1.96 Build 96!
This version adds support for SYNONYMs in SQL 2005/2008 and contains some minor
corrections.
02 Apr 2009
AdeptSQL Diff 1.96 Build 95!
This version adds support for partitioned tables and indexes and contains
a number of scripting improvements, especially when comparing databases running
under different MS SQL Server versions. It means that now the Diff is much less
likely to script some SQL2008-specific code into a SQL2005 server, or SQL2005-specific
into SQL2000. There is also, as always, a number of miscellaneous corrections
throughout the program.
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.
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).
|
|
Introduction 