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.
Usage
Add datasets you want to migrate to the Input Datasets list and specify the Configuration Keyword that contains the migration parameters.
You can use this tool to migrate existing binary, spatial, or raster columns from one storage type to another. See more about data migration from one storage type to another.
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 MigrateStorage 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
Licensing information
- ArcGIS Desktop Basic: No
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes