Thanks Paul,
Can we set Site 1 and site 2 as the publishers and site 3
as the subscribers? Those sites already exist and I
cannot make any (big) changes there.
Can we set dynamic filter if we don't have any defined
relationship? how?
How to use -HOSTNAME? since I only see bcpbatchsize,
changesperhistory....etc in merge agent profile :))
Sorry for these questions. I am newbie.
Thanks again Paul.
[quoted text, click to view] >-----Original Message-----
>Eko,
>use merge replication. Set Site 3 as the publisher,
Sites 1 and 2 as
>subscribers.
>Dynamically filter the data according to the subscriber,
using -HOSTNAME in
>the merge agent profile.
>This topology will do what you require. Please post back
if any of this is
>unclear.
>Regards,
>Paul Ibison
>
>
>
>.
you'll have to drop existing publications and subscriptions and then rebuild
them doing a no-sync.
Hostname is a parameter you can add to your merge agent just like the
bcpbatchsize parameters
[quoted text, click to view] "Eko" <anonymous@discussions.microsoft.com> wrote in message
news:199b901c41c91$642860e0$a101280a@phx.gbl...
> Thanks Paul,
>
> Can we set Site 1 and site 2 as the publishers and site 3
> as the subscribers? Those sites already exist and I
> cannot make any (big) changes there.
> Can we set dynamic filter if we don't have any defined
> relationship? how?
> How to use -HOSTNAME? since I only see bcpbatchsize,
> changesperhistory....etc in merge agent profile :))
>
> Sorry for these questions. I am newbie.
>
> Thanks again Paul.
>
>
> >-----Original Message-----
> >Eko,
> >use merge replication. Set Site 3 as the publisher,
> Sites 1 and 2 as
> >subscribers.
> >Dynamically filter the data according to the subscriber,
> using -HOSTNAME in
> >the merge agent profile.
> >This topology will do what you require. Please post back
> if any of this is
> >unclear.
> >Regards,
> >Paul Ibison
> >
> >
> >
> >.
> >
Eko,
use merge replication. Set Site 3 as the publisher, Sites 1 and 2 as
subscribers.
Dynamically filter the data according to the subscriber, using -HOSTNAME in
the merge agent profile.
This topology will do what you require. Please post back if any of this is
unclear.
Regards,
Paul Ibison
