Hot answers tagged arcsde
Here, just reorganize your try/except block and put it inside the for loop: for workspace in workspaces: try: arcpy.Compress_management(workspace) except: arcpy.GetMessages()
It is never necessary to use Create Spatial Type on a properly configured enterprise geodatabase. Create Spatial Type is a limited subset of Enable Enterprise Geodatabase, where only the SDE.ST_GEOMETRY datatype is wanted. Quoting the documentation (emphasis mine): This allows you to use the ST_Geometry SQL type to store geometries in a database that ...
You'll need to use IMultiuserWorkspaceEdit in combination with IWorkspaceEdit: You'll need to specify whether the featureclass to edit is versioned or not: muWorkspaceEdit.StartMultiuserEditing(esriMultiuserEditSessionMode.esriMESMVersioned); or muWorkspaceEdit.StartMultiuserEditing(esriMultiuserEditSessionMode.esriMESMNonVersioned);
I would suggest you create a series of models using iterators. You can create a model for each type and nest the models as sub models in order to include all of them into a single model. You would have to do this because a model can have only one iterator. So each model will iterate through the data object then deltete. Use preconditions to control the flow. ...
Copy Features handles the conversion of file formats (shp into sde-fc like in your example) simply by what workspace has been defined in the output path.
There are three sets of properties to be aware of here: The envelope of horizon of the coordinate system, The extent of the coordinate reference, and The envelope of the feature class. The coordinate system horizon is mathematical space accessible by the coordinate system (e.g., infinite X, -90...+90 Y for GCS_WGS_1984). Esri uses these horizons to ...
As discussed in the comments, this appears to be a bug of some sort. Use the workaround Exists`Delete` method: if arcpy.Exists (fc): arcpy.Delete_management (fc)
Changing feature class column names directly in SQL Server will often corrupt the feature class as SDE keeps track of column names behind the scenes. Change the column names back to to their original names in SQL Server.
Only top voted, non community-wiki answers of a minimum length are eligible