Issue when edit both publisher and subscriber at same time

  • Hi

    I replicated two databases in my sql server 2000. Everything works perfectly except when i make changes to both publisher and subscriber in same time period. I set the time interval as one minute. Suppose if i edit the publisher db first and afetr this editing the subscriber db, i would expect to keep the change made to the subscriber in both dbs, because last I made changes to the subscriber. But what happening is maintaining the publisher db data in both publisher and subscriber. It will work perfectly if I edit either publisher or subscriber at a time. I expect a reply that i forgot to set any values to perform the bidirectional database replication.

    Regards

    Rajesh VR 😛

  • What kind of replication is it? Merge or updatable transactional replication?

    -Roy

  • It is merge replication

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply