After you have set up the sites on an intranet and assigned a master
site to the intranet, you can share _All tables.
For more information, see
Setting Up a Master Site and Shared Tables.
- Log in to the master site.
- On the
Intranet Shared Tables form, select this site's
intranet. If a master site has been declared for that intranet, the system
displays the master site name and a list of the _all tables that can be
shared.(Not every _all table is listed; some are not available for sharing.)
If no master site has been declared for that intranet, the rest of
the form is blank and you cannot continue.
- For tables that you want to be shared between all sites on the
intranet, select
Shared.
Another way to choose the shared tables is to select the
replication categories that you want to share. When you select a
Replication Category
from the list and click
Select by Category, the
system marks _all tables in that category as
Shared.
- When you have selected all the tables you want to share, select
.
- Click
Process to copy
information from the tables at the other sites to the master site's table,
delete the table from the other sites (creating views into the master site
tables instead), and regenerate the replication triggers for the other sites.
(When a site is in the same application database as the master site, the actual
table is not dropped, because the master site table and the sharing site table
are the same table.)
If you have selected several tables and have many sites on this
intranet, processing may take a while. The
Processing Step area
shows the system's progress.
Caution: During processing, the selected tables are
removed from all sites on the intranet except the master site. Unsharing
(rebuilding the tables at the using sites) is time-consuming - so be very sure
that you have everything set the way you want it before you click the
Process button.
- During processing, the system validates link setup between the
master site and the using sites of an intranet. If it finds a problem, an error
message displays and nothing is processed; fix the link and then click
Process again.
The
Processed field
indicates which tables have been processed. If shared, the tables are now
resident only in the master site's database. After a row on the form is marked
as
Processed, subsequent
"Process" runs will not reprocess that row.
After all the tables and sites are processed, the replication
triggers are regenerated at the master site.
Note: If one of the shared _all tables at the master site has a schema
change, you must update the views into the _all table at the user sites on the
intranet. To do this, in the master site's
Replication Management form, click
Regenerate Views to Master
Site.