O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Change Data Capture

An important concern, when dealing with data integration, is to detect which data has changed since the last time we accessed the source data location. It's required to avoid affecting source system operations and to make the process of reading data from a source location faster. It's better to get just the changed data, than extracting all the data.

Change Data Capture (CDC) feature was included in SQL 2008 version. It provides the possibility to detect change in data in a database. CDC seems to be one of the most powerful approaches as compared to the other known approaches such as audit columns, timed extracts, database log scraping, check sums, and others, CDC has low impact (does not require any changes into the main tables), ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required