What is Change Data Capture in SQL Server ?

Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred.



You May Interest

How is Change Tracking is Different From Change Data Capture ?

Creating a Stored Procedure in MS SQL

What are the System Data Collection Sets Predefined Inside SQL Se ...

What is an Index in SQL Server ?

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...