title: How can I update my SQL Server database schema?
body: <p>Usually throughout development of a project I will deploy frequently, just to make sure I wont have any problems in production.</p>
  <p>Also, throughout development, I find myself changing the database's schema.</p>
  <p>How can I easily update the database in production?</p>
  <p>I have been dropping the old database and reattaching the new one. Is there a faster way to update the deployment database?</p>
  <p>Thanks</p>
  <h3>EDIT</h3>
  <p>What are some free tools for this?</p>