Features

Supports multiple database platforms
Direct access (native drivers) to Oracle, MS SQL Server, MySQL, PostgreSQL, InterBase and Firebird.

Data comparison for several tables at once
You can make a selection of the tables you want to add to your comparison project. In addition you can refine this selection by making a selection of the tables you want to compare right before the comparison starts.

Map tables in source and destination database
DB Data Difftective automatically maps tables with the same name for your. If DB Data Difftective is unable to map tables those tables can be mapped manually. Table mapping allows you to compare tables with different names.

Map columns in source and destination table
Columns of mapped tables will be mapped automatically. If you want to compare columns in a table and the column names are different, you can map the columns as required.

Custom comparison keys
To match rows in two tables, DB Data Difftective requires a comparison key for each table. A comparison key is automatically selected if your tables contain a matching primary key, unique constraint or unique index. You can also define your own comparison key (any combination of the fields of that table). This means that you can compare tables based on any field (even non unique fields).

Synchronize directly on database or generate synchronization SQL script
After you compare tables, you can either update the destination to synchronize the databases or export a update script (synchronization script) with insert, update and delete statements. You might want to generate a SQL script so that you or someone else can review it before you apply the changes.

Generate database specific synchronization scripts
For each supported database, database specific SQL is used in the synchronization scripts.

Data comparison across database versions
You can compare and synchronize each database you have access to. Furthermore, the databases do not have to be of the same version – you can compare between for example a MySQL 4 and a MySQL 5 database.

Validation of compare settings
It is for example possible that a column in a source table allows nulls while the mapped column in the destination table does not allow nulls. DB Data Difftective will automatically warn you about these kind of potential problems.

Exclude columns from the comparison
By default, the first time, all columns with identical names are selected for comparison. In the Edit column settings dialog you can exclude columns for comparison when they are not part of the comparison key.

Project oriented architecture
Save database connections, compare settings and the list of tables to compare and/or synchronize.

Option to disable triggers
Sometimes when synchronizing data you do not want a trigger to fire. DB Data Difftective gives you the option to disable triggers for the tables you want to update. The triggers are restored after the synchronization process.

Detection of metadata changes
When you refresh the tables (Project | Refresh tables) in an opened project or when you re-open an existing data compare project, DB Data Difftective automatically reads the database and detects when a column or table has changed or has been deleted. It will then automatically apply this change to the table(s) in the project.

Easy navigation through the data differences
A tabbed and colour-coded comparison overview makes it easy to pinpoint at a glance similarities and differences between data in two tables. Inserts, updates, deletions and identicals are displayed in individual tabs.

Refertial integrity support
DB Data Difftective handles data dependencies and referential integrity during comparison and synchronization.