Product Home
DTM Data Comparer Online Documentation Prev Page Prev Page
General
Product profile
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Comparison
Synchronization
Table to Table Mode
Synchronous Navigation
Face-to-Face View
Database Mode
Key Definition
Column Mapping
Settings
General Settings
User Interface
Comparison Settings
Synchronization Settings
Report Settings
Project Properties
Script Viewer
Command Line
Console Mode
Process Cancellation
Comparison Report
Collate Window
Run SQL statement
SQL Console
Hot Keys
Information
Limitations
Support
License
Demo and Full versions
Install
How to buy
Upgrade
Uninstall
Products
Trademark Information
Glossary

Execute Synchronization Script

During synchronization process the program creates a set of insert, update and delete statements for data synchronization. The user can select the necessary statements or forbid the unnecessary ones in a special dialog box.
Also, he or she can save the produced set of SQL statements to a file on the disk with the statement delimiter specified in the settings.
COMMIT statements will be added according to settings as well as SET IDENTITY_INSERT ON/OFF.
The program shows total number of generated synchronization statements at the left bottom corner of the window.

DTM Data Comparer: Synchronization script viewer screenshot

See also: synchronization process.