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.