An overview of the Geodatabase Administration toolset

The Geodatabase Administration toolset contains tools for a variety of geodatabase management tasks. Specific geodatabase data management tools as well as geodatabase upgrade, management, and maintenance are covered by the tools in this toolset.

Tool

Description

Analyze Datasets

Updates database statistics of base tables, delta tables, and archive tables, along with the statistics on those tables' indexes. This tool is used in enterprise geodatabases to help get optimal performance from the RDBMS's query optimizer. Stale statistics can lead to poor geodatabase performance.

Change Privileges

Establishes or changes user access privileges to the input ArcSDE datasets, stand-alone feature classes, or tables.

Compress

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

Create Database User

The Create Database User tool creates a database user with privileges sufficient to create data in the database.

Create Enterprise Geodatabase

The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database.

Create Role

The Create Role tool creates a database role and lets you add users to or remove users from the role.

Enable Enterprise Geodatabase

The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing enterprise database, thereby enabling geodatabase functionality in the database.

Migrate Storage

This tool is designed to change the data types used to store rasters in an ArcSDE geodatabase in Oracle, PostgreSQL, and SQL Server; geometries in geodatabases in Oracle and SQL Server; and BLOB objects in attribute columns in geodatabases in Oracle. This is done through the migration of raster, spatial, or BLOB objects using configuration keywords specified in the DBTUNE table.

Rebuild Indexes

Updates indexes of datasets and system tables stored in an enterprise geodatabase. This tool is used in enterprise geodatabases to rebuild existing attribute or spatial indexes. Out-of-date indexes can lead to poor geodatabase performance.

Register With Geodatabase

Registers feature classes, tables, and raster layers that were created outside of the geodatabase with the geodatabase in order for them to fully participate in geodatabase functionality.

Upgrade Dataset

Upgrades the schema of a mosaic dataset, network dataset, or parcel fabric to the current ArcGIS release. Upgrading the dataset allows the dataset to make use of new functionality available in the current software release.

Upgrade Spatial Reference

Upgrades a low precision dataset's spatial reference to high precision.

Upgrade Geodatabase

Upgrades a geodatabase to the latest release to take advantage of new functionality available in the latest release of ArcGIS. Valid input is a personal or file geodatabase, an sde connection file, or connection information for an ArcSDE geodatabase.

Tools in the Geodatabase Administration toolset

Related Topics

11/18/2013