AdeptSQL Diff

1.0/5 1

Last updated: Sep 20, 2010 Certified 100% CLEAN Trial

SOFTPEDIA® DOWNLOAD NOW 3,666 downloads so far

Database schema difference viewer and synchronization tool for MS SQL Server #Compare database #Synchronize database #SQL server #Compare #Synchronize #Comparison

Description

AdeptSQL Diff is a fast and intuitive tool which will allow you 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 and produce difference scripts for any choosen part or for the whole schema.

The program lets you execute the generated scripts either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on errors. A unique schema matching engine generates the minimal non-destructive SQL for any schema changes you you need to synchronize, keeping your data safe.

System requirements

Access to MS SQL Server 2000 or 7.0

Limitations in the unregistered version

30 days or 50 runs trial
Nag screen

What's new in AdeptSQL Diff 1.98 Build 104:

Bug fixes:
Exception comparing table data: in the previous update (Build 103), the DataDiff data loader was changed to read the "true" value from a BIT column as 1, rather than -1. Unfortunately the change caused an exception when the BIT column contained NULLs. The problem is fixed now in Build 104: both NULL and non-null BIT values are loaded correctly (as NULL, 0 or 1).
Cutting/Pasting/Copying DataDiff scripts: with the SQL editor window opened from the DataDiff window, the Ctrl-C/V/X shortcuts were processed, incorrectly, by the data grid rather than the SQL editor window (even though it had the keyboard focus). This is fixed in Build 104.
Restored "Smart comparison" for expressions in DEFAULT/CHECK constraints: SQL Servers 2005/2008 have a silly habit of enclosing these expressions into an extra pair of parentheses, so that a "DEFAULT (0)" comes up as "DEFAULT ((0))". The older Server 2000 leaves such expressions unchanged, and this would cause false positives when comparing SQL2000 databases against SQL2005/8 ones. The "smart comparison" option in the Diff was introduced a long time ago to take care of this and other similar "false positives" in SQL expressions. In one of the previous updates the Diff stopped "peeling" the outer parentheses as a part of some other change, but that also prevented the "smart comparison" from detecting/ignoring the situation. Fixed.

Read the full changelog

DOWNLOAD AdeptSQL Diff 1.98 Build 104 for Windows