Change Tracking and Change Data Capture
Adam Aspin · Apress eBooks · 2012
This chapter focuses on two core techniques that allow you to detect modifications to source data and consequently update a destination table with the corresponding changes. Using their most simplistic definitions, these techniques are Change Tracking : Detects that a row has changed. Lets a process return the latest version of the data from the source table. Change Data Capture : Detects that a row has changed. Stores all the intermediate changes, as well as the final state of a record.