Change Data Capture (CDC) – SQL Server 2008 Video

Leave a comment (1) Go to comments

Change Data Capture (CDC)  is a new feature of the database engine in SQL Server 2008. It enables you to capture insert, update, and delete commands that are executed against one or more tables in a database. The changes that are made to a table are stored in a relational format, making them easy to consume by your applications.

The changes that occur are tracked in a change table that stores the change alongside metadata that is relevant to the recorded change. In the case of inserts and deletes, the change table stores one row that records the row that was inserted or deleted. In the case of an update, the change table stores two rows: one for the before image of the data and one for the after image.

You can use CDC either to return all changes to a row, or just to return the net changes. For example, if a LastName column in a row is changed twice, you can either view both changes as they occurred or just the final content of the row.

When you enable CDC for a table, new tables and functions are added to the database to enable you to review the changes that have been made to the data. In addition, two SQL Server Agent jobs are created. One job is used to populate the database change tables and the other is responsible for cleaning up the change tables. These jobs are pivotal to the CDC process, so SQL Server Agent must be /running for CDC to be enabled.

***** CDC is only available in SQL Server 2008 Enterprise, Developer, Data Center and Evaluation editions only.


Video Tutorial

Video – Change Data Capture (CDC)

EOF - Change Data Capture (CDC) – SQL Server 2008 Video, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: