Merge Replication between MSDE2000 and SQL 2005

Hi, I want to ask about SQL Merge replication between 40 MSDE2000 as
Publishers and SQL 2005 as Subscriber.
I received an error message while configuring the replication saying "For
Merge publications, The version of the subscriber must not exceed the version
of the publisher"
Is there a way to do the configuration without upgrading the MSDE2000 to
MSDE Express or downgrading from SQL 2005 to SQL 2000?
Thanks in advance,
Rodney El Hajj
Systems Engineer
Lebanese Canadian Bank
Using your current hardware, you could possibly change the topology to have
the SQL 2005 machine as the publisher and the MSDE boxes as subscribers.
Sometimes, when the data is partitioned, there is little distinction between
publisher and subscriber in merge replication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Tx for your quick answer, but I need one way replication, from remote sites
to Head Office. At the end of day, I need to merge data from all sites in one
database.
We used to have an SQL 2000 Server at the Head Office and MSDE 2000 on all
sites, the merge replication was working without problems. Then, we moved to
another hardware and installed SQL 2005 instead of 2000, since then we are
facing problems with the replication configuration.
BR,
"Paul Ibison" wrote:

> Using your current hardware, you could possibly change the topology to have
> the SQL 2005 machine as the publisher and the MSDE boxes as subscribers.
> Sometimes, when the data is partitioned, there is little distinction between
> publisher and subscriber in merge replication.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>
|||One-way replication presumably means that you want the data to flow in one
direction but this can be achieved from subscriber to publisher as well as
the other way around. The central publisher can
be a central repository of the data, as unintuitive as this sounds
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Hi Again,
I tried to do the replication from subscriber to publisher (The Publisher is
centralized) but didn't succeed.
Can you provide me with a step by step merge replication procedure. Maybe
I'm missing some settings.
Thanks in advance.
"Paul Ibison" wrote:

> One-way replication presumably means that you want the data to flow in one
> direction but this can be achieved from subscriber to publisher as well as
> the other way around. The central publisher can
> be a central repository of the data, as unintuitive as this sounds
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>
>