Migrate Storage (Data Management)
Summary
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.
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
| 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
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 stoage type
# Import arcpy module
import arcpy
# Local variables:
inputDataset = "Database Connections\\Oracle on barbara.sde\\MAP.SBMigrate"
# Process: Migrate Storage
arcpy.MigrateStorage_management( inputDataset, "ST_GEOMETRY")