topic Load data in existing Geodatabase table using Sql Server in Data Management Questions

Load data in existing Geodatabase table using Sql Server

MARIASALAZAR — Fri, 07 May 2010 16:27:47 GMT

How do I load sql table data into an existing Geodatabase table using sql server? I keep getting an error with the ObjectID.

Re: Load data in existing Geodatabase table using Sql Server

VinceAngelo — Fri, 07 May 2010 16:53:09 GMT

What error are you receiving?

Is the objectid column the SDE-set registered rowid for the table?

How did you attempt to populate the new row(s)?

- V

Re: Load data in existing Geodatabase table using Sql Server

MARIASALAZAR — Fri, 07 May 2010 20:29:40 GMT

I created a Visio UML Geodatabase - Imported the schema in ArcCatalog and I am trying to load the GDB Tables using Sql Server from scripts that I wrote. The INSERT INTO GDBtable script gives me an error - Cannot insert the value NULL into column 'OBJECTID' ...

If I change the column property 'Identity Specification' - (Is Identity) to 'Yes'. I can run the script successfully and load data but when I try to edit the table in ArcMap, it will crash. If I open the attribute table during an edit session and then close table without editing an error message appears: Loading Data Table - Could not load data from source. If you correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invalid field, ect. There is no geometric network. There must be a geometric network to preform this action.