VS2010 Beta1 Web Application Project Database package and SMO options
In Visual Studio 2010 Beta1 release, SQL server database schema and data can be packaged for deployment along with the website. It utilizes Msdeploy SQL Database provider functionality in IIS team’s msdeploy release. In Visual studio 2010 Beta1, user can set the database package options in web application project’s Deploy-SQL property page as following. User can add a package connection by clicking “Add” button and make sure it’s checked. To select the source database for package, one can check “Pull data from an existing database” check box, and select or enter the database connection string. In Beta1, only three packaging choices are provided for the database, “Schema only”, “Complete database” and “Exclude objects
Read More...
Read the complete post at http://blogs.msdn.com/webdevtools/archive/2009/06/28/vs2010-beta1-web-application-project-database-package-and-smo-options.aspx