SQLite 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.

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 SQLite Data Sync you can analyze the result of database contents comparison using difference elimination, sorting, and filtering.

One-click re-compare

SQLite Data Sync allows to save all options to a project file for instant re-execution.

SQLite Data Sync online Help

Data comparison