question

vivekchandra09 avatar image
vivekchandra09 asked

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?
replicationsql-server-2008-r2-expresssql-server-2008-r2-standardsql server 2008 r
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sjimmo avatar image
sjimmo answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.