Publication Type

Publication Type


Applies To: SQL Server 2016

Replication provides the following types of publications:

  • Snapshot publication

  • Transactional publication

  • Merge publication

Which type or types of replication you choose for your application depends on the physical replication environment, the type and quantity of data to be replicated, and whether or not data is updated at the Subscriber. The physical environment includes the number and location of computers involved in replication, and whether these computers are clients (workstations, laptops, or handheld devices) or servers. For more information, see Types of Replication.

Publication type
Select the appropriate replication type for this publication.

Publish Data and Database Objects
Create a Publication

Community Additions

© 2016 Microsoft