Change the precision and scale during an export

Summary

In some cases, when importing data, the data type is changed and the precision and scale are not maintained. This is because data types behave differently between database management systems and ArcGIS software.

ArcGIS Desktop provides default values for precision and scale when using tool functions such as copy/paste and export. When transferring a table between geodatabases or databases, it is possible to change the precision and scale of the values in the table during the transfer.

Procedure

The following steps describe how to change precision and scale during an export:

1. In ArcCatalog, right-click the desired feature class or shapefile.
2. Navigate to Export > To Geodatabase.
3. Fill in the Output Location and Output Feature Class name.
4. In the Field Map, right-click the field name > Properties.
   
   
    
5. Change the precision and/or scale.
   
   
    
6. Click OK and execute the export.