Wednesday, March 21, 2012

Merge replication publisher subscriber

Hello
I have Publisher and 200 subscribers
I need to unload Publisher having added N intermediate Publishers
on 50 subscribers to everyone
And each intermediate publisher stores data only for it's owns
subscribers.
Is this possible?
Do I need for subscription that are created to be with ' global '
sync_typ?
Is there a particular order in witch a publications and a subscription
are created?
Thanks for your helps
ps : sql2000 SP4,8.00.2187Yes this is called republishing and it is recommended when you have large
numbers of merge subscribers. It does require the global priority between
the republishers. You create the main publisher first and then the
downstream ones.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"maroucia" <maroucia@.yahoo.com> wrote in message
news:1161252010.072061.165570@.b28g2000cwb.googlegroups.com...
> Hello
> I have Publisher and 200 subscribers
> I need to unload Publisher having added N intermediate Publishers
> on 50 subscribers to everyone
> And each intermediate publisher stores data only for it's owns
> subscribers.
> Is this possible?
> Do I need for subscription that are created to be with ' global '
> sync_typ?
> Is there a particular order in witch a publications and a subscription
> are created?
> Thanks for your helps
> ps : sql2000 SP4,8.00.2187
>|||http://www.replicationanswers.com/Republishing2005.asp

No comments:

Post a Comment