I am working on project (VS2010 .NET) and have two SQL Server databases, Dev and Prod.
I make all database structure changes in the Dev database and after testing I apply the same changes to the Prod database.
Maybe someone could suggest schema comparison tool which could help me to compare structure and apply changes.
RedGate makes excellent tools for the purpose.