November 28, 2007 at 3:56 pm
I am looking to fill in the blanks to the table below, showing which versions of SQL server Publishers/Subscribers are compatible with each other using ActiveX controls to manage the replication.
Publisher / Subscriber | [works / no]
MSDE2000 / MSDE2000 | works
MSDE2000 / SQL2000 | ???
MSDE2000 / SQLEXPRESS 2005 | ???
MSDE2000 / SQL2005 | ???
SQL2000 / MSDE2000 | ???
SQL2000 / SQL2000 | ???
SQL2000 / SQLEXPRESS 2005 | ???
SQL2000 / SQL2005 | ???
SQL2005 / MSDE2000 | works
SQL2005 / SQL2000 | ???
SQL2005 / SQLEXPRESS 2005 | ???
SQL2005 / SQL2005 | ???
Currently, I am trying to replicate using MSDE2000 as a publisher and SQL 2005 as a subscriber, but I am getting a message stating the following: "The SQL Server version of the Publisher server needs to be upgraded to 'Microsoft SQL Server 9.0'."
Searching the net, I have been unable to find anything explicitly documenting this. Thank you,
Chris
December 3, 2007 at 11:44 am
what is the compabilitymode of the database in sql 2005?
December 3, 2007 at 11:59 am
I'm not sure. Is that a setting that I would see under Properties somewhere in SQL Server Management Studio?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply