Selecting the database to publish information to

You must have a database set up on the subscriber to accept data from the publication. By default, this database is named the same as the one that is being published. We are going to change this to point to the pubs_repl database by selecting the Browse Databases button as shown in Figure 14-37.

Selecting a subscription database

I’ve already created the pubs_repl database. You’ll notice that you have the ability to create a new database. Selecting this button will simply launch the Create Database dialog as discussed in Chapter 5. Select the pubs_repl database or create it if it does not exist and click the OK button.

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