Sharing _all tables

After you have set up the sites on an intranet and assigned a master site to the intranet, you can share _all tables.

Note: If all the sites are in one database, there is no need to share _all tables, or share user tables. It is already effectively being done.

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.)

Note: In any environment where all sites are in the same database, this form is not available. _all table sharing is not needed in this case.

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 Actions > Save.
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.