3D Analyst Tools ArcToolbox

Import Geodatabase, Migrate Storage, Rebuild Indexes and Register with GDB Tools

Import Geodatabase Configuration Keywords

How to Import Geodatabase Configuration Keywords Tool in ArcToolbox ArcMap ArcGIS??

Import Geodatabase Configuration Keywords

Path to access the tool

:

Import Geodatabase Configuration Keywords Tool, Geodatabase Administration Toolset, Data Management Tools Toolbox

 

Import Geodatabase Configuration Keywords

Define data storage parameters for an enterprise geodatabase by importing a file containing configuration keywords, parameters, and values.

1.    Input Database Connection

The connection file for the enterprise geodatabase into which the configuration file will be imported. You must connect as the geodatabase administrator.

2.    Input File

The path to and name of the ASCII text file containing configuration keywords, parameters, and values to be imported.

Migrate Storage

How to Migrate Storage Tool in ArcToolbox ArcMap ArcGIS??

Migrate Storage

Path to access the tool

:

Migrate Storage Tool, Geodatabase Administration Toolset, Data Management Tools Toolbox

 

Migrate Storage

Moves the data from a binary, spatial, or spatial attribute column of one data type to a new column of a different data type in geodatabases in Oracle and SQL Server. The configuration keyword you specify when migrating determines the data type used for the new column.

After migrating the data type, you must disconnect from and reconnect to the geodatabase to reload the columns. If you do not, subsequent actions executed on the newly migrated datasets may fail.

1.    Input Datasets

Datasets to be migrated. The connection you use to access the datasets must be connecting as the dataset owner.

2.    Configuration Keyword

Configuration keyword containing the appropriate parameter values for the migration. Parameter values are set by the geodatabase administrator. Contact your geodatabase administrator if you are unsure which configuration keyword to use.Configuration Keyword

Rebuild Indexes

How to Rebuild Indexes Tool in ArcToolbox ArcMap ArcGIS??

Rebuild Indexes

Path to access the tool

:

Rebuild Indexes Tool, Geodatabase Administration Toolset, Data Management Tools Toolbox

 

Rebuild Indexes

Rebuild existing attribute or spatial indexes in databases and enterprise, workgroup, and desktop geodatabases. Indexes can also be rebuilt on states and state_lineage geodatabase system tables and the delta tables of versioned datasets. Out-of-date indexes can lead to poor query performance.

1.    Input Database Connection

The connection (.sde file) to the database or geodatabase that contains the data for which you want to rebuild indexes.

2.    Include System Tables

Indicates whether indexes will be rebuilt on the states and state lineages tables.

You must connect as the geodatabase administrator for this option to be activated.

This option only applies to geodatabases. If you connect to a database, this option is disabled.

1. Unchecked—Indexes will not be rebuilt on the states and state lineages table. This is the default.
2. Checked—Indexes will be rebuilt on the states and state lineages tables.

3.    Datasets to Rebuild Indexes For (optional)

Names of the datasets that will have their indexes rebuilt. Only datasets that are owned by the connected user are displayed.

4.    Rebuild Delta Tables Only (optional)

Indicates whether indexes will be rebuilt only on the delta tables of the selected datasets. This option will be unavailable if there are no datasets selected in the list of input datasets.

This option only applies to geodatabases. If you connect to a database, this option is disabled.

1. Checked—Indexes will only be rebuilt for the delta tables of the selected datasets. This option can be used for cases where the business tables for the selected datasets are not updated often and there are a high volume of edits in the delta tables. This is the default.
2. Unchecked—Indexes will be rebuilt on all indexes for the selected datasets. This includes spatial indexes as well as user-created attribute indexes and any geodatabase-maintained indexes for the dataset.

Register with Geodatabase

How to Register with Geodatabase Tool in ArcToolbox ArcMap ArcGIS??

Register with Geodatabase

Path to access the tool

:

Register with Geodatabase Tool, Geodatabase Administration Toolset, Data Management Tools Toolbox

 

Register with Geodatabase

Registers feature classes, tables, views, and raster layers that were created in the database using ArcGIS clients with the geodatabase. Once registered, information about the items—such as table and column names, spatial extent, and geometry type—is stored in the geodatabase's system tables, allowing these registered items to participate in geodatabase functionality.

1.    Input Datasets

The feature class, table, view, or raster created using third-party tools or SQL that you want to register with the geodatabase. The dataset must exist in the same database as the geodatabase.

2.    Object ID Field (optional)

The field that will be used as the ObjectID field. This input is required when registering a view, and you must supply an existing integer field. This parameter is optional when registering other dataset types; if using an existing field it must be an integer data type. If an existing field is not supplied, a new ObjectID field will be created and populated.

3.    Shape Field (optional)

If the input dataset contains a shape column, include this during the registration process.

4.    Geometry Type (optional)

If the Shape Field is present, you must specify a geometry type. Supported geometry types are point, multipoint, polygon, and polyline. If the dataset being registered contains existing features, the geometry type specified must match the entity type of these features.

5.    Coordinate System (optional)

If the Shape Field is present and the table is empty, specify the coordinate system to be used for features. If the dataset being registered contains existing features, the coordinate system specified must match the coordinate system of the existing features.

6.    Extent (optional)

If the Shape Field is present, specify the allowable coordinate range for x,y coordinates. If the dataset being registered contains existing features, the extent of the existing features will be used.