Synchronization Settings
OptionDescriptionDefault
Delete from secondaryDisabling this option will block deleting a record from the secondary table even if there is no such record in the primary table.
See also -d command line switch.
Yes
Insert by primaryDisabling this option will block adding records from the primary table even if there are no such records in the secondary table.
See also -a command line switch.
Yes
Update secondaryDisabling this option will block updating existing records in the secondary table.
See also -u command line switch.
Yes
Do not execute scriptWhen this option is switched on, the program will create synchronization script without executionNo
Show synchronization scriptsThe option helps to enable or disable SQL preview window.Yes
Stop on errorStops script execution when the first error occursYes
Rollback on errorRollback script execution if the error occurs. Important: stop on error option must be switched on.
It is not compatible with "auto-commit" mode.
Yes
Replace empty strings by NULLThe program generates NULL value for empty string if this option is switched onNo
Add COMMIT statementThe program will add COMMIT statement to output script if this option is turned on and transaction size is specified.No
Transaction size0 for auto-commit mode, i.e. one statement per transaction0
Default synchronization script locationProduct level output file name* for synchronization script. $DATE$ and $TIME$** macros can be used as a part of the synchronization script file name.No script
IDENTITY modes (Microsoft SQL Server only)The program can skip identity columns or insert/modify them for the target (secondary) table.Ignore identity
SQL statements delimiterThe program will add this string after each produced SQL statement. You can select it from the list or enter manually.No delimiter
Date Conversion functionDate conversion function helps to compare databases with different date/time format.No conversion
GUID Conversion modeThe conversion is required for some database pair.No conversion

* - file name without a path will be created in the current user's personal folder.
** - in most cases, the new script will be created for each execution for $TIME$ macro in the file name.

DTM Data Comparer: Synchronization settings page