SQL Table Field Type OBJECT_ID

EmilyLaMunyon

Hello,

I have an ODBC connection in ArcCatalog to a non-spatial SQL table. I need to put the table in a SDE Geodatabase and am having some issues.

When viewing the non-spatial SQL table fields in ArcCatalog I noticed that one of the field types was changed from int to OBJECT_ID, I assume this is becasue it needs a unique key field. However, this is causing problems when I try and import the SQL table into a geodatabase, it drops the field and adds another OBJECT_ID field. I need this field to be there, it is important.

I have tried creating an empty table in SDE that includes the fields/schema I need and then appending the rows from the SQL table to the empty table and in the process mapping the fields to try and bring the one being dropped over. The problem is that it is not populating the field with the values I need.

Please help, I am at a loss!!

Thanks in advance! 🙂

jskinner

Here is a preview of my table in SQL Server in design view with the primary key applied to the ID field:

[ATTACH=CONFIG]11668[/ATTACH]

Right-click on the ID field > Indexes/Keys > choose to Delete this index:

[ATTACH=CONFIG]11669[/ATTACH]

Right-click on the ID field > Indexes/Keys > create a new Clustered index:

[ATTACH=CONFIG]11670[/ATTACH]

Save the changes you have made, then import the table into the SDE geodatabase.  Afterwards, the ID field will remain and a OBJECTID field will be created:

[ATTACH=CONFIG]11671[/ATTACH]

Note:  The ID field will now be able to contain duplicates.