Replication of Replications

Is it possible to have a pull subscription and then have a pull
subscription of that subscription? We want to have a server wich
replicates to 2 or more laptops wich will be replicated out to 3 or
more ppc all running sever - msde - sqlce?
Not as such, but it is possible to republish:
A publishes to B
B publishes to C
etc
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||with merge, this is doable. With Transactional replication you will have to
select the option to include DRI on your table articles so the primary keys
will be in place on your subscriber tables. Otherwise you won't have PK's on
B, to replicate to C.
"Shane Lim" <gslim@.blizzardice.com> wrote in message
news:i0alv0l0c35ppj2goua1k4uvdlpngi3fo0@.4ax.com...
> Is it possible to have a pull subscription and then have a pull
> subscription of that subscription? We want to have a server wich
> replicates to 2 or more laptops wich will be replicated out to 3 or
> more ppc all running sever - msde - sqlce?
|||Hilary's answer is more accurate - using alternative synchronization
partners is a possibility in merge replication as well as republishing.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Alright I setup all of my databases as publications and I can create a
pull from the master to the second slave. Everything looks good
except my articles are not visible. When I try to add them I get an
error saying that I cannot create duplicate tablenames. When I try to
create a pull to the second database the error I get states that it
cannot get a mergearticle list. Any ideas?
On Sat, 29 Jan 2005 11:25:37 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>with merge, this is doable. With Transactional replication you will have to
>select the option to include DRI on your table articles so the primary keys
>will be in place on your subscriber tables. Otherwise you won't have PK's on
>B, to replicate to C.
>
>"Shane Lim" <gslim@.blizzardice.com> wrote in message
>news:i0alv0l0c35ppj2goua1k4uvdlpngi3fo0@.4ax.com.. .
>