SQL 2000 -> SQL 2005 Merge Replication compatible?

Hot Topic

Database 'msdb' cannot be opened
Can I use ALTER LOGIN in a stored procedure???
Building a Flat File Connector Programmatically
About alias of data field
Restoring to a network paths?
cannot install integration services
Location of default instance SQL server 2005 files
Using Notification Services for Field Service
Top 5 with Union.
Best way to handle License issues

SQL Server

is it possible to have variant condition clause in procedure?
Properties affected by Expressions
Transaction replication: Distribution agent owner
How to load data into a table using a synonym?
32-bit UDA fails on 64-bit with large dataset (worked before)
The Poor VB6 guy - database help
can you build a report model on an Access MDB?
Cannot connect to SQL Server 2005 April CTP from remote computer
Attribute Relationships in Project Real
Custom ControlFlow

SQL 2000 -> SQL 2005 Merge Replication compatible?

Hi everyone,

I'm currently trying to setup a SQL 2k (SP3, build 922) merge replication publisher and a push subscription to a SQL 2005 (RTM release, no hotfixes) subscriber. The distribution database resides on a separate SQL 2k server (SP3, build 1007). I get the error below leading me to believe merge replication is not compatible between versions.

Replication-agentclassname: agent Agent_Name failed. Procedure or function sp_MSupdatesysmergearticles has too many arguments specified..

I say this b/c I've tried SQL 2005 32-bit and x64 subscribers and both give the same error. Anyone have any ideas if this is by design or just a bug that will be fixed later Thanks.

LSC

Answer this question

SQL 2000 -> SQL 2005 Merge Replication compatible?

gengisangelo
A SQL 2005 subscriber (with exception to SQL 2005 mobile) cannot subscribe to a SQL 2000 publication.

For more information, see Books Online topic "Using Multiple Versions of SQL Server in a Replication Topology".
SQL 2000 -> SQL 2005 Merge Replication compatible?

Answer this question