Here is a great article on documenting sql databases using powershell.
This could easily be turned into a full database compare tool which would be ideal for testing database upgrade scripts (or for detecting the need for them).
Documenting Powershell Databases
Developer Rants 