.NET Blog

Free. Cross-platform. Open source. A developer platform for building all your apps.

database project - .NET Blog

An example of packaging web application containing database upgrade SQL file

August 9, 2010 Aug 9, 2010 08/9/10
Web Development Tools Microsoft
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 ...

Extending the Web Publishing Pipeline to package database project deployed SQL file

March 24, 2010 Mar 24, 2010 03/24/10
Web Development Tools Microsoft
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 ...