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) ...
Go to the complete details ...