The change tracking feature of Data Transmission Service (DTS) retrieves real-time incremental data from a database for scenarios such as cache updates, asynchronous decoupling, real-time synchronization between disparate data sources, and complex ETL processes. Use this guide to create, monitor, and manage change tracking channels and consume tracked data.
Background information
-
Describes the supported databases and data types for change tracking.
-
Features
For more information, see Change tracking.
Change tracking process
To use DTS for change tracking, complete the following steps.
|
Workflow |
Description |
|
Prepare the source database to meet the environment requirements before you configure change tracking. |
|
|
Configure the change tracking task in the DTS console. |
|
|
|
|
Select a consumption method based on your client and database type: |
|
To stop a change tracking task, release the DTS instance.
|