To ensure that the parent geodatabase can be fully compressed, even with unacknowledged data change messages, the replication must be configured toreplicate only the base tables.
1. What Happens with Unacknowledged Messages?
In traditional one-way replication, unacknowledged data change messages in the delta tables (Adds and Deletes) prevent full compression of the parent geodatabase.
By replicating only the base tables, the replication avoids using delta tables entirely, allowing the geodatabase to be fully compressed.
2. Why Replicate Only the Base Tables?
No Dependency on Delta Tables: This configuration ensures that the replication is based directly on the base table contents. As changes are not recorded in delta tables for replication, the parent geodatabase can be fully compressed without any impact.
Read-Only Copies: The replicated data in the child geodatabase will be read-only, which aligns with the requirement for regional offices.
3. Why Not Other Options?
Use the Full Replica Access Type:
Full replica access allows editing in the child geodatabase, which is unnecessary for read-only requirements. It also uses delta tables, preventing full compression.
Use the Archiving Option:
Archiving tracks historical edits and is unrelated to the replication or compression process. It does not solve the problem of unacknowledged messages blocking compression.
Steps to Set Up One-Way Replication with Base Tables:
OpenArcGIS Proand connect to the parent geodatabase.
Use theCreate Replicatool and selectOne-Way Replication.
Choose the option to replicatebase tables onlyduring the configuration process.
Define the datasets to replicate and complete the replication setup.
References from Esri Documentation and Learning Resources:
One-Way Replication Overview
Compressing Enterprise Geodatabases
Conclusion:
Configuring replication toreplicate only the base tablesensures that the parent geodatabase can be fully compressed, even with unacknowledged data change messages.
