This conflict occurs when the same row is deleted at one location and changed at the other. You have the option to keep the existing data (the data that won), overwrite the existing data with the data that conflicted with it (the losing data), or merge the winning and losing data and update the existing data.ĭelete conflicts. Insert conflicts occur when a row is inserted at one location that violates some data consistency rule when merged with changes at other locations. You have the option to keep the existing data (the data that won), overwrite the existing data with the data that conflicted with it (the losing data), or merge the winning and losing data and update the existing data. One change wins, and the other one loses. Update conflicts occur when the same data is changed at two locations. However, the Replication Conflict Viewer allows you to choose a different resolution for the conflict when necessary. Replication automatically resolves conflicts using the conflict resolver you selected when the article was created. Conflicts occur when the same data is modified at two separate servers, for example, at a Publisher and Subscriber, or at two different Subscribers. ![]() ![]() The Replication Conflict Viewer allows you to view any conflicts that have occurred during replication synchronization. ![]() Applies to: SQL Server (all supported versions)
0 Comments
Leave a Reply. |