March 14, 2006 at 10:47 am
We are trying to setup Merge replication on a table that contains inventory data. I was wondering if anyone had any experience with this if they could share how they set up their conflict resolotion for this.
From what I can tell when the tables are synched with each other and there is a conflict you only know what each servers current data is for that record. For instance
Server A and Server B start with 100.
Server A has 2 transactions that reduce the qty by 10 each time resulting in a qty of 80.
Server B has 3 transactions that reduce the qty by 5, 10, and 20 resulting in a qty of 65.
How is this conflict resolved when this occurs. From what I have read we can retrieve the current publisher data and the current subscriber data but not the individual transactions. The resulting qty should be 45 since once server reduced it by 20 and the other by 35. But during the resolutution we only see the qty of 80 from server A and qty of 65 from server B.
Any help is appreciated.
Thanks,
March 14, 2006 at 10:58 am
Forgot to mention that we are creating the Custom Conflict resolver through stored procedures.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply