How do I convert my data from SDE Binary to a spatial type?


This question has come up a few times from clients recently, and thought this article would be useful for other users wanting to make use of their DBMS spatial types.

At ArcGIS 9.3, a new geoprocessing tool (Migrate Storage), has been added which makes migrating your SDE Binary data to the new SQL Server spatial types such as Geography and Geometry spatial types quite simple.

This geoprocessing tool, allows you to choose the datasets that you would like converted, and the configuration keyword – such as SDO_GEOMETRY (for Oracle DBMS) or Geography (for SQL Server 2008 spatial types) – that you want your dataset/s converted to.

The Migrate Storage (Data Management) Tool can be accessed via ArcToolbox > Data Management Tools > Database toolset > Migrate Storage.

Tania T.

One thought on “How do I convert my data from SDE Binary to a spatial type?

  1. Pius

    Great stuff! Please how do I convert a spatial column stored as SDEBINAY (an int type) to ST_Geometry in an ArcSDE 10 Geodatabase stored in MS SQL Server 2008 DBMS? Can this be done at the database level using the SQL Database management studio? Thanks for your kind response.

    Reply

Got something to say?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s