|
|
|
|
|
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 For our example, we will not replicate stored procedures and will select all of the tables to replicate. After selecting the Publish All button you will see Figure 14-25.
Selecting all tables to be published You will notice that entires have been added to the grid. Each table that is able to be published now has an entry for the article name. You will also see an ellipsis button after each article. This button will allow you to change the article name. It also provides access to advanced characteristics about the article. Selecting the ellipsis button for the authors table will display the general tab as shown in Figure 14-26.
General article properties This tab allows you to change the name of the article and the description. It displays the source table name and the table owner. The last two text boxes allow you to customize where the data will be replicated to. By default, SQL Server will replicate data to a table of the same name. It is not a requirement. The destination table can have any name as long as the structure of the table matches the structure of the article being published.
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.
