Setting Up All Sites on the Intranet

These steps assume that you have already used the Service Management Configuration Wizard during database server installation to link your multi-site databases.

In the Intranets form, specify all intranets to be used in this multi-site system. If you will be sharing _all tables, define an intranet that will include all the sites that share tables. This cannot be an "External" intranet. All the sites on this intranet must use the same version of Service Management.

Do not define the master site yet, that will be done later.
In each site and entity, use the Sites/Entities form to specify information about this site/entity and the other entities and sites that it relates to. Each site/entity has a record in this form.
- On the System Info tab, specify information about the site. Make sure the Intranet Name, Database Name, and Time Zone are set correctly for each of the sites and entities listed on this form.
- A list of linked sites displays automatically in the Live Linked Sites tab. The local site record shows links used in transactional replication between the currently selected site database and other site/entity databases. In the local site's record, specify any additional links between this site/entity and other site/entity databases that will perform transactional replication with this database. (On site records other than the local site, the Live Linked Sites tab should show only links to the local site.)
- Perform this step at the master site only: On the Link Info tab, add links to each of the other sites on the master site's intranet. For other site records in the master site's intranet, add only a link to the master site. (Sites on other intranets do not require Live Link information with the master site.)
Use the Replication Categories form to specify tables, stored procedures, and XML documents that should be replicated and to group them into categories. The installation process creates some categories. Do not delete these standard categories. These categories have been created and tested to ensure that they handle the standard system processes. They should meet most of your needs without requiring any changes.
On the Replication Rules form, set up transactional rules for the Site Admin replication category between this site and all the other sites in the intranet, including the site that will be the master site. (Site Admin data includes tables such as site, intranet, and intranet_shared_table.)

You may also want to write other rules to replicate certain categories between certain sites. Even if a category contains _all tables that you are sharing, you probably want to write a replication rule for the category. (Any shared _all tables will not be replicated in this case.) Categories may contain additional base tables or stored procedures that are needed to perform certain functions. The rules you need should be determined in the multi-site planning phase.
On the Replication Management form, click Regenerate Replication Triggers. This ensures that site and intranet data is replicated to all the linked sites.