Merge Replication: Inventory Conflict Resolution

• otis-224947

  SSC Rookie

  Points: 31

  More actions

  April 18, 2005 at 7:23 am

  #85534

  Hi!

  Does anybody have any ideas, solution, advise for this problem:

  Say I have an "inventory" table having "quantity" column.

  quantity's initial value is 10

  At remote site 1 (publisher), orders are made, and quantity is reduced from 10 to 7.

  At remote site 2 (subscriber), stocks arrive, and quantity is increased from 10 to 30.

  Now when data is merged, quantity would result to 7, right?

  But that would be logically wrong, quantity is supposed to be

  (10 - 3 + 20) = 27

  So, how do you handle this conflict to get the correct quantity?

  I have some experience with Sybase and you can use the following to resolve the conflict:

  CREATE TRIGGER resolve_quantity

  RESOLVE UPDATE OF quantity

  ON "DBA".inventory

  REFERENCING OLD AS old_name

  NEW AS new_name

  REMOTE AS remote_name

  FOR EACH ROW

  BEGIN

  SET new_name.quantity = new_name.quantity + old_name.quantity - remote_name.quantity

  END

  in SQL server,

  OLD would be DELETED,

  NEW would be INSERTED,

  but what about REMOTE?

  Any help would be greatly appreciated

• noeld

  SSC Guru

  Points: 96590

  More actions

  April 18, 2005 at 8:35 am

  #553195

  You can wrap that logic in a custom resolver! use an stored procedure ans mark the article resolver to use that sp.

  For more info look in BOL at

  Custom Stored Procedure Conflict Resolver

   

  hth

  
  * Noel

• David Haas

  SSC Enthusiast

  Points: 135

  More actions

  March 7, 2006 at 9:54 am

  #625238

  I was wondering if you came up with a solution to this.

• Geoffrey Sy

  Newbie

  Points: 1

  More actions

  September 27, 2006 at 1:07 am

  #662642

  Hi, I have the same problem as yours.  If you have the solution, please PM me.  Thanks