topic Exporting relationship classes to enterprise GDB in Geodatabase Questions

Exporting relationship classes to enterprise GDB

GabrielYarlequé — Mon, 23 Nov 2015 16:35:42 GMT

Good morning,

I am exporting all my local content to an Oracle database, but I am not sure how to export the following feature dataset given that I have some relationship classes. What is the best option to export this content to my enterprise GDB without loosing the relationships?

Thanks for all your help

Re: Exporting relationship classes to enterprise GDB

MichaelMiller2 — Mon, 23 Nov 2015 16:40:29 GMT

I believe if you export the feature classes out as an XML workspace document, the related tables will import with the feature class.

Re: Exporting relationship classes to enterprise GDB

JoshuaBixby — Mon, 23 Nov 2015 23:04:01 GMT

Check out the Copy tool. As the Usage notes cover:

Any data dependent on the input is also copied. For example, copying a feature class or table that is part of a relationship class also copies the relationship class. The same applies to a feature class that has feature-linked annotation, domains, subtypes, and indices—all are copied along with the feature class. Copying geometric networks, network datasets, and topologies also copies the participating feature classes.

Re: Exporting relationship classes to enterprise GDB

GabrielYarlequé — Tue, 24 Nov 2015 13:54:42 GMT

Thank you! I tried using an XML workspace document but at first it didnt work. I didnt notice that some of the fields had special caracteres such as °, %, µg and so on. I changed the fields' name, used XML and this time it work just fine.

Re: Exporting relationship classes to enterprise GDB

GabrielYarlequé — Tue, 24 Nov 2015 13:55:11 GMT

Thank you! I also tried this option after changing the fields' name and it worked as well.

Re: Exporting relationship classes to enterprise GDB

AsrujitSengupta — Tue, 24 Nov 2015 16:24:42 GMT

A manual Copy\Paste will work for this as well.