The Create Publication Wizard

This wizard will walk you through the entire process of creating a publication and articles. Select the next button to display the Publication Type screen as shown in Figure 14-21.

Choosing the appropriate publication type

You have three options to choose from here. Snapshot replication will periodically refresh all of the data being replicated. This is useful for very small data sets or for systems that require the entire data set to be refreshed. Transactional replictaion is by far the most common. This type of replication sends the transactions to subscribers in near real time. This provides the highest level of consistency across the system, but does require good connectivity between the publisher and subscriber. If you are going to utilize the merge replication topology, then you must select the merge replication option. This enables a slightly different level of activity in the system and also allows the subscribers to update the publisher. This topology offers great promise for mobile users, dial up connections, and systems that do not have good connectivity. For this example, we will be using Transactional replication.

Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40