Database Deployment with the VS 2010 Package/Publish Database Tool

Database deployment hasn't ever been considered the fun part of a developer's job, and automating it to be made easier often takes lots of manual setup. Earlier versions of Visual Studio didn't have much in the way of deployment built in or easily accessible. Web Deployment Projects, which are a separate download, have no database deployment options (ASP.NET project assets only). Visual Studio 2010 has incorporated into the IDE a very rich set of web and database deployment configuration settings & tools to make things as easy and automated as possible for developers during the deployment process.

http://rachelappel.com/deployment/database-deployment-with-the-vs-2010-package-publish-database-tool/