Suggestion: Schema Discrepancy Checker

Mar 18, 2011 at 5:41 PM

After realizing today, belatedly, that I also have to remember to go in and delete relationship constraints from the database that I've removed from the schema, I had an idea.

Would it be possible to write an app which compared the schema to a database and indicated which "entities" (constraints, tables, sprocs, etc.) existed in the database but did not exist in the schema?

I would find such a tool very helpful. I could run it periodically and quickly figure out what I need to clean up.