1

I am looking for a process or a tool that would allow me to migrate data from an ESRI SDE Database to a SQL Spatial Database. This would include converting the ESRI geometry to SQL geometry types, as well as potentially having to convert ESRI domains to lookup tables. I have seen some tools out there that will take shapefiles and convert them to SQL spatial format and I have been successful in doing that but given the amount of data and how dynamic it has been, I would prefer to not have to convert my entire database into shapefiles first. Would it be easier to go from a File/Personal geodatabase?

  • 1
    Do NOT pass a perfectly good spatial database through shapefiles as an exchange format. FileGDB can handle the twists and turns (as can ASCII), or just go with DB-to-DB load. – Vince May 9 '16 at 17:42
1

If you have ArcGIS now, you should use the FME Workbench found in the Data Interoperability Extension to 'read' your SDE data and 'write' it as SQL Server Spatial. Or, get a trial version and migrate all your data over before the trial runs out.

In terms of the domains, If there is an opposite of 'table to domain', use that, and again use FME to load the table as SQL Server non-spatial data.

From there we use Python with pypyodbc to move data between MSSQL servers.

We use QGIS as our main SQL Server Spatial Editor.

  • Thanks for this. We will probably have to get a trial version of the Data Interoperability extension. Do you know if that comes with an Advanced License? I am not seeing it in the list of extensions in Arcmap. Do you have any familiarity with the Migrate Storage tool in regards to an issue like this? Thank you again – acnewell3 May 9 '16 at 15:47
  • Data Interoperability should be available with Advanced license - check your my.esri.com portal for a) the option when provisioning a license to include the data interop. extension and b) that it is available in your list of downloads from the ArcGIS Desktop installation files. Also: the migrate storage tool looks like a way to move your SDE data from the 'old' spatial data format that SDE used to use to the 'native' spatial data format now employed by MSSQL, Oracle, and PostgreSQL (postgis geometry)...but not to convert your data to a 'native spatial database' that doesn't use ArcSDE – DPSSpatial May 9 '16 at 17:05
0

Why not use GDAL/OGR? You should be able to convert directly from your sde database to sql server. Here are some links that might help:

This one should give you the syntax for your sql server connection: https://alastaira.wordpress.com/ogr2ogr-patterns-for-sql-server/

This helps with the syntax for your sde connection: How to migrate data from ArcSDE to PostGIS?

  • I've never been able to get GDAL/OGR to connect to/from our MSSQL instances... – DPSSpatial May 9 '16 at 18:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.