October 24, 2018 at 9:13 pm
Does sql replication save changes before applying them on the destination like change data capture does
October 26, 2018 at 5:35 pm
4ddba - Wednesday, October 24, 2018 9:13 PMDoes sql replication save changes before applying them on the destination like change data capture does
What type of replication? Snapshot I don't see how it would matter or apply, merge would be a bit complicated so pretending it's transactional,...
Replication itself doesn't save anything. It's a process of copying transactions. If you rollback a transaction, it won't be in the distribution database. You can check by executing sp_browsereplcmds in the distribution database after rolling back a transaction in the publisher. So in that sense, its replicating committed transactions.
Sue
October 29, 2018 at 2:47 am
if we are talking about transactional the only place that the changes are logged is distribution database in msrepl_transactions and msrepl_commands. as Sue mentioned you can read these by using sp_browsreplcommands. sp_browsereplcmds
The distribution database will only have committed changes.
BartL
Replication Blog
Viewing 3 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