title: Compare SQL Server database schema
body: <p>I am working on project (VS2010 .NET) and have two SQL Server databases, <code>Dev</code> and <code>Prod</code>. </p>
  
  <p>I make all database structure changes in the <code>Dev</code> database and after testing I apply the same changes to the <code>Prod</code> database. </p>
  
  <p>Maybe someone could suggest schema comparison tool which could help me to compare structure and apply changes. </p>