Select to view content in your preferred language

OBJECTID - configuring auto increment via SQL Server post feature class creation

76
0
a week ago
Labels (1)
AnnetteFarrell
Emerging Contributor

We have a SQL Server SDE asset data warehouse that is filled without involving ArcGIS technology. 
The data warehouse is used with AGE 11.1 and Pro 3 and these feature classes are used in a read only non versioned manner.

The ETL tooling used to fill the data warehouse has no way of handling the auto increment on the OBJECTID.

The data warehouse developers have proposed turning auto increment on for the OBJECTID field in SQL Server via a script AFTER the feature class has been created in ArcGIS Pro.

What is the wider impact of doing this when the feature class table will be read only and non versioned?  The feature classes are simple tables with assets and have no attachments.  I've had a look at this post already but the wider impact is not fully clear to me.

Thanks  

Tags (1)
0 Kudos
0 Replies