Community
Select to view content in your preferred language

Append Feature Classes using SQL insert

1199
2
10-09-2019 06:45 PM
JoseSanchez
by
Frequent Contributor
‎10-09-2019 06:45 PM

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
by MVP Esteemed Contributor
MVP Esteemed Contributor
‎10-09-2019 08:11 PM

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
by
Regular Contributor
‎10-10-2019 05:21 AM

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