Field Type Changes in a versioned Table with existing values

jayshukla — Mon, 06 May 2019 21:07:38 GMT

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:

Create a field called LengthTemp
Using Edit session, Calculate value from Length to LengthTemp
Remove Length field
Add Length as double field type
Calculate value from LengthTemp to Length field
Remove Length field

Here is the ESRI recommended approach.

First reconcile and post all the versions
Unregister feature class
Change schema
Register feature class as versioned

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.

Re: Field Type Changes in a versioned Table with existing values

Asrujit_SenGupta — Tue, 07 May 2019 05:53:42 GMT

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

topic Field Type Changes in a versioned Table with existing values in Geodatabase Questions

Field Type Changes in a versioned Table with existing values

Re: Field Type Changes in a versioned Table with existing values