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 utility features, or some of the data you are working with is from cloud data warehouses.

  • 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 will be unable to 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 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, parcel fabric, or utility network.

  • 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.

Parameters

LabelExplanationData Type
Input Datasets

The datasets that will have their ObjectID field migrated to 64 bit.

Table View; Feature Dataset; Layer

Derived Output

LabelExplanationData Type
Updated Datasets

The updated datasets with the object ID field migrated to 64 bit.

Layer; Table View; Dataset

arcpy.management.MigrateObjectIDTo64Bit(in_datasets)
NameExplanationData Type
in_datasets
[in_datasets,...]

The datasets that will have their ObjectID field migrated to 64 bit.

Table View; Feature Dataset; Layer

Derived Output

NameExplanationData 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.

Related topics