Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This guide provides recommendations for minimum SQL Merge Replication to keep ACM working in case of a fail-over.; however,  More more can be done using replication. Below is an outline of the core tables to help guide you in setting up your system.

...

Historical EFM data is stored in multiple tables. If you replicate your EFM data, you may also want to replicate the position of publisher pointers to prevent accidental republishing of your data on fail-over.

...

The below history tables contain information to help decode records and store the database version information. They do not change between builds, so replication is optional.

tblDbVersion
tblGcWriteResultLookup
tblLookupCommType
tblLookupPeriod
tblLookupPollFailCode
tblLookupPollStatus
tblLookupRefProp
tblLookUpTypeID