Understanding table data replication

The BlueCieloECM.GcfSupport class includes the UpdateTable function, which supports updating Meridian Enterprise tables as a part of the replication process. The function supports two scenarios:

• Additive replication – Rows are added to or updated in a table as part of the document management process. Examples of such processes are:
  • Maintaining project data in a table
  • Generating a record for each part number that is created
  • Maintaining counters (or sequences) in a table

In this scenario, rows are never deleted from the table; rows are only added or updated.

• Row ownership – individual table rows are owned by a specific vault. Examples of this scenario are:
  • Maintaining data about users of the vault
  • Maintaining data about customers local to each site

In this scenario, locally owned rows can be added, updated, and deleted. These changes are then replicated to the other collaborating vaults.

To support this scenario, it is necessary for a column to exist in the table that indicates which vault owns each row. This column should contain one of the share names configured on the GCF Configuration page.

For an example of using both scenarios, see UpdateTable example.