This sample script walks through some of the Microsoft Change Data Captures functions. Copy and past the script into SQL Server Management Studio and execute each command. Sample output is included in the script. This demo is based on the [AdventureWorksLT2008] database USE [AdventureWorksLT2008] GO -- Create Sample table used for CDC Demo CREATE TABLE
Read More »
SQL Server 2008/R2 Audit Triggers for Change Data Capture changes_tables table — — FILENAME: CDCchange_tablesAudit.SQL — — AUTHOR: Chris Skorlinski — — DESCRIPTION: SQL Server 2008/R2 Audit Triggers for Change Data Capture changes_tables table. — This script is used to audit the activity in the changes_tables table created when — you enable Change Data Capture
Read More »
Content Provided by: Paul King, Microsoft One of the most important things to watch out for with change data capture is the transaction log I/O subsystem. As stated earlier, log file I/O significantly grows when change data capture is enabled in a database. In addition to that, log records stay active until change data capture
Read More »
Change Data Capture feature of SQL 2008 is based on Transactional Replication. CDC and Transactional Replication used the same internal stored procedure sp_replcmds to retrieve data updates from the transaction log. However, unlike Transactional Replication, CDC does NOT require the tables to have a unique index (or Primary Key). In fact CDC can be use
Read More »
I’m developing in-depth training on Change Data Capture and created this BLOG posting as a reference for BOL topics and Web links I found helpful while researching CDC. I’ll update this posting with more links as time goes by. I hope you too find these helpful. Basics of Change Data Capture (great chart and overview
Read More »