Monday, March 12, 2012

Merge Replication Issue

Hi,
My Merge replication setup for a particular table has 1 subscriber and
muliple publishers. Each publisher will push the subscription to the
subscriber.
However, I am encountering some issues with this setup.
Findings:
Any record inserted/deleted/updated in either Publisher 1 or Publisher 2
will be reflected in Subscriber.
Any record inserted/deleted/updated in Subscriber will be reflected in
Publisher 1 and Publisher 2.
Issue:
Any record replicated in Subscriber from one publisher is NOT reflected in
the other publisher (e.g. Insert new record in Publisher 1, inserted record
gets replicated in Subscriber but does not insert this new record in
Publisher 2, vice versa)
I will like to find out if there is any setting or consideration that I need
to make with regards to my merge replication setup, in order to allow changes
made in any of the publisher to be replicated in the subscriber and then
reflected in other publishers.
Will definitely appreciate any of your inputs and advice.
Thanks In Advanace,
Roy Tan
Had made changes to my configuration. I have a single publisher and multiple
subscribers and everything seems to work fine. I am just wondering when do we
actually apply a "single subscriber and multiple publisher" scenario.
"Roy Tan" wrote:

> Hi,
> My Merge replication setup for a particular table has 1 subscriber and
> muliple publishers. Each publisher will push the subscription to the
> subscriber.
> However, I am encountering some issues with this setup.
> Findings:
> Any record inserted/deleted/updated in either Publisher 1 or Publisher 2
> will be reflected in Subscriber.
> Any record inserted/deleted/updated in Subscriber will be reflected in
> Publisher 1 and Publisher 2.
> Issue:
> Any record replicated in Subscriber from one publisher is NOT reflected in
> the other publisher (e.g. Insert new record in Publisher 1, inserted record
> gets replicated in Subscriber but does not insert this new record in
> Publisher 2, vice versa)
> I will like to find out if there is any setting or consideration that I need
> to make with regards to my merge replication setup, in order to allow changes
> made in any of the publisher to be replicated in the subscriber and then
> reflected in other publishers.
> Will definitely appreciate any of your inputs and advice.
> --
> Thanks In Advanace,
> Roy Tan

No comments:

Post a Comment