Best practices to move a DB from Dev/ Test to Prod

Question

What are the best practises to update/move a Database in Prod with the dev or the test machine copy?

Answer 1

I use RedGate's SQL Compare tool to keep the schema of 2 databases in sync. It's not cheap, but it's worth it if you are constantly pushing changes to production.

http://www.red-gate.com/products/sql-development/sql-compare/