Post reply

How to setting interprovince Merge Replication ?

  • August 8, 2005 at 4:55 am

    #165551

    (Please, see http://vcraft.com.vn/mergerepl.JPG for detail)

    I have 3 servers: ServerA, ServerB, SeverC. Now, I need to deploy these servers in a interprovince merging Replication. It means:

    ServerA is publisher of ServerB (subscriber of ServerA)

    AND ServerB is publisher of ServerC (subscriber of ServerB)

    But after setting, if i change data on ServerA, it is merged on ServerB successfully but failed on ServerC. Anyone help me?

    Thank you very much,

  • August 9, 2005 at 10:15 am

    #580800

    You can run:

    sp_mergedummyupdate 'tablename', rowguid

    on the second server to get it to create metadata to replicate to the third server.  This isn't a long term solution though.  It sounds like the data is not being propogated because the replication triggers are not firing on the second server.  I'm not sure how to configure it to work right, but there must be a resource out there somewhere.

     

    Dylan Peters
    SQL Server DBA

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

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