Ok I am stumped, here is what I am trying to do:
We have a database based off another vendors schema, we take that orginial schema and add custom tables, stored procedures, functions, etc. I am trying to build a project to re-sync the core back to the orginial schema, I do not however want to drop any of the custom items we may have added.
I just want to drop any custom indexes we may have placed on the orginial database tables, and then add any new db objects the vendors database now has.
I have played with a foreach loop, looping through the differences and excluding objects which only exists in Production database, but that excludes any custom indexes we may have added.
So basically I just want to compare items that exist in both schema, what am I missing?