I am reading geodatabase using ESRI File reader and this geodatabase contains feature classes with relationship classes. I am trying to write them as it is to another geodatabase. The problem is relationship classes are not created in output geodatabase.


A limitation of FME is that it cannot create relationship classes, but rather assumes they exist in the geodatabase already.

In the introduction of Writing Geodatabase Relationship Classes, it states:

it is assumed that the relationships have already been created in ArcGIS. This is required, as FME cannot create the relationships, but merely populate them.

Something that I've done in the past is to export the schema as an XML Workspace document from the file geodatabase in ArcMap and import that into the new geodatabase. This creates all the tables, feature classes and relationship classes, and then use FME to populate as required.

Be careful if your relationship classes are using GlobalID as the primary key. If so, FME will create a new one when it writes the new feature in the new geodatabase - dropping any relationship.

|improve this answer|||||
  • Thank you. I my self also end up using this approach only thing i did not knew was this GlobalID issue. I will keep in mind and will do my tests. – user4906240 Feb 25 '19 at 5:38
  • 1
    Just an update. In FME 2019 now you have the option to "preserve global IDs" in sde writer – user4906240 Oct 8 '19 at 5:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.