Publication Types for Transactional Replication
Applies To: SQL Server 2016
Transactional replication offers three publication types:
|Standard transactional publication||Appropriate for topologies in which all data at the Subscriber is read-only (transactional replication does not enforce this at the Subscriber).|
Standard transactional publications are created by default when using Transact-SQL or Replication Management Objects (RMO). When using the New Publication Wizard, they are created by selecting Transactional publication on the Publication Type page.
For more information about creating publications, see Publish Data and Database Objects.
|Transactional publication in a peer-to-peer topology||The characteristics of this publication type are:|
-Each location has identical data and acts as both a Publisher and Subscriber.
-The same row can be changed only at one location at a time.
-This topology is best suited for server environments requiring high availability and read scalability.
For more information, see Peer-to-Peer Transactional Replication.