none
2 Way replication issue faced of records skipping/not replicating. RRS feed

  • Question

  • We have a replication setup wherein data entry is done at head office and also at multiple branch locations; data replicates from h.o. to multiple branch locations; also data entry done at branch locations gets replicated back at h.o. location and from h.o. replicates to all branches so that each branch can see other branch data as well as h.o. data.

    Many times issue faced is that a) even though; the replication monitor does not show any issue; but few records are skipped while replicating from say branch A location to h.o.

    b) at other times issue faced is that even though data from say branch A comes to h.o.; it does not replicate to branch B.

    Thanks in advance.
    Monday, April 27, 2020 5:45 AM

All replies

  • Hi mi_dinesh10,

    What replication type do you use? 

    For your situation, suggest you use Merge Replication. And after you have change the data, try to do as next and test whether there is also the issue:

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, April 28, 2020 3:01 AM