|
|
|
|
|
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 This is the first place where you will determine the replication topology that is being configured. You have the option to setup a local or a remote distribution database. If you select a local distributor, a distribution database will be created for you during the setup process. If a remote distributor is selected, replication services must already be installed on the server. For this chapter, we will configure a local distribution database since we will be replicating between two databases on the same server.Clicking the Next button will take you to Figure 14-13.
Distributor and publisher configuration At this point, we will select the default options. The option to customize will enable additional options in the wizard. You can change the name or location of the distribution database at this point. After passing through the distribution database configuration, you can enable publishing on multiple servers. Clicking next allows the enabling of one or more databases for either transactional or merge replication or both. One or more subscribers can be enabled for the publications. After that, the wizard will perform the same options as in the default configuration. Many of the options that are possible from the custom configuration will be configured later in this chapter.
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.
