title: How can I include my database in the continuous integration process?
body: <p>Please excuse me, today is my first day trying to setup a CI environment using TeamCity. I'm developing an ASP.NET/Sql Server app and so far so good. MSBuild is my provider. </p>
  
  <p>I'd like to know what the options are when it comes to automatically making sure changes to my local database are uploaded to the test server as part of the integration process. Now I'm not too sure I want to go in the direction of DBGhost to automatically sync schema changes, I'd be happy to just replace the database on the test server with a copy of my local database. </p>
  
  <p>What are my options here?</p>
  
  <p>edit: further investigation shows the RedGate SQL products are good for this. They arent cheap though. They have a nice whitepaper on using their products within a continuous integration process: <a href="http://downloads.red-gate.com/HelpPDF/ContinuousIntegrationForDatabasesUsingRedGateSQLTools.pdf" rel="nofollow noreferrer">http://downloads.red-gate.com/HelpPDF/ContinuousIntegrationForDatabasesUsingRedGateSQLTools.pdf</a></p>