• Overview
• Features
• What's New
• Requirements

What's New

Datanamic DataDiff 2011 provides a faster and more efficient way to compare and synchronize your database data, with updated, faster comparison routines, comparison options, filtering, and a new differences viewer.

Filtering With a Where Clause

You can filter the records that will be compared by using a WHERE clause for a pair of tables.

You can define a where clause for the source table and the destination table. By default the same filter (where clause) will be used for the source and destination table.

Filtering is useful, for example, if you want to exclude a particular set of data, or to speed up the comparison.

Automatically Exclude Fields From the Comparison

Fields that have a name that matches one of the names you have added to the list of fields to be excluded will be excluded from comparison and/or synchronization automatically. The compare and synchronize checkbox in the Field settings dialog will be disabled for these fields then.

This functionality is very handy when you want to automatically exclude audit columns like last_modifieddate etc.

Improved Differences Viewer

Navigate quickly between compare differences of compared tables by clicking on the "different", "source only" or "destination only" tab. All compared columns will be visible. If you want you can hide the columns without differences. Mapped columns are grouped in a single column in the differences grid. The field differences are displayed in that single column.

New Comparison Options

Now you can control what is seen as a difference. Ignore spaces, ignore case, ignore specific date/time parts such as seconds, match NULL to an empty string etc.

Does your source and destination database use different collation settings? No problem. Check the option to ignore these collation settings during comparison.

There is more. See a complete version history.