An example of packaging web application containing database upgrade SQL file
A few months ago, we have a blog talking about extending the web publishing pipeline to package database project deployed SQL file. In this blog, I’ll show step by step example of packaging web application with SQL Server database upgrade SQL file using Visual Studio 2010. This way, we can generate a web package with incremental SQL script to certain database version. The scenario may help distributions of a web upgrade package which needs to be installed on many different locations, each with their own SQL server database. 1. Create a Web Application Project 2. Add a new “SQL Server 2008 Database Project” to the solution 3. Prepare a development database, such as my test1 database as the following: 4. Right click our
Read More...
Read the complete post at http://blogs.msdn.com/b/webdevtools/archive/2010/08/09/an-example-of-packaging-web-application-containing-database-upgrade-sql-file.aspx