Sunday, February 19, 2012

can a Subscriber be a Publisher?

sql2k sp3a
The configuration is currently.
Box1-- Publisher/ Distributor.
Several Subscribers all with Pull Subscriptions.
One of these Pull Subscriptions that my boss wants me to start Replicating
from. Can this type of deal cause problems?
TIA, ChrisR
Have a look at "republisher replication model" in SQL Server books online
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"ChrisR" <noemail@.bla.com> wrote in message
news:eDAEYipSFHA.3332@.TK2MSFTNGP15.phx.gbl...
> sql2k sp3a
> The configuration is currently.
> Box1-- Publisher/ Distributor.
> Several Subscribers all with Pull Subscriptions.
>
> One of these Pull Subscriptions that my boss wants me to start Replicating
> from. Can this type of deal cause problems?
> TIA, ChrisR
>
|||Makes sense. But what will happen if I sp_replAddColumn on the Publisher. I
know that column will make it on the RePublisher, but will it arrive on the
RePublisher's Subscribers?
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OJI0ZiqSFHA.616@.TK2MSFTNGP12.phx.gbl...
> Have a look at "republisher replication model" in SQL Server books online
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eDAEYipSFHA.3332@.TK2MSFTNGP15.phx.gbl...
>
|||No idea...I'd have to test it against Pubs, Pubs1 and Pubs2 on my box (or
you can test it on yours...)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"ChrisR" <noemail@.bla.com> wrote in message
news:uu7xAwqSFHA.2648@.TK2MSFTNGP10.phx.gbl...
> Makes sense. But what will happen if I sp_replAddColumn on the Publisher.
> I know that column will make it on the RePublisher, but will it arrive on
> the RePublisher's Subscribers?
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OJI0ZiqSFHA.616@.TK2MSFTNGP12.phx.gbl...
>

No comments:

Post a Comment