Controlling Updates for Incremental Subscriptions

The polling interval for a group of incremental subscriptions affects when updates are applied to the destination. For example, if you want the updates to be applied to the destination database only once per day, you would set the poll interval to be greater than 24 hours, such as a value of 25 hours. After the baseline replication for the subscription is created, updates will be applied to the destination only when the source is polled for changes at the specified interval.

In addition to polling the source for change data you can configure SQDR Plus and the incremental subscription to receive a notification when changes are committed to the source. When the subscription receives notification that changes are available, the changes are then applied to the destination immediately instead of waiting for the normal polling cycle. The topic Configuring a Source for Incremental Replication describes how to configure the source to receive notifications. Refer to your SQDR Plus documentation for information about configuring the Capture Agent to send change data notifications.