Copy or export a feature class with archiving and attachments

Question

Hi,

I need to copy or export a feature class with archiving and attachments atives from a GDB postgreSQL 10.23 ESRI geodatabase 10.7.1  to a GDB postgreSQL 14.9 ESRI geodatabase 11.2.

There is not a ArcToolbox for this win ArcGis Pro 3.2.2. The tool copy/paste doesn't copy the archiving just copy the atives objects and their respetive ative attachments.

Someone could help me? Someone know how to do this?

I need to export (or copy) a feature class and restore with the archiving enable...

Thanks.

Robert LeClair · Answer

@NicolasGIS - I looked into this question again and tested on my parent enterprise geodatabases as well.  When creating a one-way replica, the attachments do "copy" over to the child enterprise geodatabase just fine BUT the archive class does not.  I verified this looking into PGAdmin at the gisowner scheme in the child enterprise geodatabase.  I can see the tables for the attachments but not the _h table for the archive class.

Furthermore, there was an ENH-000134153 - Allow historical data to be copied along with archived feature class when moved between geodatabases created a while ago that's under Technical Review by the ArcGIS Pro Development Team.  So no solution to my knowledge.

NicolasGIS · Answer

Hello @Pedro_DavidPereira  and @Robert_LeClair ,

Did you manage to find a solution ? I am having the same requirement (backup both archiving and attachements) but can't find to do using ArcPy.

Thanks !

Robert LeClair · Answer

Hi Pedro - yes, I can assist you with this if you like.  My email is rleclair at esri dot com - we can set up a Teams meeting to go over the workflow if you like.  Let me know.