Groups | Blog | Home
all groups > sql server replication > september 2006 >

sql server replication : Merge Replication


Karthik Vatsan
9/27/2006 6:13:38 PM
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

Hilary Cotter
9/27/2006 10:26:47 PM
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.

--
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



[quoted text, click to view]

Karthik Vatsan
9/28/2006 6:23:27 PM
Thanks Hilary..Even if i move the distributor to SQL Server 2005, it still
gives me the same message..

Karthik
[quoted text, click to view]

Karthik Vatsan
9/29/2006 4:46:55 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button