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 ...
