Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it possible for a Sql Server 2008 R2 Express instance to subscribe to a publication on Sql Server 2005? This is for Merge Replication.

Update:

Please note the Publisher is Sql 2005 and the Subscriber is Sql 2008

Answer:

Looks like answer is No, according to this paragraph:

"For merge replication, a Subscriber to a merge publication can be any version no later than the Publisher version. For more information about compatibility for earlier versions, see "Compatibility Level for Merge Publications" later in this topic."

share|improve this question

2 Answers 2

up vote 3 down vote accepted

Express editions can only act as a subscriber in a replication topology. Your scenario should be possible, with a SQL 2005 publisher and a SQL 2008 subscriber, see Using Multiple Versions of SQL Server in a Replication Topology, as long as the SQL 2005 is at least at SP2:

SQL Server 2000 and SQL Server 2005 can both participate in replication topologies with SQL Server 2008... For SQL Server 2005 the minimum version is Service Pack 2 (SP2).

share|improve this answer
    
Interesting, the article mentions "For merge replication, a Subscriber to a merge publication can be any version no later than the Publisher version. For more information about compatibility for earlier versions, see "Compatibility Level for Merge Publications" later in this topic." So it seems the answer is No? –  B Z Sep 29 '10 at 17:00
    
You're right. Thing is I always used Transactional and I wasn't aware of the Merge restriction. –  Remus Rusanu Sep 29 '10 at 17:36

Yes its possible for both Merge and Transactional Replication. Its all here in the feature comparison table under Integration and Interoperability

share|improve this answer
    
Hello - Did you notice the versions are different for the Publisher (Sql 2005) and the Subscriber (Sql 2008)? That is the part I haven't found info about. –  B Z Sep 29 '10 at 16:31
    
Sorry, I havent noticed that. check this out about Using Multiple Versions of SQL Server in a Replication Topology msdn.microsoft.com/en-us/library/ms143241.aspx –  DaniSQL Sep 29 '10 at 16:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.