Synchronization - overview
In the context of Cross-Database usage, the term "synchronization" is understood as the elimination of differences found during comparison. Therefore the synchronization process always includes two consecutive steps:
- Searching for differences - comparison
- Eliminating the differences – the synchronization itself
Cross-Database Studio provides two groups of synchronization features:
- Synchronizations with explicit prior comparison. The group includes
• All these tasks can be performed only after the comparison of the objects, that are about to be synchronized, has been performed.
- Synchronizations with implicit prior comparison:
- Synchronize single table/view data
- Synchronize batch (mass) tables/views data
• These tasks are being performed without prior explicit comparison. The required comparison is being performed implicitly.
• The synchronization tasks included into second group can be fully automated and scheduled. See Batch Synchronization
Synchronization is affected by Comparison Options, SQL Vendor Specifics, Filters, Conversion Rules and Database Connection Objects Settings
See also: