One way Pull Merge replication problem

• jjarupan

  Ten Centuries

  Points: 1247

  More actions

  January 17, 2008 at 7:55 am

  #182811

  Hi All,

  Just only 2 articles (from 12 articles) have the problem about delay update at publisher( I am not sure this is correct term)

  Reason for conflict.

  "The same column(s) of the same row was updated at both 'LocalServer' and 'CentralServer'. The resolver chose the update from 'LocalServer' as the winner."

  The column is date column that may have different for 13 days i.e for Conflict loser show ''1/3/2008" on Conflict winner show "1/16/2008", we have replication every 5 minutes.

  *** the other columns have no problem ie. Money colum(which changes everytime), why? ***

  Any guide/help will be really appreciate.

  Note: 1) We use One way merge replication instead of transaction replication due to SQL version and we can not change it for this year.

  2) I set up script to work around by run script to check the date different(on that article) between LocalServer(PullMerge) and CentralServer(Publisher) everynight and update LocalServer accordingly but this is not solve the problem at origin.