Datanamic DataDiff MultiDB 2011
Compare and synchronize
database data
Version History
Version 2011.04
- Fixed an issue with connecting to a MySQL 5.5.12 database (Bad Handshake error).
Version 2011.03
- Fixed an "Out of memory" issue with comparing very large tables (columns and records).
- Fixed an issue with comparing MS Access memo fields when the source or the destination field was a memo and the other field was not a memo field.
- When your table does not contain a primary key or a unique constraint, all columns were added to the comparison key. This could cause an error when your table contains columns with a binary data type. These column can not be part of the comparison key. Fixed.
Version 2011.02
- Fixed an issue with comparing data in mapped columns with different names in combination with ignore database collation setting.
- Changed type group of the MS SQL Server SQL_Variant data type from Exact Numeric to String.
Version 2011.01
- Added comparison options such as case-insensitive comparison, ignore
spaces, match NULL to empty string,...and more.
- Added synchronization options such as disable foreign keys.
- Added a command line utility that can be easily configured through the
DataDiff interface and allows you to schedule the comparison and
synchronization operations via a scheduler application.
- Comparison results grid has been modified. Improved overview of the
differences.
- Added functionality to save the comparison results to CSV files.
- Improved comparison performance.
- Added the option to hide columns without differences in the comparison
results grid.
- Added a binary field viewer to the comparison results grid.
- Data filtering with WHERE clause for source table and destination table.
- Improved data conversion when synchronizing columns with different data
types.
- Redesigned the compare and synchronize dialog.
- Extended detection of potential synchronization errors.
- You can now exclude multiple columns for comparison and/or synchronization
by defining an exclusion list on project level.
- Redesigned the New project dialog.
- Added the option to compare tables/columns with different collation
settings.
- Fixed an issue with the syntax of MySQL update statements when one or
more of the comparison key fields contained a NULL value.
- Fixed an issue with column names containing spaces.
- Fixed an issue with deleting temporary files.
- Added PostgreSQL 9 support. (PostgreSQL, MultiDB and CrossDB edition)
- Added MS SQL Server 2008 support. (MS SQL, MultiDB and CrossDB edition)
- Added MS Access support. (MS Access, MultiDB and CrossDB edition)
- Added support for cross database platform data synchronization. (CrossDB
edition).
- Improved detection of metadata changes when loading an existing comparison
project.