Hi There, We have a geodatabase (ver 10.4.1) hosted on SQL Server 2012. There is a table that has field (Length) that requires field type change from long to double. This field has values. Since the field names are the same and only type changes, here is my workflow:
Here is the ESRI recommended approach.
The issues that we have large number of editors and getting all the users to reconcile and post before making this change will result in delaying this update. I am curious how other community members are making these types of changes.
Appreciate any feedback.
i don't think "Unregister feature class" & "Register feature class as versioned" is required for this workflow. You can check the below technical Article for more details:
FAQ: What schema changes can be made to versioned data?
I would probably do the below:
- Disconnect all users and Reconcile\Post all versions
- Compress the geodatabase
- Make the schema changes