In merge replication how can i make the upload or the download to happen in one transaction, failure or success.

Question

In merge replication how can i make the upload or the download to happen in one transaction, failure or success ? so it will be possible to rollback all the changes if some error occurred during the process...

Answer 1

I don't think there is a way to do this with Merge.  Some applications are able to tolerate this and some cannot.  With Merge I tend to rely on agent alerts, custom monitoring, and tuning to avoid unwanted scenarios for my applications.

Are you encountering errors during processing?

---

Brandon Williams (blog | linkedin)

Answer 2

Yes,It is not possible,but Every change during the transaction commit or rollback is stored in Metadata catalog of replication and replicated accordingly.

Answer 3

Yes, error may occur, so in this case i need the transaction to fail and every change to rollback

Answer 4

I don't think there is a way to do this with Merge.  Some applications are able to tolerate this and some cannot.  With Merge I tend to rely on agent alerts, custom monitoring, and tuning to avoid unwanted scenarios for my applications.

Are you encountering errors during processing?

---

Brandon Williams (blog | linkedin)

There should be some way around, is there any other way to group the changes in one transaction and upload or download it ? I know logical records is doing something like this but it is going to be removed soon, so what is the alternative ? any idea ?

Answer 5

If Your transaction will be rolled back all changes from subscriber side will also rollback(As per Replication theory).