Can CDC replicate data?

  • As far as I can tell all CDC does is capture and log data changes, can it also replicate like transactional replication?

    There is an exception to every rule, except this one...

  • Not natively out of the box, but you could write routines and SSIS packages to do the replication aspect for you.

    But saying you have CDC enabled, I'd just stick TX replication over the top of it also, it's not going to add much of an overhead as you already have the log reader running for CDC anyway, you just add the distribution load which you're going to get by having do hand crank some form of manual replication via procs/SSIS etc.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply