Having had a less than happy time with the Database Project in Visual Studio 2010 I can report that I have found a workable alternative.
- Create Database (DEV version) (However you like)
- Use Sql Server Management Studio to generate an initial build script
- Create a second (Reference version) copy
make changes in the DEV version
- Use Visual Studio’s schema compare with most of the non schema comparisons turned off to compare with the Reference DB
- Generate a change script, save it with a name including the version number
- Use SSMS to generate a creation script and save that over the original
- Commit to version control
So from then on you can either upgrade a prod database or create one from scratch. Not as nice a the Redgate tools but much cheaper…