Replication between SQL Server 2008 R 2 Sp 3 database and SQL Server 2008 R2 Express edition with advanced feature
Can Replication between SQL Server 2008 R 2 SP 3 standard database and SQL Server 2008 R2 Express edition with advanced feature happen? The SQL Server R2 express with advanced feature is on a different server.,feature possible? The express edition is on a different database server?
The Express box must be the subscriber to the Standard box. It cannot serve as a publisher nor a distributor. I believe that it also must be a push subscription. This is because the SQL Agent does not exist, which would be required for a pull subscription.