• I use AdeptSQL's SQLDiff - it is smokingly fast and very affordable.  (http://www.adeptsql.com)

    I use this tool each time I deploy a new release.  I compare my production databases to my QA server where we have all of the final scripts and adjustments made.  This way I can find out if we didn't deploy something and get it out before we turn the app back on.

    Bill

     

    Ad maiorem Dei gloriam