SQL Server Express Edition 2008 R2
Can SQL Server Express Edition be used in replication?
Let’s suppose a typical replication case. Publisher, Distributor and Subscriber are the main elements as shown below.
• SQL Server Express Edition can act a subscriber to a replication process, means that it can receive data in replication.
• SQL Server Express Edition can’t act a publisher/Distributor to a replication process, means that it can’t deliver data in replication.
• So a non Express Edition of SQL Server should be used to act as publisher and in such case Express Edition SQL Server can get data as subscriber.