Our process after green flag is waved is to backup production database.

Then compare Dev DB vs Production DB using a third party tool (SQL Effects Clarity Community Edition in our case).

We also script views, stored procedures, functions, tables, etc to .sql files using sql server management Studio options (Generate Scripts). The scripts go to a SVN repository in folder next to the application code. If it is the case, we separate db scripts from trunk versions and branch versions.

Hope this idea helps.

Regards