title: Visual Studio Database Project Rollback Script
body: <p>I'm using the Database project in visual studio 2010 to generate a script to deploy my database (and it's changes). This works great.</p>
  
  <p>Is there a way to have Visual Studio database project generate a rollback script as well as the deployment script.</p>
  
  <p>I'm not looking for rolling back the transaction while deploying; but say I deploy it and my stored procedure has an overlooked performance issue that comes up a week later that requires a rollback to the previous version of the database.</p>
  
  <p>Is there a way to generate the rollback script at build/deploy time that will undo whatever changes the deployment script made.</p>
  
  <p>EDIT: If we ignore that I'm using a database project: What is a good way to have an upgrade and downgrade path for a database generated?<br>
  This generation needs to be part of an automated build process.</p>