Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sourvil
Starting Member
14 Posts |
 Posted - 2009-01-02 : 06:29:24
|
| Hi friends,I have a similar situation which is like on [url]http://www.developmentnow.com/g/114_2006_9_0_0_821091/merge-replication-and-rollback.htm[/url] page. I use SQL Server 2005 Enterprise Edition for publisher and SQL Server 2005 Express Edition for all (pull) subscriptions.We developed our .net windows application regarding this article. [url]http://msdn.microsoft.com/en-us/library/ms147890.aspx[/url]Everything works fine until now.But, can't i use transaction on merge replication. Because my (average) replication duration is 5min. (yeah big data traffic :)And sometimes our connection is dropped during the synchronization. And we have foreign key/unique index tables. So, data dismathc will occur and we want to rollback transaction by ourself. But i can't figure it.I can't believe that there is no transaction support in Merge Replication. There must be a way? If there isn't, it is so useless for real life!Regards. |
|
|
sourvil
Starting Member
14 Posts |
Posted - 2009-01-13 : 07:26:56
|
| If someone interests in this topic, there is no Transaction Support in Merge Replication.There is Transaction Support in Transactional Replication. |
 |
|
|
|
|
|
Transaction Support in Merge Replication