AnsweredAssumed Answered

Edit SDE Data in GP Service: arcpy.da.Editor vs arcpy.ArcSDESQLExecute

Question asked by MollyKFoley on Apr 2, 2018
Latest reply on Apr 2, 2018 by MollyKFoley

I have heard different things about each of these strategies and I am unsure what best practice is. arcpy.da.Editor seems like the way to go because it's purposely made to integrate into python scripts, but I've also seen reports that it's a bit unstable and instability isn't good in a production environment. On the other hand, the data I need to insert into our SDE databases is spatial, so I'm not sure ArcSDESQLExecute would even work. Anybody explored the pros and cons of these tools?

Outcomes