We have two MS SQL Server 2012 servers running merge replication. We have used the SQL Server DATETIME (Later Wins) Conflict Resolver to resolve conflicts based on the latest updated time.

However, in case of row deletion, the delete operation always takes priority. Example:

  • On the publisher a row is deleted at 10:00 hrs.
  • On the subscriber the same row gets updated at 11:00 hrs.
  • My synchronisation cycle started at 11:30 hrs.

The default behaviour here was to delete the row. However, we wanted the row to be updated at the publisher from subscriber data, as per the last modified time. How to achieve that result in such scenarios?

  • so, you want the row "undeleted" on the publisher? – Max Vernon Aug 24 '16 at 15:14
  • yes @MaxVernon , for the above scenario .In general what i was trying to achieve here is whatever happens later gets the preference – arpith03 Aug 25 '16 at 12:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.