SQL Server query

MarkBalman — Fri, 28 Aug 2020 12:18:19 GMT

Hi all

A quick question, I have recently loaded some data into SQL Server and now investigating how to edit this data within ArcGIS Pro. Given that this is a large dataset, I don't want to load all of the data into ArcGIS Pro and then create a definition query in order to edit the features. Something akin to Query Layer, but with ability to edit the geometry is what I am looking for. Does something like this exist?

Thanks in advance for any suggestions

Mark

Re: SQL Server query

George_Thompson — Fri, 28 Aug 2020 12:55:33 GMT

Is the SQL Server DB a geodatabase?

If not, look at this - Databases and ArcGIS—ArcGIS Pro | Documentation

Edit data
You cannot connect directly to most supported databases* from ArcGIS Pro and edit the data. To edit database data, you must publish it.
If you have a GIS Server site federated with an ArcGIS Enterprise portal, publish a web feature layer that references your source data. This creates a feature layer item in the portal that you can share with groups whose members need to edit the data. Set the level of editing you want to allow through the web feature layer.
If you have a stand-alone GIS Server site, publish a map service with feature capabilities enabled, enable editing on the service, and give people access to it so they can edit the data.

topic Re: SQL Server query in ArcGIS Pro Questions

SQL Server query

Re: SQL Server query