March 5, 2024 at 1:13 pm
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...
March 5, 2024 at 1:49 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy