Deploying to an existing database from VS 2010 on TFS I am trying to find a way in VS2010 to add a few objects to an existing database without scripting out all of the existing objects. This is a maintenance project that is adding a table, altering an existing table by adding a column, creating a foreign key constraint between them and altering a stored proc to use a new column in the existing table rather than a hard coded case statement. I tried a database project and then converted it to SSDT in an attempt to find a way to not drop the database.

The scripts generated from this database project generate drop and create statements for the database. If I manually remove the database portion of the scripts, the result is exactly what I need.  Is there a way to force the project to NOT drop and recreate the database, or is there a project type I can use instead?
For SSDT, when you choose Publish to generate a script the advanced options include "Always re-create database". Untick that and you're good to go.



Same option applies if you do a local debug build.



Similar options buried in the old VS2010 Database Project options somewhere.

To be honest, from the description of what you're doing SSDT and/or VS2010 database projects are overkill. Scribble a script in SSMS and be done with it.