Compresses an enterprise geodatabase by removing states not referenced by a version and redundant rows.
To improve geodatabase performance, compress the geodatabase periodically. A compressed geodatabase is more efficient.
Once a geodatabase is compressed, deleted records cannot be recovered.
Compressing a geodatabase not only reduces space requirements but can also reduce overall retrieval times.
While the Compress tool is running, you can still view data in the geodatabase.
Only the geodatabase administrator can perform compress.
This tool is not applicable to enterprise geodatabases that do not use versioning.
| Label | Explanation | Data Type |
Input Database Connection | The database connection file that connects to the enterprise geodatabase to be compressed. Connect as the geodatabase administrator. | Workspace |
| Label | Explanation | Data Type |
| Compressed Input Workspace | The compressed input geodatabase. | Workspace |
arcpy.management.Compress(in_workspace)
| Name | Explanation | Data Type |
in_workspace | The database connection file that connects to the enterprise geodatabase to be compressed. Connect as the geodatabase administrator. | Workspace |
| Name | Explanation | Data Type |
| out_workspace | The compressed input geodatabase. | Workspace |
This stand-alone Python script uses the Compress tool to compress the geodatabase.
import arcpy
arcpy.Compress_management("c:/Connection to brockville.sde")