Configure Synchronization Options

1. Press an arrow button to specify the synchronization direction
2. Configure the Insert/Update behavior
   • Insert missing record - the missed records will be inserted into the target table
   • Update different record – different records will be updated on the target side with source side data
   • Delete obsolete record – record, found on the target side but not on the source side, will be deleted from target table
3. Specify whether you want to perform synchronizing immediately or just create the synchronization script.
   • Execute synchronization immediately - the synchronization will be performed immediately after clicking OK button
   • Save synchronization script - the synchronization script will be created.
         Note: You can select both options. Then both synchronizations will be performed and the script will be created.
     The following options become available if the Save synchronization script otion is selected
   • Ignore target schema name - target schema name will be omitted if the option is selected.
   • File Type -> Binary(BSQ) - synchronization script will be created in CDBS specific binary format.
   • File Type -> Text ASCII(TXT) - synchronization script will be created in ASCII format.
   • File Type -> Text Unicode(TXT) - synchronization script will be created in Unicode format.
   
   Remark:
   The further execution of the binary formatted script can be performed by CDBS software only. The execution of Unicode or ASCII formatted scripts can be performed by both CDBS software and any third party application that supports SQL script execution.
   Usage of binary data in SQL script is very resticted and even impossible in some cases. So if the synchronization script is about to contain binary data, it is preferable to use BSQ format.
4. Select one of the following Error Handling options:
   • Ignore errors - the synchronizing will be continued despite errors. All the changes will be committed anyway.
   • Up to first error - the synchronizing will brake on the first error and all the changes will not be committed.
   • Up to end - the synchronizing will be continued despite errors but any changes will not be committed if an error have been occurred.
5. Scheduling – define data and type to start synchronization. For repeated processes, set Scheduling.

• Synchronization - overview
• Synchronize Indexes
• Synchronize Table Structure
• Synchronize Primary Keys
• Synchronize Foreign Keys
• Synchronize Stored Procedures
• Discrete manual data synchronization
• Synchronize table Data
• Batch Synchronization