• I like to use Red Gates Sql-Compare to generate a script that will synchronize the test and production databases. I then use the script as a starting point for a script to make the changes to production. This helps me to not miss anything.

    Steve