How is Change Tracking is Different From Change Data Capture ?

The tracking mechanism in change data capture involves an asynchronous capture of changes from the transaction log so that changes are available after the DML operation. In change tracking, the tracking mechanism involves synchronous tracking of changes in line with DML operations so that change information is available immediately. In Change Data Capture Historical Data is tracked and in Change Tracking Historical Data is not tracked.



You May Interest

Disable All Triggers in MS SQL Server Table

What is the Difference Between Clustered and a Non-clustered Inde ...

MS SQL Getting a Random Row in a Table

MS SQL Compiling a Stored Procedure With a Requery

What is the Bookmark Lookup and RID Lookup in SQL Server ?