DB2 Data Sync online Help

Return to chapter overview

DB2 Data Sync automatically maps tables with the same names, but you can adjust auto mapping rules more carefully. Check the corresponding boxes to set Data Sync to ignore autoincrement, timestamp, BLOB, and GUID columns.

Ignore columns by mask

You can also set a mask to for column names to be ignored. Suppose, you have several columns such as 'user_last_modified', 'country_last_modified' and so on, those are not to be synchronized. Specify the mask as follows to ignore these columns on auto mapping.

Return to chapter overview

Company news

Mar 20, 2024

Data Syncs have been upgraded

New version comes with support of all the modern database server versions available at the moment.

Apr 11, 2016

Data Syncs 16.4 released

This version introduces cross-DBMS data comparison with native support for the most popular database servers, email notifications, and more.

Mar 16, 2015

Data Syncs advanced to version 15.3

New version features an ability to select or disable certain synchronization operations, executing SQL scripts before and after processing each table, a brand new start page, connectivity enhancements, and some other useful things.

More news

Feature of the day

Data differences view

With DB2 Data Sync you can analyze the result of database contents comparison using difference elimination, sorting, and filtering.

Synchronization scripts

DB2 Data Sync allows you to generate error-free synchronization scripts.

DB2 Data Sync online Help

Auto mapping