Compress (Data Management)

Summary

Compresses an enterprise geodatabase by removing states not referenced by a version and redundant rows.

Usage

  • 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.

Parameters

LabelExplanationData Type
Input Database Connection

The database connection file that connects to the enterprise geodatabase to be compressed. Connect as the geodatabase administrator.

Workspace

Derived Output

LabelExplanationData Type
Compressed Input Workspace

The compressed input geodatabase.

Workspace

arcpy.management.Compress(in_workspace)
NameExplanationData Type
in_workspace

The database connection file that connects to the enterprise geodatabase to be compressed. Connect as the geodatabase administrator.

Workspace

Derived Output

NameExplanationData Type
out_workspace

The compressed input geodatabase.

Workspace

Code sample

Compress example (Python window)

This stand-alone Python script uses the Compress tool to compress the geodatabase.

import arcpy
arcpy.Compress_management("c:/Connection to brockville.sde")

Environments

Related topics