topic Re: Dropping a Field on Archive Enabled Dataset in Geodatabase Questions

Dropping a Field on Archive Enabled Dataset

HiteshJilka — Wed, 09 Nov 2016 10:21:20 GMT

Hello, I am testing a scenario where if I drop a field on Archive enabled dataset it also deletes the same field on Archive table. But I wanted to preserve that field and its data on Archive table. Is it possible ?

I would not likely to disable archiving before deleting a field and re-enable it again as dropping a field can be done anytime and by anyone who is not aware of Archiving.

Also, is it possible to use the same archive table again after re-enabling Archive for same dataset ?

Re: Dropping a Field on Archive Enabled Dataset

Asrujit_SenGupta — Wed, 09 Nov 2016 10:53:37 GMT

No, once you have disabled Archiving on the data, you cannot use the old Archive table while re-enabling Archiving again. Enhancements have been logged for this functionality.

NIM050307 - Option to attach the old archive table (_h) back to the original feature class on re-enabling archiving

The only option seems to be taking a separate backup of the History Table before you delete any field.

Re: Dropping a Field on Archive Enabled Dataset

HiteshJilka — Thu, 10 Nov 2016 06:01:42 GMT

Thanks Asrujit, did you get any update on logged case NIM050307 ?

Re: Dropping a Field on Archive Enabled Dataset

Asrujit_SenGupta — Thu, 10 Nov 2016 14:41:38 GMT

Not really. For an update you will need to contact Esri Technical Support or your local Esri Distributor.