O'Reilly logo

Fundamentals of SQL Server 2012 Replication by Sebastian Meine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12: Merge Replication – Conflicts

Merge replication allows data changes to be synchronized between the Publisher and one or more Subscribers. If a row in a published table at a Subscriber changes, the change will be replicated to the Publisher during the next synchronization with that Subscriber. From there, the change will be propagated to the other Subscribers during their next synchronizations.

Such a system opens up the possibility for conflicts. For example, suppose someone changes a customer's phone number on Subscriber A, and then someone else changes the same phone number on Subscriber B, but to a value different from the one on Subscriber A. If Subscriber A is synchronized before Subscriber B, the Publisher will accept the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required