A few months ago our team presented at the SQLBits XIV conference. The topic was Best Practices for multi-environment database development. The full video can be found on the SQLBits site and is a very informative presentation.
Several questions have been raised on the forum regarding use of composite projects. This post discusses composite projects in general and then describes a technique you can use with Schema Compare for synchronizing composite projects with changes that have been made to the database.