Skip to main content
Question

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

  • June 23, 2022
  • 2 replies
  • 393 views

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

2 replies

Forum|alt.badge.img+2
  • 1891 replies
  • July 4, 2022

@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


  • Author
  • 1 reply
  • July 6, 2022

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 ..