topic How to load features + attachments from FGDB to existing SDE GDB in Data Management Questions

How to load features + attachments from FGDB to existing SDE GDB

MikeSchonlau — Wed, 07 May 2014 15:07:28 GMT

I've got an existing feature class with attachments enabled in SDE. I have a file geodatabase with new features and their related attachments that I want to load into SDE. What is the best practice for loading these new features and attachments into an existing feature class? The data loader only takes the point features. The Add Attachments tool requires the attachments to be in a folder as individual files. Any ideas?

Re: How to load features + attachments from FGDB to existing SDE GDB

NidhinKarthikeyan — Thu, 08 May 2014 10:07:55 GMT

Copy and Paste the features from File Geodatabse to ArcSDE Geodatabase (Make sure the Geometry and Schema is same). The issue with Copy/Paste feature option is that, the old row will be retained and the new rows will be created in attribute table, once you Paste the feature. The attribures wont be overwritten.

If you have only few feature to update in ArcSDE, then its better to update it directly in ArcSDE Gdb.

Attachment can be added after updating the Features in ArcSDE Geodatabase.

Make sure you have complete backup of the database before you try this.

Re: How to load features + attachments from FGDB to existing SDE GDB

MikeSchonlau — Tue, 13 May 2014 14:26:19 GMT

Thanks for your feedback, but this workflow does not work for me. By default, the gdb attachments table uses a REL_OBJECTID field to link its features. When the features are copied and pasted or loaded with the data loader into the SDE feature class, the ObjectID's are overwritten. This severs the linkage between the new features and the FGBDB attachments table.

I solved my problem with the following steps:

Copied and pasted new FGDB features to SDE feature class

Added field to FGDB feature class called "NEW_OBJECTID"

Joined SDE feature class to FGDB feature class using a different common field ("Outfall_ID")

Field calculated NEWOBJECTID attribute with OBJECTID from SDE feature class

Added field to FGDB Attachments table called "NEW_OBJECTID"

Joined FGDB feature class to FGDB attachments table using OBJECTID-to-REL_OBJECTID

Field calculated NEW_OBJECTID attribute in FGDB attachments table using NEW_OBJECTID from FGDB feature class

Used data loader to load FGDB attachments table into SDE attachments table specifying REL_OBJECTID as the target and NEW_OBJECTID as the matching field

Re: How to load features + attachments from FGDB to existing SDE GDB

ShannonPugh — Tue, 05 Apr 2016 21:15:33 GMT

That is just an awesome solution! Though it seems that there should be an easier way, your solution works like a charm. Thanks, I've been fretting over this one.

Re: How to load features + attachments from FGDB to existing SDE GDB

JamesFieman — Wed, 06 Sep 2017 21:10:56 GMT

I recently tried this method, and it seemed to work after the first step!

Thanks Mike

Re: How to load features + attachments from FGDB to existing SDE GDB

JenniferCasey1 — Mon, 29 Oct 2018 17:13:32 GMT

I was able to use the Append(Data Management) tool. It brought over the the feature and kept the relationship with REL_OBJECTID intact.

Re: How to load features + attachments from FGDB to existing SDE GDB

ShannonPugh — Mon, 29 Oct 2018 17:48:13 GMT

Really? Which version of ArcGIS Desktop are you using?

Re: How to load features + attachments from FGDB to existing SDE GDB

JenniferCasey1 — Mon, 29 Oct 2018 20:08:20 GMT

I am using 10.5.1 and there are no duplicate Global IDs between my FGDB and SDE.

Re: How to load features + attachments from FGDB to existing SDE GDB

ShannonPugh — Tue, 16 Mar 2021 21:23:21 GMT

Append worked well in ArcGIS Pro also.