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...
This post is next in the series of VS 2010 articles that we have been putting together to dive into the Web Deployment improvements with VS 2010 and IIS. I would recommend reading the the preceding posts to get an overview of all the scenarios supported: Web Deployment with VS 2010 and IIS Web Packaging: Creating a Web Package using VS 2010 In this post I will cover web package creation using MSBuild command line. Many medium to large sized teams plan on automating their build process for various good reasons like predictability for QA team, time saving as compared to on-demand manual build, early bug detection with Build Verification Tests (BVTs), knowing the current state of project integration, etc… Many argue that setting up...