Post reply

Sql server replication

  • October 24, 2018 at 9:13 pm

    #375783

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

  • October 26, 2018 at 5:35 pm

    #2011434

    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

  • October 29, 2018 at 2:47 am

    #2011486

    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