ArcObjects Library Reference (GeoDatabase)  

IDatasetMigration Interface

Provides access to members that migrate a dataset.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Description

The IDatasetMigration interface has methods for migrating the geometry, attribute and raster binary storage types of a dataset from an SDE data source. The migration path is based on parameters of the specified keyword.

Members

Description
Method MigrateAttributeStorage Migrate the attribute field storage.
Method MigrateGeometryStorage Migrate the geometry field storage.
Method MigrateRasterStorage Migrate the raster storage.
Method MigrateStorage Migrate all binary field storage.

Remarks

An exclusive schema lock should be acquired for the dataset prior to calling any of this interface's methods. An exclusive schema lock can be acquired by using the ISchemaLock interface.

The IFeatureClassStorage interface can be used with an SDE feature class to determine the type of geometry storage being used. If the geometry is migrated to a new storage type, the feature class must be re-opened for the IFeatureClassStorage to return the new value.

Consult the topic "Data migration from one storage type to another" in the ArcGIS Help system prior to migration. There are special cases to be aware of; for example, migrating from SDEBINARY to GEOGRAPHY with SQL Server is not recommended for feature classes with Z or M values.

Valid geometry migration paths for SDE/Oracle are:
  Long Raw to Blob (SDEBINARY to SDELOB)
  Long Raw to ST_Geometry (SDEBINARY to ST_GEOMETRY)
  Blob to ST_Geometry (SDELOB to ST_GEOMETRY)
  SDO_Geometry to ST_Geometry (SDO_GEOMETRY to ST_GEOMETRY)

Valid geometry migration paths for SDE/SQL Server are:
  SDEBINARY to GEOMETRY
  SDEBINARY to GEOGRAPHY
  OGCWKB to GEOMETRY
  OGCWKB to GEOGRAPHY

Valid attribute migration paths for SDE/Oracle are:
  Long Raw to Blob

Valid raster migration paths for SDE/Oracle are:
  Long Raw to Blob
  Long Raw to ST_Raster
  Blob to ST_Raster

Valid raster migration paths for SDE/PostgreSQL are:
  Binary to ST_Raster

Valid raster migration paths for SDE/SQL Server are:
  Binary to ST_Raster