Append Feature Classes using SQL insert

[JoseSanchez]

Hello everyone,

Is there a way to append feature classes using a SQL Insert statement, running directly  SQL Server, or is it required to run an append in ArcCatalog, Model Builder, Python ...

Thanks

[JoshuaBixby]

Possible, but risky unless you really understand how geodatabases are implemented in DBMSs.  I would start with SQL and enterprise geodatabases—Help | ArcGIS Desktop and especially SQL access to enterprise geodatabase data—Help | ArcGIS Desktop 

[CraigSwadner]

This was useful to me, http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-sqlserver.htm

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net