Often you are working on an SQL project in a development
environment that involves database changes. How do you ensure the
structural changes (including stored procedures) are replicated to
production?
There are various commercial tools, but I like to use DBDiff or
SQL-DBDiff.