Creating a Publication

Publication is a unit for data replication. You can create a Publication via SSMS if you go to the replication/local Publications menu item and right-click on Local Publication. Here, you can select a New Publication item, which will start a wizard for you. This wizard will guide you through the whole publication configuration. The first choice that you have to make is what sort of replication publication you want to create:

  • Snapshot
  • Transactional
  • Peer-to-peer
  • Merge

Let's read a little about each type of replication:

  • Snapshot publication will create a snapshot of your data, which will be periodically transferred ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.