Now that we have created our first publication, you are ready for the other half. In this section we will cover how to tell SQL Server where to send all of that information we want to replicate. As has been noted earlier, SQL Server can replicate to SQL Server 6.5, 7.0, and any ODBC datasource that meets certain requirements. In this example, we will replicate the pubs database to the pubs_repl database on the same server in order to keep things simple at this level. Replicating to a database on the same server is the same as replicating to another server except we won’t be transmitting across a network.

If you haven’t already, bring up the Create and Manage Publications dialog box by selecting Tools | Replication | Create and Manage Publications. You should see the pubs publication that was created previously. Highlight the pubs publication and select the Push New Subscription do display Figure 14-34.

Creae a new push subscription wizard.

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