title: How do you Move Dev Database Changes to Production Database?
body: <p>I have been working on a project and gotten it through the first stage. However, the requirments ended up changing and I have to add new tables and redo some of the foriegn key references in the DB.</p>
  
  <p>The problem I have is my lack of knowledge of dealing with doing this kind of change to a staging then production database once I get the development done on dev database.</p>
  
  <p>What are some strategies for migrating database schema changes and maintaining data in the database?</p>
  
  <p>About as far as my knowledge is on doing this is open up Sql Server Management Studio and starting adding tables manually. I know this is probably a bad way to do it so looking for how to do it properly while realizing I probably started out wrong.</p>