Vishal Joshi's Tangent: Web 1-Click Publish with VS 2010

Today my goal is to go through an end to end walkthrough of the Web 1-Click Publish feature of VS 2010… This walkthrough will cover following : Prepping up an ASP.NET 4.0 web application which is using a SQL Server Database for deployment, Gathering the remote web and database server information, Setting up Web.config Transformation to change your connectionString, Including SQL Server Databases in Web Deployment, Creating a 1-Click Publish Profile to Publish your web content, databases and transformed web.config files, 1-Click Publish your Web Application.