[GIS] How to compare schemas from two File geodatabases

arcgis-10.0esri-geodatabaseschema-architecture

We have template geodatabase, which we send out to our regional Data creators. They update these geodatabases and digitize all the data from their region in the predefined featureclasses.

Now that we have got the File geodatabases, we find that often many of the featureclasses have been modified. Maybe a field might be added or removed. In some cases, the Feature-class itself is deleted or a new one created.

I would like to get a report indicating which feature-classes and tables are changed, as well as the differing Fields in the common tables & featureclasses.

I have already looked at several questions such as:

But the answers given in these Questions have not been helpful.

Best Answer

There is a wonderful Add-in called X-ray for ArcCatalog. It has many features, but the one we ended up using was the 'Analyze Difference' tool from the Tools menu.

It finds for you the difference between a Geodatabase and an XML workspace Document. We just exported the schema of our Template Geodatabase to XML, and compared the different Geodatabases to it.

It hardly takes a couple of seconds to show a nice report with all the feature classes and fields that are missing or different in the two geodatabase.