Administration Flashcards
1
Q
What is CDC?
A
Change Data Capture
2
Q
What is change tracking
A
It’s a lightweight version of CDC, all it tells you is what rows have changed.
3
Q
What is the difference between CDC and change tracking
A
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.
4
Q
What are some requirements before you can turn on CDC on a table?
A
You need enable CDC for the database and you need a unique constraint on the table (a PK or just a unique constraint)
