Using Change Tracking

Applications that use change tracking must be able to obtain tracked changes, apply these changes to another data store, and update the source database. The topics in this section describe how to perform these tasks, and also the role change tracking plays when a failover occurs and a database must be restored from a backup

In This Section

• Obtaining Changes by Using the Change Tracking Functions
  Describes how to use the change tracking functions to obtain changes and information about the changes that were made to a database.

• How Change Tracking Handles Changes to a Database
  Describes how to make changes in a database when change tracking is enabled.

• Change Tracking and Data Restore
  Provides information about how to use change tracking reliably when a data restore operation occurs.

See Also

Reference

CHANGETABLE (Transact-SQL)

CHANGE_TRACKING_MIN_VALID_VERSION (Transact-SQL)

CHANGE_TRACKING_CURRENT_VERSION (Transact-SQL)

WITH CHANGE_TRACKING_CONTEXT (Transact-SQL)

Concepts

Change Tracking Overview

Configuring and Managing Change Tracking