Tracking Data Changes
An important requirement for some applications to be efficient is the ability to query for data that has changed in a database. Typically, to determine data changes, application developers had to implement a custom tracking method in their applications by using a combination of triggers, timestamp columns, and additional tables. Creating these applications usually involved a lot of work to implement, led to schema updates, and often carried a high performance overhead.
SQL Server 2008 provides the following new technologies that application developers can use to track data changes and enable applications to query for only the data that has changed:
Change data capture
Change tracking
In This Section
Comparing Change Data Capture and Change Tracking
Compares change data capture and change tracking.Change Data Capture
Describes the change data capture process, how to configure, administer, and use change data capture.Change Tracking
Describes the advantages of using change tracking, how to configure, manage, and use change tracking.