Sql server replication

  • 4ddba

    SSC Rookie

    Points: 28

    Does sql replication save changes before applying them on the destination like change data capture does

  • Sue_H

    SSC Guru

    Points: 90000

    4ddba - Wednesday, October 24, 2018 9:13 PM

    Does 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

  • Bart Lewandowski

    Ten Centuries

    Points: 1079

    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.

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

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