Sep 20th 2010
Database schema difference viewer and synchronization tool for MS SQL Server
User rating |
944
1.0
|
Downloads | 9363 |
File size | 4.4 MB |
OS | Windows All |
Company |
Adept SQL Tools
|
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.
Access to MS SQL Server 2000 or 7.0
30 days or 50 runs trial
Nag screen
Thank you very much