When developing a new Roads and Highways database, I have been told that ESRI recommends to develop the database in a file geodatabase and then copy that into an enterprise geodatabase. When you do that it will convert all the fields of type FLOAT to DOUBLE. I think this as a result of not being able to set the precision or scale in a file geodatabase. As far as I can tell you cannot alter the data type of the field in the enterprise geodatabase once it is copied over.
Maybe I miss-understood the recommendation and the true direction was to play around with creating the database in a file geodatabase and the recreate that database in an enterprise geodatabase rather than a copy and paste operation.
Does anyone have any insight into this or a way to alter the field type after copying the data from the file geodatabase to the enterprise geodatabase.
Thanks