|
|
|
|
|
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 When you click the Finish button, a lot of things will happen on your system. The services will be started if they already aren’t. A subscription will be created. The distribution agent will perform the syncronization. Once complete you will see a confirmation as shown in Figure 14-42.
Successfully creating a subscription. Clicking the close button will take you back to the Create and Manage Publication dialog. We are done with this dialog for the moment, so close it. Congratulations! You have just created your first subscription and now data will begin flowing from the pubs database to the pubs_repl database. To verify this simply issue an insert, update, or delete on any of the tables in the publication. Then take a look at the corresponding table in the pubs_repl database. You should see the transaction you just performed reflected.
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 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
