Question

How to compare two database schema (File GDB & SDE) including subtype & domains values.


How to compare two database schema (File GDB & SDE) including subtype & domains values.

2 replies

Badge +2

@hakkeem85​ You can compare the basic schemas using the FeatureReader - one for the File GDB and another for the SDE and check the <Schema> port. This will have a list attribute (attribute{}) with the schema of all the feature types.

For subtypes and domains, you'll have to export the Esri XML Workspace Document (Schema only) and then you can use a workspace to read that and interpret the XML. There is an example here

Thank you @Mark Stoakes​ it's worked. I have used Feature reader to compare feature class, field name & field type. Used python creator & SQL executer to get domain values ..

Reply