Search code examples
sql-serverreplication

Replication Conflict detection by custom column


I am going to setup Merge replication as Bidirectional. As you know in merge replication, conflict detect by rowguid and it makes problem for me.

When the subscriber create a row for example third row and publisher also create third row, in the time of sync publisher remove record of subscriber because of conflict, but I need that it doesn't detect third row as conflict according to value of other column, is it possible?


Solution

  • Following link explain about my question well:

    https://learn.microsoft.com/en-us/sql/relational-databases/replication/merge/execute-business-logic-during-merge-synchronization?view=sql-server-2017 .