Editing a SQL Server Spatial Type in ArcGIS Pro

1614
6
Jump to solution
04-21-2022 02:06 PM
MichaelTorbett
Occasional Contributor II

Can you edit a feature class with a SQL Server Spatial type in ArcGIS Pro without enabling the database as an Enterprise Geodatabase? I've read through the doc's and haven't been able to find a conclusive answer yet. I'd like to be able to create tables in both SQL Server and ArcGIS Pro with a SQL spatial type for editing in Pro. However, I want to avoid all of the additional tables created when enabling an Enterprise Geodatabase.

I've ran several tests following the help guide here : https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/sqlserver-spatial-... but keep getting a 9999999 error. 

Thank you,

Michael

0 Kudos
1 Solution

Accepted Solutions
GdB_Admin
New Contributor III

Sadly I have not found a way to Edit an SQL Native Database in ArcGIS Pro. Pro requires all of the A, D, I, etc. tables for each item. There is not a way for Pro to understand What everything is when you want to edit. You can view the data in Pro but  editing is not an option. You will need to copy that data into an enterprise database. You can us the import tool to bring it into an enterprise database but what you are looking to do it not possible at this time. 

Thank you for your time on this. Please let me know if you have any questions

View solution in original post

6 Replies
GdB_Admin
New Contributor III

Sadly I have not found a way to Edit an SQL Native Database in ArcGIS Pro. Pro requires all of the A, D, I, etc. tables for each item. There is not a way for Pro to understand What everything is when you want to edit. You can view the data in Pro but  editing is not an option. You will need to copy that data into an enterprise database. You can us the import tool to bring it into an enterprise database but what you are looking to do it not possible at this time. 

Thank you for your time on this. Please let me know if you have any questions
MichaelTorbett
Occasional Contributor II

Thank you GdB_Admin for the reply. I think that answers my question.  It does look like I can publish it as a service to my ArcGIS Server and edit from there. I have not tried it yet, but that would do what I need.

0 Kudos
Scott_Tansley
MVP Regular Contributor

If you have an ArcGIS Server available, then you could look to publish a query layer as a map/feature service combo.  I believe you can then edit via the feature service.

Beyond that the Enterprise Geodatabase provides significant rigour relating to data editing and control.  It's value should not be discounted, and that's why I believe that Esri want us to edit via the Enterprise Geodatabase models.  Query Layers (no sde table) are ready only in 'Desktop GIS' like Pro:

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm#:~...  

Scott Tansley
https://www.linkedin.com/in/scotttansley/
MichaelTorbett
Occasional Contributor II

Thanks Scott! Being able to edit as a feature service would do the trick. I will give that a shot. These spatial types would be created in my agency's master sql database and I wanted to start small. As this grows, we will likely consider adding Enterprise Geodatabase Functionality.

George_Thompson
Esri Frequent Contributor

Here is the doc that references what you are looking for: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_...

--- George T.
MichaelTorbett
Occasional Contributor II

Thank you George. That's exactly what I was looking for. 

0 Kudos