Configure synchronization options
After you have selected the objects for synchronization and have configured the synchronization output, you can use the Data Synchronization Wizard to set synchronization options.
How to configure synchronization options
To configure data synchronization, click the Options tab to view all the synchronization options. For your convenience, each option has a detailed description.
Note that the options can be grouped.
To configure the synchronization, select or clear checkboxes in the list of options.
To locate a required option, you can also type the search text in the Search box. The search is not case-sensitive.
Note
If you want to use the options you have set later, click Save As My Defaults.
If you want to apply options you have saved earlier, click My Defaults.
It is also possible to return to the default settings of the tool. Click Devart Defaults if you want to do it.
After you’ve configured the synchronization options, click Synchronize.
Data Compare synchronization options
| Default State | Option Group | Option Name | Option Description |
|---|---|---|---|
| Disabled | Common | Check for concurrency updates | When selected, the UPDATE and DELETE commands will be supplemented with the non-key values in the WHERE condition and the IF NOT EXISTS statement will be added before the INSERT command. This will allow avoiding accidental data rewriting on live databases. For example, UPDATE PassTable SET. |
| Disabled | Common | Convert Archieve Engine to InnoDB | Convert Archieve Engine to InnoDB for UPDATE/DELETE operations possibility. |
| Enabled | Common | Include USE |
When selected, the USE |
| Disabled | Common | Use COMMIT after every 100 statements | Insert COMMIT statement after each defined number of DML statements. |
| Enabled | Common | Use Bulk Insert (Bulk Size: 300 KB) | Specifies if the multirow INSERT should be used to increase the data insert performance and the bulk size limit. When cleared, the single-row INSERT is used. |
| Enabled | Common | Disable foreign keys | When selected, foreign keys will be dropped in the beginning of the synchronization. After the synchronization, foreign keys will be restored. |
| Disabled | Common | Disable primary keys and indexes | Select to drop primary keys and indexes ar the beginning of the synchronization process. The primary keys and indexes will be restored after the synchronization process. If either the primary key or the index is the comparison key, it cannot be dropped. |
| Disabled | Common | Disable check constraints | When selected, check and not null constraints will be dropped at the beginning of the synchronization process. After the synchronization, check and not null constraints will be restored. |
| Enabled | Common | Disable DML triggers | Select to disable DML triggers in the beginning of the synchronization. After the synchronization, they will be enabled. |
| Disabled | Script Comments | Exclude comments | When selected, comments generation will be prevented in synchronization script. |
Want to Find out More?
Overview
Request a demo
