Tag Archives: CDC

The Difference Between Change Tracking and Change Data Capture

Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems like these two items ought to be synonyms, but they’re separate features. They are similar, but there are some differences, … Continue reading

Posted in Blog | Tagged , , | 5 Comments

SQL Server 2008 – CDC Retention

I had done a little work with CDC last year, experimenting with the way that it handles changes in your database. Someone had asked me the question about the retention period since the default of 3 days was not sufficient … Continue reading

Posted in Blog | Tagged , ,