Skip To Content

Migrate Storage


Changes the data type of the column that stores geometries in geodatabases in Oracle and SQL Server and BLOB objects in attribute columns in geodatabases in Oracle. The configuration keyword you specify when migrating determines the data type used to store the geometry or BLOB object.


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.


  • Add datasets you want to migrate to the Input Datasets parameter and specify the Configuration Keyword that will get you the data type you require.

  • You can use this tool to migrate existing binary or spatial columns from one storage type to another. See more about data migration from one storage type to another.

  • You must own the datasets you are migrating.


MigrateStorage_management (in_datasets, config_keyword)
ParameterExplanationData Type

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

Table View; Raster Layer; Feature Dataset

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.


Code sample

MigrateStorage example (stand-alone script)

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

# Name:
# 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")

Licensing information

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

Related topics