Scripting Feature Compare Tool for Multiple Layers

Question

Hello,

I have hundreds of layers that I need to do a feature compare on to see if there are any differences between our 9.1 SDE layers and our recently created 10.1 layers from the same source.

I need to confirm that during the porting process from 9.1 to 10.1 that the layers were not changed / distorted, etc. Row counts are the same, etc.

Since I have so many layers I'm looking for a way to script a process that takes in many layers at at time and compares them to the new ones.

I'm not a programmer by nature, so any help would be great!

Thanks

Jennifer

JenniferDick · Answer

okay so here is another example:

SPATIAL_VLT.IHS_PARK_27

Compares to

GIS_FCT.IHS_PARK_27

how would I handle all these one offs in the model?

Christian_Wells · Answer

In this case, the two differences only point to the Schema owner in the database. If the base name "GDM_CO_AREA_83” has not changed, you could control for the schema owner name change.

JenniferDick · Answer

Hi Christian,

I could make up a list of comparable layer names, but here is an example of the differences:

GIS_FCT_.GDM_CO_AREA_83

compares to

GDM_VLT.GDM_CO_AREA_83

in this particular care the 5,6, and 7 characters are different. But not 100% sure at this particular moment without diving into more if this is the case with each comparable layer.