We are starting to use database projects within our orginization, we created baseline dbschema files from our production environment to create a base version. We now are using a custom tool based on vsdbcmd.exe to create static scripts to alter our databases in Devint and QA and eventually production. These releases are iterative, and once a schema change is made in say build 1 we would like for the script generated in Build B to validate if the change has occured before attempting to execute the alter command again. This is really only important for scheam type changes, column, Constraints, Forgein Key or Index additions. We've started a Custom Deployment Plan Modifier Extension to do this (dbprojtools.codeplex.com) But it's far from perfect, an option built-in to Visual Studio would be best.
Discussion started at: