A Visual Studio solution file may contain both database project and a web application project. When deploying (not building) the database project, it can generate a .sql file containing the full sql file or an incremental upgrade file against a database. This blogs walkthrough one way to package database project generated sql file into the web application project's package. This solution works for team build scenario as well. 1. Create a Web Application Project 2. Add 2 new "SQL Server 2008 Database Project" to the solution 3. In each of the database project, add a sample table and make sure build and deploy are successful. Check the deployed SQL directory %database project dir%\sql\%configuration%\ making sure...(read more)
Go to the complete details ...