Subscriber Types
Applies to: SQL Server Azure SQL Database
Merge replication allows you to specify the types of Subscribers that a publication must support. Selecting Subscriber types sets the publication compatibility level, which determines which features can be used by a publication.
After a publication snapshot is created, the publication compatibility level can be increased (made more restrictive) on the General page of the Publication Properties dialog box; the compatibility level cannot be decreased.
Note
Azure SQL Managed Instance can be a publisher, distributor, and subscriber for snapshot and transactional replication. Databases in Azure SQL Database can only be push subscribers for snapshot and transactional replication. For more information, see Transactional replication with Azure SQL Database and Azure SQL Managed Instance.
Options
Select each Subscriber type that this publication must support.
SQL Server
The publication can use all features.
SQL Server Compact
The publication requires snapshot files to be in character format (this is handled automatically by the Snapshot Agent). SQL Server Compact also has a number of restrictions not related to compatibility level.
If this option is selected, the Web synchronization option is enabled for the publication. For more information about Web synchronization, see Web Synchronization for Merge Replication.
See Also
Publish Data and Database Objects
Create a Publication
View and Modify Distributor and Publisher Properties
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for