nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Basic license exporting into SQL Server

SimonJackson

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?

Find more posts tagged with

Accepted answers

Asrujit_SenGupta

ArcGIS Desktop 10.5: ArcMap Functionality Matrix

Check Page -30 as per the above PDF.

All comments

JoshuaBixby

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

SimonJackson

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.

Asrujit_SenGupta

ArcGIS Desktop 10.5: ArcMap Functionality Matrix

Check Page -30 as per the above PDF.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.