Skip to main content
  • EN

Is there a parameter that needs to be set or a specific trick to getting the legacy ESRI sde writer to update archive tables when inserting records?

The current setup is as follows

A direct connection to an ArcGIS v10 geodatabase in an oracle 11g database, writing directly to the DEFAULT database version. The schema for the feature class is derived from a workspace resource pointing at the same sde database with the same connection details

This correctly updates the Adds tables for the versioned feature clases but no records are inserted into the archive tables. Is this just a product limitation, a bug or am I missing something?

I can get the archive tables to update correctly when using the ESRI Geodatabase writer, but want to avoid this due to the ArcGIS license requirements and the performance benefits of the legacy writer.

Hi David,

This won't be possible using the legacy Esri SDE writer. That writer won't know anything about the archive tables as they are part of the Geodatabase model. It may be possible to write to them as "regular" feature types, adding additional field values as required to maintain the archiving information. But we haven't tried that ourselves so you would be off in uncharted territory if you tried it.

We recommend using the Esri Geodatabase writer for accurately maintaining your archive tables.

Regards,

Robyn

Reply


Community Stats

30,108
Posts
114,286
Replies
37,742
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.