Re-enabling Archiving

Question

Just wondering if it's possible to do the following:

I have a archived feature class and want to change the projection of it. So if I disable archiving and orphan that archived table, it appears in SDE geodatabase with an underscore H. Then after the projection I want to re-associate that archived table, rather than create a new archive. Is it possible to do this somehow?

ShaunWeston · Answer

Have a read through this blog post:

http://gdbgeek.wordpress.com/2011/11/22/restoring-geodatabase-history/

This is the method I used to re-enable archiving and it worked really well, although if you've got data in a geometric network it takes a while to append data back in.

DominickCisson · Answer

There is currently no way to complete this process using COTS tools within ArcGIS to re-link a previous archive class.  Although unsupported, there are blogs outlining where others have found methods to accomplish this.  If I can find the link I will try and post.

You may want to promote this suggestion on the Ideas site as well:

Enable the ability to Re-Associate Archive Tables

-Jon

Did you find links to these blogs?  I've searched quite a bit to no avail.  This is a rather intractable problem work around.

Dom

DominickCisson · Answer

Is there any way at all to even preserve archive data?  For example, there seems to be no known tool or out of the box solution to even keep a featureclass's archive data with it when it is copied from one geodatabase to another.  This seriously negates the usefulness of the feature.  I'm looking at an upcoming SDE migration from one server to another, from one SDE version to another, and from one SQL Server Version to another, all at the same time.  For these and other reasons, I'd rather not migrate using a SQL Server data dump, but instead selectively move feature classes one at a time to the new database.  Is there any way to do this, and somehow preserve the archive data?  For some of our feature classes it goes back five years.