configure the Merging Changes option and check the user and permission of Merge agent

• sach.chopade15

  Newbie

  Points: 3

  More actions

  January 21, 2011 at 10:31 pm

  #233851

  Hello,

  I need your urgent help.

  I have configured the "Merge Replication" in SQL Server 2008 and SQL server Compact 3.5 and the synchronization process is running excellent.

  But in synchronization i want to handle delete condition. Condition 1:- when i delete the records from Sql server compact (mobile database) after synchronization the records deleted from mobile database SHOULD NOT BE deleted from server database .

  Condition 2:- But if i delete the records from server database, after synchronization the records deleted from server database MUST ALSO BE deleted from Mobile Database.

  I tried my making delete_tracking false for replication but by this only my first condition is satisfied.

  sp_changemergearticle

  @publication = 'MobilePublication',

  @article = 'AttachmentTable',

  @property ='delete_tracking',

  @value = 'false'

  I found on MSDN that both the condition can be satisfied by configuring the merge option change

  http://msdn.microsoft.com/en-us/library/ms173005.aspx

  I am still not able to find Merge Agent and on which identity does it runs?

  from two weeks i am struggling to find the solution.

  Please help!!

  Thanks in advance.

  SachinC

• happycat59

  One Orange Chip

  Points: 29451

  More actions

  January 23, 2011 at 8:22 pm

  #1277029

  I don't know whether you will be able to do this with configuration alone.

  You could do something like

  - add a "available for mobile device" flag

  - on the server, use a "delete"

  - when the mobile device deletes, this becomes an update set "available for mobile device" flag = False

  - probablu similar on the server

  - add a filter to the publication so that only rows that are available for mobile devices are published.