Database Schema Comparison Utility
Thanks to Sean Goodpasture for this nifty application, something commercial applications have solved but with an hefty price.
When most developers develop database code (including tables, views, stored procs and functions, they tend to develop in a development environment and then migrate those changes later to other servers (staging, production, whatever). While some of us are good about keeping track of those changes, the majority of us are not.
Red-Gate Software offers a tool, Sql Compare to compare the schema of two databases and show them to the user. This tool is not inexpensive, but it works very well.
This article provides the basic functionality used to do the same thing as SQL Compare, at a fraction of the price.