Select to view content in your preferred language

Append Feature Classes using SQL insert

1044
2
10-09-2019 06:45 PM
JoseSanchez
Regular Contributor

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

0 Kudos
2 Replies
JoshuaBixby
MVP Esteemed Contributor

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
Occasional Contributor

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

0 Kudos