title: Track changes made to a database
body: <p>Background: </p>
  
  <p>I have a MS SQL Server database and I want to track changes to it. For example if a column needed to be added or removed or a table needed to be dropped. Something similar to Version control for regular code.</p>
  
  <p>The problem: </p>
  
  <p>While looking around I saw that there were some tools that can be used:</p>
  
  <ul>
  <li>RedGate SQL Source Control</li>
  <li>Visual Studio Database project</li>
  </ul>
  
  <p>I am more interested in knowing if either of these tools will track changes to my database? More specifically I have a TFS server that is the source control for my MVC code, can I use either of these with TFS? Will it allow us to restore from older versions? Will it allow multiple developers to work on the database simultaneously?</p>