During data consumption, you can edit the consumption checkpoint of a change tracking task based on your business requirements. After you edit the consumption checkpoint, the downstream SDK client will consume the data that is generated after the specified time.



To perform this operation, you must restart all downstream SDK consumption processes. We recommend that you perform this operation during off-peak hours to prevent service interruptions.


  1. Stop all downstream SDK consumption processes.
  2. Log on to the DTS console.
  3. In the left-side navigation pane, click Change Tracking.
  4. At the top of the Change Tracking Tasks page, select the region where the change tracking instance resides.
  5. Find the change tracking task, move the pointer over the Consumption Checkpoint column, and then click the Edit icon icon. Edit the consumption checkpoint
  6. In the Edit Consumption Checkpoint dialog box, specify a new consumption checkpoint.
    Note The selected time range must be within the time range of all tracked data changes. For more information, see the prompt in the dialog box.
    Edit the consumption checkpoint
  7. Click Edit.
  8. Restart the downstream SDK consumption processes.


Use the SDK demo code to consume tracked data