• schleep (2/18/2014)


    When you say, "Replication ALWAYS delivers data transactionally" do you mean in the same order as the changes were made in the source?

    Yes. The order in which they are written to the transaction log on publisher, they are written to the distribution db by the log reader, then committed on the subscriber by the distribution agent. It doesn't matter if its transactional or merge replication (the same applies for mirroring and log shipping), transactions are applied in order for consistancy