title: How can I set my deployment options to script the incremental release of a Visual Studio 2010 database project?
body: <p>I've just started using a VS2010 database project to manage the release of an update to an existing database.</p>
  
  <p>I want the deployment option to generate a script that will contain the commands to change my existing database rather than create an entirely new one.</p>
  
  <p>E.g I have 10 existing tables - one of which I drop in the new version and I create some new sprocs. I only want the deploy to script the Drop table and Create Procedure commands.</p>
  
  <p>I am using VS2010 Premium.</p>
  
  <p>Is there a recommended standard approach I could follow to managing DBs in a project from initial creation to incremental releases?</p>
  
  <p>Thanks!</p>