Example: If we have a stock tracking table which each stock is updated thousands of times between synchronizations only the last value of the stock will be replicated.Advantages of Merger Replication: But if you decide that transactional replication with updatable subscription is best suited your needs then consider peer to peer transactional replication as an alternative to it, because transactional replication with updatable subscription is deprecated and will be removed in a future version of Microsoft SQL Server. Frequency of updates - If the frequency of updates is less, it is advisable to use updatable subscription.If frequency of updates is more, it is advisable to use merge replication.As the no of updates is more, the conflicts also more.If using queued failover option, run Queue Reader Agent for subscription initialization. Msg 20512, Level 16, State 1, Procedure sp_MSreplraiserror, Line 8Updateable Subscriptions: Rolling back transaction. is that poosible to have 10 publisher and one subcriber.i guess u have 1 publisher and 10 subscriber.Msg 3609, Level 16, State 1, Line 1The transaction ended in the trigger. publisher is one which is the primary data which publish data to its subscribers and in your case updates at the subscibe are also results o update on primary.Our experienced solutions architects set up most instances of SQDR in 24 hours or less.Request your fully supported trial today and find out just how easy data replication and change data capture can be.
Transactional replication does not scale well to multiple nodes, where as Merge replications are designed for large number of subscriptions.Microsoft SQL Server provides the following types of replication for use in distributed applications: Transactional replication.https://support.microsoft.com/en-us/help/315521This article serves as a basic guide for troubleshooting Microsoft SQL Server merge replication problems.The article provides guidelines and directions to ...If you create a publication with stored procedures, you can enable one or both options.When you create a subscription to the publication, you specify which update mode to use.
You can then switch between update modes if necessary.