-
SMO RMO SQL2008 Express
SQL2008 Express has restricted replication capabilities.
Is it possible to be built replication system for express servers based on - Replication Management Objects (RMO) and SQL Server Management Objects (SMO) ... ???
Or ... what are the restrictions ? Are there some build restrictions inside the express database against SMO and RMO ?
-
Express can only be subscriber.
-
Feature comparison of different editions of SQL Server 2008:
http://www.microsoft.com/sqlserver/2...s-compare.aspx
Basically if you are deploying a replication publication into production, it needs to come from a standard or enterprise edition. Everything else is a subscriber like rmiao mentioned.