I use ArcGIS Desktop 10.5 and PostgreSQL 9.5.
I have created enterprise GDB and all my feature classes have attachments. I have some feature classes which have more than 1000 rows and many polygons have two attachments. I want to load data with attachment into another feature class automatically. Is this possible. If yes, how?
I had a contractor help me with moving attachment files from the old standardized fc's (SDSFIE) in SQL to a new standardized fc that held the same data but had different field names. Many of the features had multiple attachments, mostly photos. My head was swimming as she lead me along during a screen share session. Argh! Its the join process that weird's me out. Hopefully it will help YOU!
Warning: Before following these steps make sure you have a backup of both the old and new geodatabases!
Steps provided below are for buildings, but the same steps can apply to any other feature classes with attachments.
buildingOrig: refers to the Building feature class in the old SDSFIE schema
buildingNewSchema: refers to the Building feature class in the new SDSFIE schema
The following steps will change the attachment relationship to use GlobalIds instead of ObjectIds. This will make it easier to move attachments in the future.