Migrate Storage

Summary

This tool is designed to change the data types used to store rasters in an enterprise 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.

Caution:

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

Usage

• Add datasets you want to migrate to the Input Datasets list and specify the Configuration Keyword that contains the migration parameters.

Syntax

MigrateStorage_management (in_datasets, config_keyword)

Parameter	Explanation	Data Type
in_datasets [in_dataset,...]	Datasets to be migrated.	Table View; Raster Layer; Feature Dataset
config_keyword	DBTUNE configuration keyword containing the appropriate parameter values for the migration.	String

Code sample

MigrateStorage example (stand-alone script)

The following stand-alone script demonstrates how to use the Migrate Storage tool to migrate the input dataset to the ST_Geometry geometry storage type.

# Name: MigrateStorage_Example.py
# Description: Migrates the input dataset to the ST_Geometry geometry storage type. 

# Import arcpy module
import arcpy

# Local variables:
inputDataset = "f:\\Connections\\Oracle on khyber.sde\\MAP.SBMigrate"

# Process: Migrate Storage
arcpy.MigrateStorage_management( inputDataset, "ST_GEOMETRY")

Environments

• Current Workspace
• Output CONFIG Keyword

Licensing information

• ArcGIS for Desktop Basic: No
• ArcGIS for Desktop Standard: Yes
• ArcGIS for Desktop Advanced: Yes