title: Transferring changes from a dev DB to a production DB
body: <p>Say I have a website and a database of that website hosted locally on my computer (for development) and another database hosted (for production)...ie first I do the changes on the dev db and then I do the changes to the prod DB.</p>
  
  <p><strong>What is the best way to transfer the changes that I did on the local database to the hosted database?</strong> </p>
  
  <p><em>If it matters, I am using MS Sql Server (2008)</em></p>