nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

MikeSchonlau

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?

Vind meer berichten getagd met

Accepted answers

MikeSchonlau

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

All comments

NidhinKarthikeyan

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.

MikeSchonlau

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

ShannonPugh

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.

JamesFieman

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

Thanks Mike

JenniferCasey1

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

ShannonPugh

Really? Which version of ArcGIS Desktop are you using?

JenniferCasey1

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

ShannonPugh

Append worked well in ArcGIS Pro also.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.