Change Data Capture
CDC is a poor man’s method of getting updates, deletes, and inserts from one database to another via the log reader. It uses a set of stored procedures and tables (change tables) on the source database side, but then pumps those data changes over to a target database pretty darn quickly with 100% data integrity. CDC as a DR option makes sense for those that can afford this type of data lag and who don’t mind having a spare DR site that is only as up-to-date as the last set of pushed changes (which is pretty darn good). Significant setup is required of change tables, additional stored procedures, and so on. It is not guaranteed to be real time, and sometimes resynchronizations need to be done to get the tables back in line. ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
