Compare User Objects Enhancement Request

jlcox

Member³
It would be nice to have a little more granularity when comparing user objects across databases. When I'm comparing tables, I often want to know if columns have been added or datatypes modified. Because I'm comparing from a development environment to a production environment, constraints may have been disabled in the test environment because of incomplete test data and the like, or indexes might have different names. When I do a comparison of the tables, I have to go through the differences script and manually remove most of it, hoping that I don't miss something. It would be nice if I could choose what I want to compare...column names, constraints, indexes, etc, so that I could skip over the ones that I don't want to see.
 
Back
Top