Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities applied to SQL Server tables and to avail those changes in an easy-to-understand format. Conventionally, detecting changes in a source database to transfer these changes to a data warehouse required any of the following:… Continue Reading...
Source: SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008 | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment