MS SQL Data Sync online Help

Return to chapter overview

Specify here rules to be used for data comparison. Check the corresponding boxes to ignore case, or/and trailing and leading spaces.

If you need to compare large amounts of data it's recommended to turn On the Store intermediate result on disk option.

The Behaviour options group allows you to limit the synchronization process by processing only different records (the Update target records option), or/and rows that exist in the source table but not in the target one (the Insert records from source to target option), or/and rows that exist in the target table but not in the source one (the Delete records from target option).

By default, identical records are not displayed in the Data differences view because the process can take some time, but it's possible to add/exclude the Identical records tab to the differences display.