{"id":816,"date":"2015-04-24T16:52:44","date_gmt":"2015-04-24T15:52:44","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=816"},"modified":"2015-08-14T12:11:55","modified_gmt":"2015-08-14T11:11:55","slug":"what-is-change-data-capture-cdc-in-sql-server-2008","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/what-is-change-data-capture-cdc-in-sql-server-2008\/","title":{"rendered":"#SqlServer interview question: What is Change Data Capture (CDC) in SQL Server 2008?"},"content":{"rendered":"

Another innovative feature in SQL Server 2008 is Change Data Capture (abbreviated as CDC). The concept is similar to Change Tracking but with a major difference.<\/p>\n

CDC tracks every field in your table(s) \u2013 not just the primary key fields. Change Data Capture (CDC) records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables and makes a record available of what changed, where, and when.<\/p>\n

The changed records in CDC are presented in simple relational change <\/em>tables <\/em>rather than in an esoteric chopped salad of XML. These changed tables contain columns that reflect the column structure of the source table you have chosen to track along with the metadata needed to understand the changes that have been made.<\/p>\n

 <\/p>\n

Thanks for reading this article,<\/strong><\/p>\n

Next steps :<\/strong><\/p>\n

    \n
  1. Share this with your colleagues because Sharingis Learning<\/strong><\/li>\n
  2. Comment below if you need any assistance<\/strong><\/li>\n<\/ol>\n

    Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n

    Share this:<\/h3>