SQL Server query

MarkBalman

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

George Thompson

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.