Merge Replication between MSDE2000 and SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rodhajj - 16 Feb 2007 09:07 GMT

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,

Signature

Rodney El Hajj
Systems Engineer

Lebanese Canadian Bank

Reply to this Message

Paul Ibison - 16 Feb 2007 09:23 GMT

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

Reply to this Message

rodhajj - 16 Feb 2007 09:56 GMT

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,

Signature

> 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

Reply to this Message

Paul Ibison - 16 Feb 2007 12:17 GMT

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

Reply to this Message

rodhajj - 27 Feb 2007 14:18 GMT

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.

> 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

Reply to this Message