Change Data Capture (CDC) in SQL Server efficiently tracks data modifications, essential for auditing and ETL processes, ensuring a comprehensive historical data record.
When CDC is enabled, SQL Server creates change tables that store detailed modification information, including before and after data for updates and records of inserts and deletes.
CDC uses the SQL Server Transaction Log to capture changes without interfering with transaction flow, enabling the tracking of data at the moment transactions are committed.
Change data is retained in CDC change tables for a default period of 3 days, with a cleanup job managing the removal of older data to help conserve space.
Collection
[
|
...
]