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."
Best Answer
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: