Data migration from one storage type to another

It is important to create the configuration keyword to include the correct parameter and value. If you specify a keyword with incorrect or missing information, the information is read from the DEFAULTS keyword. Be sure the keyword contains the parameter and value to which you are migrating the data, as well as a UI_TEXT parameter. The UI_TEXT parameter makes the keyword available to ArcGIS clients. Provide this keyword to the dataset owners, as they are the ones who must run the Migrate Storage tool.

Tip:

If the table being migrated is registered to participate in traditional versioning, migrating it to a different storage type also updates the corresponding columns in the Adds table. If the feature class has archiving enabled, the archive table's columns are also updated.

Why migrate data?

Access data using SQL

Accessing the information in a geodatabase via SQL allows external applications (those not developed in an ArcObjects environment) to work with the tabular data managed by the geodatabase. If these applications need to access spatial or raster data in the geodatabase, you must store your spatial or raster data in data types that allow SQL access. For example, using the ST_Geometry storage type allows you to access your feature data with SQL, something that you cannot do easily if your data is stored in a BLOB or long raw field.

Move from types that may not be supported in future releases

Migration prerequisites

The following conditions must be met before you can convert your data:

  • You must make a backup of the data before you migrate it.
  • You must be logged in as the owner of the table being migrated.