2 out of 3 rated this helpful - Rate this topic

Change Data Capture

SQL Server 2008 R2

SQL Server 2008

Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred.

Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.

In This Section

The topics in this section describe how change data capture works and how you can configure a database for change data capture.

Overview of Change Data Capture: Describes how change data capture is implemented in SQL Server.
Configuring Change Data Capture: Discusses the steps necessary to configure change data capture.
Using Change Data: Describes how to use the data that is collected by using change data capture.
Administering and Monitoring Change Data Capture: Describes the change data capture agent jobs: capture and cleanup jobs, and support for data types.

Reference

The following topics contain reference information about the stored procedures, tables, and functions used with change data capture.

Topic	Description
Change Data Capture Stored Procedures (Transact-SQL)	Describes the stored procedures provided for use with change data capture, including the procedures used to enable change data capture on databases and tables.
Change Data Capture Related Dynamic Management Views (Transact-SQL)	Describes the views for displaying information about change data capture transactions and log sessions.
Change Data Capture Tables (Transact-SQL)	Describes the tables in which the change data and metadata is stored.
Change Data Capture Functions (Transact-SQL)	Describes the functions provided to query the change data, including functions for retrieving changes and for mapping between datetime values and log sequence numbers.

Concepts

Improving Incremental Loads with Change Data Capture

Change Tracking

Comparing Change Data Capture and Change Tracking

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD