Merge Replication between Sql 200 and SqlExpress 2005 -- sql server replication

sushil prasad
10/25/2006 4:30:42 PM

I setup a merger replication publisher/distributor on the sql server 2000.
The users with pc have sql express 2005 loaded. When i set the subscriber
through the wizard on the sql express i get the following error:

Error:
For merge publications, the version of the subscriber must not exceed the
version of the publisher.

My question is, is it possible to have SqlExpress 2005 to subscribe to sql
2000 published replication?.

Also i need help as how setup a FTP pull of data fro merge replication?

Hilary Cotter
10/25/2006 11:11:49 PM

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

a Subscriber to a merge publication can be any version no later than the
Publisher version

So you need to upgrade your publisher.

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

sql server replication : Merge Replication between Sql 200 and SqlExpress 2005