Compresses an enterprise geodatabase by removing states not referenced by a version and redundant rows.
To improve geodatabase performance, the geodatabase should be compressed periodically. A compressed geodatabase is more efficient. A geodatabase that is never compressed is more likely to develop errors.
Once a geodatabase is compressed, deleted records cannot be recovered.
Compression of geodatabases not only reduces space requirements but can also reduce overall retrieval times.
When the Compress tool is executed, the geodatabase is unavailable until compression is completed.
Only the geodatabase administrator can perform compression.
This tool is not applicable for enterprise geodatabases that do not use versioning.
Specify the database connection file that connects to the enterprise geodatabase to be compressed. Connect as the geodatabase administrator.
This stand-alone Python script uses the Compress tool to compress the geodatabase.
import arcpy arcpy.Compress_management("c:/Connection to brockville.sde")
- ArcGIS Desktop Basic: No
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes