Publication Types for Transactional Replication

 

Applies To: SQL Server 2016

Transactional replication offers three publication types:

Publication TypeDescription
Standard transactional publicationAppropriate 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 topologyThe 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.

Transactional Replication

Community Additions

ADD
Show: