title: How to re-deploy, re-create database on each test run
body: <p>Currently I'm using Visual Studio 2012 RC and SQL Server 2012 RTM.</p>
  
  <p>I'd like to know how to re-deploy/re-create a test database for each test run.</p>
  
  <p>Keep in mind I've a SQL Server database project for the database using Visual Studio 2012's template.</p>
  
  <p>Actually I'm not very sure about an idea I got in my mind, but <strong>.testsettings</strong> file has <strong>Setup and cleanup scripts</strong>. Is this the way to go? For example, a PowerShell script reading the database project generated script and executing it against the database?</p>
  
  <p>I guess there're better ways of doing that and it should be an out-of-the-box solution but I ignore it and <em>Google</em> doesn't help me in finding the right solution.</p>