O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing change tracking methodology

Change Data Capture (CDC) and Change Tracking (CT) can be classified as the same names but both have different purposes, which are introduced in the SQL Server 2008 version.

CDC is an asynchronous process mechanism that captures all changes of a data row from the transaction flow and stores them in change tables. CDC is useful in avoiding the expensive query methods such as triggers or multiple-join to capture the changes made to the data.

CT is a light-weight synchronous mechanism that tracks data modifications but records only the fact that the row has been changed, like writing leaf level information of modified data. CT is very useful to represent a consistent view of modified data and detect data conflicts ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required