Administration

Question 1

What is CDC?

Answer 1

Change Data Capture

Question 2

What is change tracking

Answer 2

It’s a lightweight version of CDC, all it tells you is what rows have changed.

Question 3

What is the difference between CDC and change tracking

Answer 3

CDC can tell you what type of change was done to each row, when they were done and even what columns were modified. Change tracking simply tells you if a row has been modified.

Question 4

What are some requirements before you can turn on CDC on a table?

Answer 4

You need enable CDC for the database and you need a unique constraint on the table (a PK or just a unique constraint)