ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Migrate Storage

  • Summary
  • Usage
  • Syntax
  • Code sample
  • Environments
  • Licensing information

Summary

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.

Caution:

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.

Usage

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

  • 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. If you are not sure which configuration keyword to use, contact your geodatabase administrator for that information.

  • You must own the input datasets.

Syntax

arcpy.management.MigrateStorage(in_datasets, config_keyword)
ParameterExplanationData Type
in_datasets
[in_dataset,...]

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
config_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.

String

Derived Output

NameExplanationData Type
out_datasetss

The updated input datasets.

Table View; Raster Layer; Feature Dataset

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

  • Current Workspace
  • Output CONFIG Keyword

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes

Related topics

  • An overview of the Geodatabase Administration toolset
  • Configuration keywords
  • Oracle configuration parameters
  • SQL Server configuration parameters

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal