Synchronizing Tables to Target Destination
Tables can be synchronized on demand or via the scheduler. This section describes how to synchronize a table on demand. For information on scheduling tables for synchronization, please refer to
Designing a Schedule.
To execute an on demand synchronization task for a table:
1. Select the Tables tab.
2. Select a table or tables, and click the Sync button.
The target database for
Table Synchronizations is the database specified as the
Default Target in the
Sync Behavior Settings page.
The recommended synchronization for the select database is displayed. An Incremental Update is only available if a full reload has already been performed. Automatic will perform an Incremental Update unless the amount of changed records has exceeded the
Full Reload Threshold, or a unique key is not available for the table.
If Incremental Only has been selected, it will always incrementally update the table (the full reload threshold will be ignored).
CRC SavePoint and CRC Baseline are not used with Table Synchronizations. For more information on the CRC types, see the section on
Creating and Syncing Change Data Capture Transforms.
4. Click the OK button to start the synchronization process.
When the synchronization process starts, the application will switch to the
Overview Summary Page and will display the current status and progress of all running synchronization jobs.