Change Data Capture

What is Change Data Capture?

CDC is acronym for Change Data Capture. This is one of the new feature added from SQL Server 2008. CDC helps us to provide information about DML changes on a table and a database. It provides these information’s in relational format. In previous versions of SQL Server we use triggers, timestamp columns etc., to capture the DML changes to the table which is resource expensive techniques, so to overcome this MS added this new feature.