• +1 for Redgate.

    I spent a day writing an update script, RGT did a better job in 4 minutes (I had forgotten to refresh a view after the table meta data had changed)

    You can download it and evaluate for 2 weeks. If you are nice to your account manager, they will give you a number of extensions to this if you are struggling to get buy-in from management. (but don't thell them I said that).

    Redgate are also the guys who support Steve Jones and the team behind SQL Server Central and provide such a valuable community so I am happy to support them and use their products (the fact that the products themselves are very good is a bonus)

    The RGT also comes with a management studio plugin for SVN so that you can check code in and out directly from MSSM