These tips apply to DBConvert Studio. The classic DBConvert and DBSync pair tools use a different interface - for example, what Studio calls a job is a session there - so the buttons and options below may look or behave differently.
1. Cloning saved jobs
Use the Clone button to duplicate any saved job. For example, you made a Copy data job from source to destination, and now you need to synchronize the same databases. Instead of creating a new job and re-selecting servers and databases, select the existing job, click Clone, and reconfigure it.
In the Clone job dialog, choose a new name (if needed) and a Migration type.
Click OK to save the changes. The cloned job appears in the Migration jobs bar.
2. Load destination structure
The Load destination structure checkbox controls whether the destination structure is read in:
- If it is not ticked, the destination structure is not loaded for reading.
- If it is ticked, the destination structure is loaded for reading. Enable it when you plan to reassign fields.
3. Trigger-based sync options
When you use trigger-based sync, two extra options control how triggers are created and maintained. For the full workflow, see trigger-based synchronization.
Track only source
Check Track only source when you need triggers on the source side only. Use it when the data in the destination database does not change from the outside. If you load an existing session where triggers were created on both sides, check this option to delete the triggers in the destination database.
Update sync triggers
Tick Update sync triggers to update the triggers on the source and destination automatically. Use this option when:
- the triggers' logic has changed;
- you need to re-configure already created triggers - for example, the time has changed on a synchronized side, or the job now uses a different database on the destination side.
4. Monitoring synchronization processes
DBConvert Studio can monitor the synchronization process between two systems. The number of records added, updated, or deleted is recorded in the operation log.
5. Truncate table
Click Tables in the tree-view, or a specific table, to find the Truncate table option. Use it when you need to delete all records in the destination table or tables.
Note: do not enable any overwrite option together with truncate - otherwise the structure is overwritten along with the data.
For the Chunk size option shown here, see database and table options.
6. Jobs and connections recovery
If a crash occurs and jobs or connections are damaged - for example, something happened to the settings file - they are restored automatically on the next start. When you notice that jobs or connections are damaged, close the program and reopen it.