SQL Server – Merge Replication Subscription for Compact Edition

replicationsql serversql-server-compact

While creating a publication I saw this

enter image description here

Does this mean the subscribers can't be other editions of SQL Server but Compact?
Do other editions need to use Peer-to-Peer replication instead?

Thanks

Best Answer

This only means that if you are using SQL Server Compact edition, that this edition can only be a subscriber, not a publisher.

Here is more information on setting up merge replication between Microsoft SQL Server and SQL Server Compact 3.5.

Here is an example of a different subscriber than SQL Server Compact edition, a blogpost which sets up a Merge replication using SQL Server 2012 as the publisher and SQL Server 2008 R2 as the subscriber:

Merge Replication Step By Step

Related Question