Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

SQLite Data Sync online Help

Prev Return to chapter overview Next

Data comparison

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.

 



Prev Return to chapter overview Next