Migrate Object ID To 64 Bit (Data Management)

Summary

Migrates a dataset's or multiple datasets' ObjectID field to 64-bit object IDs.

Learn more about migrating to 64-bit object IDs

Usage

• Geodatabase tables and feature classes are created in ArcGIS with 32-bit object IDs by default. However, there are circumstances when object ID values need to be greater than 2.14 billion. For example, you may want to model a dataset with more than 3 billion features.

Caution:

Once a dataset is migrated to 64-bit object IDs, it cannot be reverted to its original state. The minimum client versions that can access the dataset are ArcGIS Pro 3.2 and ArcGIS Enterprise 11.2. After migration, the dataset can no longer be used with ArcMap. You cannot take data offline using the feature sync capability if the data has been migrated to use 64-bit object IDs since the feature service sync capability is not supported with 64-bit object ID data at the time of the ArcGIS Enterprise 11.2 release. You also cannot use the table or feature class in geodatabase replicas if it contains a 64-bit object ID.

• This tool is only supported for data stored in a geodatabase.

• You can use this tool to migrate the object ID field of feature classes that participate in a topology or parcel fabric. However, the topology errors and dirty area tables are not supported.

• Layers with joins are not supported.

• Migrating datasets with existing replicas is not supported.

• If the input dataset is from an enterprise geodatabase, it must be from a database connection established as the data owner. The minimum geodatabase version is 11.2.0.3.2.

• Migrating datasets stored in a Microsoft SQL Server enterprise geodatabase may require a significant amount of transaction log space. For more information, see the Microsoft help.

Parameters

Dialog

Label	Explanation	Data Type
Input Datasets	The datasets that will have their ObjectID field migrated to 64 bit.	Table View; Feature Dataset; Layer

Derived Output

Label	Explanation	Data Type
Updated Datasets	The updated datasets with the object ID field migrated to 64 bit.	Layer; Table View; Dataset

Python

arcpy.management.MigrateObjectIDTo64Bit(in_datasets)

Name	Explanation	Data Type
in_datasets [in_datasets,...]	The datasets that will have their ObjectID field migrated to 64 bit.	Table View; Feature Dataset; Layer

Derived Output

Name	Explanation	Data Type
out_datasets	The updated datasets with the object ID field migrated to 64 bit.	Layer; Table View; Dataset

Code sample

MigrateObjectIDTo64Bit example 1 (Python window)

The following Python script demonstrates how to use the MigrateObjectIDTo64Bit function for a single table input.

import arcpy
arcpy.management.MigrateObjectIDTo64Bit("C:\\Projects\\MyProject\\myGDBConnection.sde\\user1.COUNTIES")

MigrateObjectIDTo64Bit example 2 (Python window)

The following Python script demonstrates how to use the MigrateObjectIDTo64Bit function using a list for multiple layer input.

import arcpy
arcpy.management.MigrateObjectIDTo64Bit(['Cities', 'Roads', 'Rivers', 'Lakes', 'Counties', 'States'])

MigrateObjectIDTo64Bit example 3 (Python window)

The following Python script demonstrates how to use the MigrateObjectIDTo64Bit function for a feature dataset that contains a topology.

import arcpy
arcpy.management.MigrateObjectIDTo64Bit("C:\\Projects\\MyProject\\myGDBConnection.sde\\user1.MyTopologyDataset")

Environments

This tool does not use any geoprocessing environments.

Licensing information

• Basic: Yes
• Standard: Yes
• Advanced: Yes