Friday, March 23, 2012

replication question

can replication between sql server 2005 standard edition and express editionSQL Server 2005 Express can only act as the subscriber in a replication
process.
ML
http://milambda.blogspot.com/|||I think it's also the case that it can only subscribe to an sql 2005
publisher, is this right?|||Although this is not quite obvious from the following article, I think SQL
Server 2005 Express can act as a subscriber in a SQL 2000 replication (where
either the Publisher or the Distributer are SQL Sever 2000).
http://msdn2.microsoft.com/en-us/library/ms143699(SQL.90).aspx
I'm not certain.
ML
http://milambda.blogspot.com/|||aahh - I see it depends on the type of replication.
transactional it's fine:
"A read-only Subscriber to a transactional publication can be any
version within two versions of the Publisher version. For example: a
SQL Server version 7.0 Publisher running can have SQL Server 2005
Subscribers; and a SQL Server 2005 Publisher can have SQL Server
version 7.0 Subscribers."
but merge it isn't
"A Subscriber to a merge publication can be any version less than or
equal to the Publisher version."
thanks for the link

No comments:

Post a Comment