I need to update one field, AnnotationClassID, for all annotation in our versioned SDE. There are close to a million records in a half dozen feature classes. What are the ramifications of using the arcpy.da module to do this task? Curious to know how others have handled this task. Below is a basic sketch of what I had in mind. Many Thanks!
import arcpy import os fc = r'X:\Database connection to vm-sql3.sde\Anno0100scale' workspace = os.path.dirname(fc) edit = arcpy.da.Editor(workspace) edit.startEditing(False, True) edit.startOperation() cursor = arcpy.UpdateCursor(fc, ["AnnotationClassID","SymbolID"]) for row in cursor: row.AnnotationClassID = row.SymbolID cursor.updateRow(row) edit.stopOperation() edit.stopEditing(True)