I am trying to share a table with SYNC enabled, but the table's objectID was created with 64bit ObjectID. How do I downgrade the ObjectID?
I tried "export features" , and "import feature class"; neither of them allowed me to change the objectID data type.
There's a geoprocessing tool to upgrade the objectID to 64bit, but no downgrade tool.
Solved! Go to Solution.
Thanks for the help. I don't have the ArcSDE only Pro and Online. I ended up using FME and changed the objectID from int64 to int32, then overwritten the table in the FileGeoDabase.
You could firstly flush the data into PostGres with ArcSDE, and then change the field type to the SmallInt or Integer type instead of BigInt, then export the data again from ArcSDE to your feature class.
Thanks for the help. I don't have the ArcSDE only Pro and Online. I ended up using FME and changed the objectID from int64 to int32, then overwritten the table in the FileGeoDabase.
In ArcGIS Pro, use Create Feature Class (Data Management)—ArcGIS Pro | Documentation geoprocessing tool instead of the "New > Feature Class" context menu in Catalog. The geoprocessing tool allows you to pick between 32-bit and 64-bit ObjectIDs.
When will sync on AGO allow 64 bit object ID?
For future reference, here is the link to the idea you posted:
ArcGIS online to allow sync for datasets with 64bit ObjectID.
to my mind all of this is not really a "solution". int32 provides the capacity of about 12 bilion oids - so in next to all cases that should be sufficient. and if a dataset comes with int64 oid there should be a straight forward approach out of the box - i.e. a simple arcgis pro function.
sorry typo: 2,1 billion