What data will not be synchronized?

Last modified: August 8, 2024

When you synchronize the data sources, bear in mind that some rows may not be synchronized if:

• There are triggers defined on the tables

To work around the issue, select the Disable DML triggers option in the Data Synchronization Wizard before generating a synchronization script.

• Primary keys are defined on columns that have different collations

If you try to compare tables that have primary keys defined on columns with different collations, the results might be unpredictable.

• Tables having nonidentical structures

In case the structure of the tables you are synchronizing is not identical, the outcome might be unpredictable.

Primary keys and indexes that will not be dropped for synchronization

When you select the Disable primary keys and indexes option in the Data Synchronization Wizard, bear in mind that primary keys, indexes or unique constraints that are selected as comparison keys will not be dropped for the synchronization.