Change Tracking and Change Data Capture

Abstract

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.