Merge Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karthik Vatsan - 27 Sep 2006 23:13 GMT

Hi,
Is it possible to setup merge replication between SQL Server 2000
(Publisher) and SQL Server 2005 as (Subscriber) because when i try to
setup, it gives me a message that the "subscriber version cannot be higher
than the publisher version" ? If transactional replication works, why not
merge ?

Thanks,

Karthik

Reply to this Message

Hilary Cotter - 28 Sep 2006 03:26 GMT

No, consult this link for more info.

http://msdn2.microsoft.com/en-us/library/ms143241.aspx

Minimum requirements are for the distributor to be sql 2005.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
> Is it possible to setup merge replication between SQL Server 2000
[quoted text clipped - 6 lines]
>
> Karthik

Reply to this Message

Karthik Vatsan - 28 Sep 2006 23:23 GMT

Thanks Hilary..Even if i move the distributor to SQL Server 2005, it still
gives me the same message..

Karthik

> No, consult this link for more info.
>
[quoted text clipped - 12 lines]
>>
>> Karthik

Reply to this Message

Karthik Vatsan - 29 Sep 2006 21:46 GMT

Even if i move the distributor to 2005, i am still getting the same
problems..Could you please let me know whether merge replication doesnt work
with SQL Server 2000 as publisher ?

Thanks,

Karthik Vatsan.N

> Thanks Hilary..Even if i move the distributor to SQL Server 2005, it still
> gives me the same message..
[quoted text clipped - 16 lines]
>>>
>>> Karthik

Reply to this Message