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)