Editing a SQL Server Spatial Type in ArcGIS Pro

[MichaelTorbett]

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

[GdB_Admin · Accepted solution]

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. 

[MichaelTorbett]

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.

[Scott_Tansley]

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#:~...  

[MichaelTorbett]

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]

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_...

[MichaelTorbett]

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