Hi, how can be implemented republisher replication model?
When I first configure and create a publication "P1", and then create pull
subscripton on "RP1 = Publishing subscriber" everything is ok. But whenever I
try to create a new Publication on RP1 I get an error message which says that
before creating publication the subscription shoulfd be dropped, then create
pub and at last create pull subscription again. Unfortunetly this approach
does not work.
Vice versa when I first create publication P1, then another publication RP1
for the subscriber and finally create a pull subscription on RP1 having P1 as
Publisher, EM says that again first drop publication and then create pull
subscription...
So, how can I implement republisher replication model?
The answer is :
In order to use this topology the publishing subscriber must be a global
subscriber for publisher P1.
"Erkan Aygun" wrote:
> Hi, how can be implemented republisher replication model?
> When I first configure and create a publication "P1", and then create pull
> subscripton on "RP1 = Publishing subscriber" everything is ok. But whenever I
> try to create a new Publication on RP1 I get an error message which says that
> before creating publication the subscription shoulfd be dropped, then create
> pub and at last create pull subscription again. Unfortunetly this approach
> does not work.
> Vice versa when I first create publication P1, then another publication RP1
> for the subscriber and finally create a pull subscription on RP1 having P1 as
> Publisher, EM says that again first drop publication and then create pull
> subscription...
> So, how can I implement republisher replication model?
Showing posts with label republisher. Show all posts
Showing posts with label republisher. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
Republisher (publishing subscriber) merge replication
Hi,
I am trying to have a republisher run with Merge replication, but am getting error messages anytime I try to publish to the third tier.
Any suggestions on where I can find more info?
Thanks
Wil
I ran into touble once trying that until I set the subscriber type
(sp_AddMergeSubscription) to Global. You might want to check your setting.
Paul
"Wil" <wil@.canoemail.com> wrote in message
news:258CA56C-2CE7-4531-8998-704C698E6DA3@.microsoft.com...
> Hi,
> I am trying to have a republisher run with Merge replication, but am
getting error messages anytime I try to publish to the third tier.
> Any suggestions on where I can find more info?
> Thanks
> Wil
|||what is your error message?
"Wil" <wil@.canoemail.com> wrote in message
news:258CA56C-2CE7-4531-8998-704C698E6DA3@.microsoft.com...
> Hi,
> I am trying to have a republisher run with Merge replication, but am
getting error messages anytime I try to publish to the third tier.
> Any suggestions on where I can find more info?
> Thanks
> Wil
I am trying to have a republisher run with Merge replication, but am getting error messages anytime I try to publish to the third tier.
Any suggestions on where I can find more info?
Thanks
Wil
I ran into touble once trying that until I set the subscriber type
(sp_AddMergeSubscription) to Global. You might want to check your setting.
Paul
"Wil" <wil@.canoemail.com> wrote in message
news:258CA56C-2CE7-4531-8998-704C698E6DA3@.microsoft.com...
> Hi,
> I am trying to have a republisher run with Merge replication, but am
getting error messages anytime I try to publish to the third tier.
> Any suggestions on where I can find more info?
> Thanks
> Wil
|||what is your error message?
"Wil" <wil@.canoemail.com> wrote in message
news:258CA56C-2CE7-4531-8998-704C698E6DA3@.microsoft.com...
> Hi,
> I am trying to have a republisher run with Merge replication, but am
getting error messages anytime I try to publish to the third tier.
> Any suggestions on where I can find more info?
> Thanks
> Wil
Labels:
database,
error,
merge,
messages,
microsoft,
mysql,
oracle,
publish,
publishing,
replication,
republisher,
run,
server,
sql,
subscriber,
third,
tier
Subscribe to:
Posts (Atom)