SQL Insert & update archived feature class in SQL Server

MichalSchneider — Wed, 16 Apr 2014 07:46:23 GMT

Hi,

I'm trying to insert and update features with SQL commands in feature class enabled for archiving in SQL server. I'm trying to follow help instructions in section Geodata / Administering geodatabases / Using SQL. I'm calling INSERT and UPDATE SQL commands directly on archive view, for example BROWNFIELDS_P is table with archived data and BROWNFIELDS_P_EVW is the archived view.

When I try to run SQL command on archived view, INSERT commands seems to be OK. But when I try to UPDATE any row by "WHERE OBJECTID = 0", I get PRIMARY KEY constraint error.

Is it possible to perform INSERT and UPDATE SQL commands directly on archived view or should I use these commands on underlying table and extend there commands with GDB_ARCHIVE_OID, GDB_FROM_DATE and GDB_TO_DATE columns?

Thank you very much for your advice!

Re: SQL Insert & update archived feature class in SQL Server

NilsBabel — Tue, 28 Jul 2015 15:19:57 GMT

Ever find an answer to this? I'm trying to do something similar and am wondering how to get the correct records using SQL.

Re: SQL Insert & update archived feature class in SQL Server

vijaybadugu — Thu, 19 Jun 2025 20:10:16 GMT

You could update/insert/ delete by using _evw . it does care of all GDB columns automatically.

topic Re: SQL Insert & update archived feature class in SQL Server in Data Management Questions

SQL Insert & update archived feature class in SQL Server

Re: SQL Insert & update archived feature class in SQL Server

Re: SQL Insert & update archived feature class in SQL Server