sql server - Does SSDT bulid script for only changed objects? -

i'm in process of redesigning our department's source control strategy using team foundation server (tfs) in regard database objects. essentially, store nothing in tfs @ time. have discovered ssdt , enjoy integration within visual studio , think make our transition tfs easier.

so, ssdt have capability of generating scripts based on delta's of ssdt project verses in our server? seems have researched, able generate entire database script.

requirements (mind you, our developers not have ddl access production):

1. i cannot drop database re-create
2. i cannot drop objects stored procs re-create them need
3. tables need altered not dropped , has changed
4. dacpac's out of question
5. our best option based on our environment @ time use scripts updates

our database environment sql server 2008 r2. ssdt version latest 2013 published in june.

yes, if publish project pretty meet of these requirements, though dacpacs built part of process. schema compare , pre/post deploy scripts stored in dacpac , publish reads "should" present against in database. generates change script of necessary changes bring database in line project.

make sure use refactor/rename when renaming objects - cut down on table drop/recreate operations. may want careful "drop objects not in project" options. if haven't been careful making sure objects created in production server in project, accidentally drop important because didn't checked in.

there command lines sqlpackage command can generate change detail reports , scripts can use. scripts need run through sqlcmd or in sqlcmd mode, can produce scripts pretty easily.