topic Re: Basic license exporting into SQL Server in Data Management Questions

Basic license exporting into SQL Server

SimonJackson — Wed, 25 Oct 2017 03:53:58 GMT

I have no need for an Enterprise Geodatabase. However, I was using an advanced license with ArcGIS Pro to export/copy simple polygon featureclasses directly into SQL Server 2016 (stored as native geoms).

This was done through simply copying my layer in the catalog pane, and pasting into the database connection to a SQL Server instance (no Enterprise Geodatabase).

However, I now have a basic license and it would appear that I can't perform this operation. Can someone confirm this is expected behavior? I assumed Basic would let me still work with SQL Server native spatial tables?

And if so, is there a good workaround for this?

Re: Basic license exporting into SQL Server

Asrujit_SenGupta — Wed, 25 Oct 2017 04:44:22 GMT

ArcGIS Desktop 10.5: ArcMap Functionality Matrix

Check Page -30 as per the above PDF.

Re: Basic license exporting into SQL Server

SimonJackson — Wed, 25 Oct 2017 05:09:31 GMT

I missed that. Thanks for pointing that out.

Other than bumping up to Standard, if this is the only capability I require, can anyone suggest some workarounds?

I have used shp2sql tool in the past, but perhaps this process would be suitable for something like GDAL? From memory this has capability to read from a file geodatabase and write into SQL Server.

Re: Basic license exporting into SQL Server

JoshuaBixby — Wed, 25 Oct 2017 15:27:25 GMT

I haven't tried it myself, but it seems one could use Features To JSON—Conversion toolbox | ArcGIS Desktop to export the data as GeoJSON and then load it into SQL Server using a technique outlined in Loading GeoJSON data into SQL Server | SQL Server Database Engine Blog