Now that replication services have been enabled, we are ready to start creating publications and articles. Select Tools | Replication | Create and Manage Publications as shown in Figure 14-18.

Creating a publication

This will start the Create and Manage Publications dialog box as shown in Figure 14-19.

Creating a new publication.

You’ll notice that there are only two database displayed in the dialog box: Northwind and pubs. You might be wondering why the pubs_repl database does not show up? The pubs_repl database does not show up because this was created to act as the subscriber and does not contain any user tables. The dialog box will only display those databases that contain at least one user table. You can verify this for yourself by creating a ew database and adding a table. For this chapter, we will be replicating the pubs database to the pubs_repl database.

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