Replicating base tables

Base tables can include a multi-site column that contains the site name, so that each site in the database can maintain its own records in the table.

You might want to replicate base table data between two sites in the same database. For example, you might want to maintain codes at one site and replicate them to other sites in the database. Whenever a change is made to a code record in the OH site, you want to replicate that change to the MI site. You could set up a replication category that includes the code table, with the Retain Site field cleared. (Clearing the Retain Site field allows the system to create or update a record in the same database table.) Then you create a rule from OH to MI that includes that category.