Click here to Skip to main content
13,795,364 members
Click here to Skip to main content
Add your own
alternative version


12 bookmarked
Posted 6 Nov 2009
Licenced CPOL

VS2010 1-Click Publishing

, 6 Nov 2009
Rate this:
Please Sign up or sign in to vote.
Shows the new 1-Click deployment feature of VS2010.


Web application deployment has always been a tricky task for developers. Developers used to have many ways to perform deployment, ranging from X-Copy, to FTP, to using installers. However, all deployment options have common problems; these are:

  • The solution has to be separately packaged. The database is just another package.
  • After generating the packages, these should go "somehow" to the destination server and the deployment will happen on that server.
  • On the destination server, IIS deployment for the web app and database deployment are two different tasks.
  • On the destination server, configuration files have to be edited to reflect on the new environment such as database connection strings.

These problems have just surfaced the difficulties usually associated with deploying large APS.NET applications.

Well, in VS 2010 (currently in beta2), there is a huge feature: 1-Click Deployment (or publishing). It basically allows the developer to deploy an application along with the database and configuration changes directly from his development box to the destination server with one click!

The technology behind 1-Click Deployment is MSDeploy. VS2010 uses MSDeploy implicitly to implement the deployment.

In the source server (development box), VS2010 uses MSDeploy to create a zipped package of your project (containing the web app, database with data, and deployment configurations). This package is then sent to the destination server which will have MSDeploy configured to listen to deployment requests and will perform the actual deployment of your web app and your database! Note that MSDeploy is installed with VS2010, by default.

In this article, I will show you two walkthroughs on how this is implemented, during which I will try to highlight how stuff is happening...

Deploying on a Hosting Company

When deploying web apps, you usually have two options; you either deploy on a web hosting company or on a server which you own. First, let's discuss option 1.

ORCSWeb ( allows you to create free testing accounts to deploy VS2010 Beta 2 web projects. I have created an account, and during the registration process, I have selected SQL Server 2008 as my database; because, then they will allow you to deploy your app along with the database...

After completing registration, I received an email containing the information I need to deploy. Let's review the information:

The information that you will need to enter 
    into the Visual Studio "Publish Web" wizard is:
Publish Method: MSDeploy
Publish Service URL:
Site/Application: ITD1.orcsweb (you can optionally append a subfolder name)
Allow Untrusted Certificate needs to be checked.
User Name: itd1
Password: xxxxxx
You can view your site here:
Additionally, you can deploy a database by going to the properties 
   of the project and then the Deploy-SQL tab.
Your database connection string is: Password=xxxxx;User ID=ITD1.orcsweb; 
  Initial Catalog=ITD1.orcsweb;Data

The new thing to you might be the "Service URL". This is the IIS handler which will perform the actual deployment of the application on the hosting server. See in the destination server assigned to me by ORCSWeb, MSDeploy is running and configured to listen to requests on the specified handler to perform the actual deployment. This detail is hidden from you in this case, and is done by the destination server admin (ORCSWeb, in this case). In the next walkthrough, I will show you how to set up your own destination server to listen to requests from VS2010.

MSDeploy also comes with a SQL handler to perform database deployment. This will also be called implicitly on the destination server.

Going back to the information, I have been supplied by a username/password combination to submit while deploying, and with a SQL connection string for my database deployment.

Now, let's see the web app I want to deploy. In VS2010, I have created the simplest of applications: I used the default web app template and added a second page which reads a list of "Departments" from a SQL Server 2008 table. The below screenshots show my simple app:



Now it is time to deploy! Let's review the three problems that I want to solve for deployment:

  1. I actually want to deploy the application without manual packaging and without leaving my dev box.
  2. I want to deploy the database along with my app in a single click!
  3. I do not want to go to the destination server and change any configuration (like the database connection string).

To solve the configuration issue, VS2010 introduces XML Document Transforms (XDT) for automatic configuration changes. You can learn about the complete syntax of XDT from various online resources; however, for the sake of our discussion, what you need to know is that VS2010 allows you to create multiple versions of your web.config and associate each one with a configuration build (for example, your application will have the normal web.config file, but it will also have web.config.debug and web.config.release for each of the debug and release configuration builds... you can have more builds as you like; for example, web.config.staging...).

Now, let's say that you are deploying your release version; XDT allows you to set a certain syntax in these config files such as while VS2010 is performing the packaging of your project; the entries you specify in web.config.release replace the entries in web.config and a new final web.config file is created containing the updated configuration. So, for example, your web.config will hold the connection string for your local database. In web.config.release, you specify the connection string for the production database, and through XDT, you instruct VS2010 to dynamically replace the connection string in the web.config file with the connection string in web.config.release when generating the production version of web.config which will be in the final package...

OK, XDT wanted some explanation, so now let's start the actual packaging and deployment.

If you expand the web.config node, you will find that, by default, there will be web.config.debug and web.config.release. As explained, these correspond to the default build configurations (Debug and Release). In our case, we are going to be deploying the release version, so go ahead and edit the web.config.release file to read as follows:


Here, we are using XDT (xdt:Transform="Replace") to instruct VS2010 to replace the development-time connection string available in web.config with the release (or production) time connection string available in web.config.release. This is the connection string supplied by the hosting company. The web.config file in the final package will contain the updated connection string.

Now, let's set up VS to deploy our SQL database also... this solves the concern of deploying the database along with the application in a single click. Open the Properties window of the project. You will find a new tab called Deploy SQL. In this tab, set up the connection string of the development database which you want to deploy (you can make VS2010 import this from the web.config file by clicking "Import from Web.config") and then provide the destination URL where the database will be deployed. This will be the connection string provided to you by the hosting company. Instruct VS2010 to include data while deploying, and make it get schema and data... the screenshot below shows the configuration I used to deploy my application:


OK, now you are ready to do the actual deployment. First, make sure that the "Release" build configuration for your project is selected as shown below.


Now, right-click the project node and select the new "Publish..." option. A new window will open, where you will enter the publish settings:


  • Publish Profile: You are allowed to create a profile for your settings so that you are not required to type them again and again for each deployment. For example, I have created two profiles: one to deploy to the hosting company - which I am using now, and another one to deploy to another server, which I will show you next.
  • Publish Method: Select MSDeploy Publish to perform the publishing based on MSDeploy.
  • Service URL: Recall that this is the URL provided to us by the hosting company which contains the IIS handler.
  • Site/Application: The name of the IIS website to deploy to - also provided by the hosting company. And the name of the application (virtual directory) under which to deploy.
  • Allow Untrusted Certificate: Select this since we are deploying on a demo server and the certificate won't probably be from a trusted CA (like VeriSign).
  • Username/password: The account provided by the hosting company which will have permission to call MSDeploy and perform the deployment.

OK, now we are ready. Click Publish, and your web app and the database (with the data) will be deployed to the hosting company.

Behind the scenes, VS2010 (and MSDeploy) created a packaged zip file of your application along with a manifest XML file, and used these two files to publish your application to the destination server. The package file can be found, by default, on "obj\Release\Package\"; although you can change this in the "Package/Publish" tab of the Properties window of your project.

Actually, if by the time you are reading this article the testing account is still valid and the application is still deployed, then you can check the application on the following URL:

Deploying on Another Server

Let's now discuss the case when you own your production server and want to deploy on it. In this case, the settings on the development box will almost be the same. However, now you have the responsibility of configuring MSDeploy on the production server to listen for deployment requests.

In my case, I will deploy the same application I showed you on the same machine on IIS 7 on WinServer 2008. So the first and most important mission I have is to configure MSDeploy on my machine (acting as server) to listen for deployment requests.

First, make sure IIS 7 is installed on the server.

Now, download the MSDeploy package. You can get it from here: Microsoft.

Run this package on the server and install the following components:


The above components install MSDeploy along with its management UI and the IIS 7 handler for managing deployment requests. The management service will be the actual service listening for requests. The Remote Agent Service is another MSDeploy option used mainly for command-prompt deployment but is not required for VS2010 1-Click Publishing.

Make sure that the services "Web Deployment Agent Service" and "Web Management Service" are started and have a Startup type of "Automatic". The final step is to enable remote connections for IIS (intermgr.exe --> Management Service --> Enable Remote Connections).

Now you have the server ready to handle VS2010 publish requests.

Back to our project in VS2010. Edit web.config.release to have the connection string of the server instead of the hosting company (in my case, since it is the same server, I will have the same connection string as the one in the web.config file). Now on the Deploy SQL tab, edit the connection string to point to the production server (again the same server for me...) and select to move data and schema. Now you are ready to publish, select the "Publish..." tab, and enter the settings below:


Notice that I have created a second profile for publishing. The settings are similar to the ones I used for the hosting company's profile; just note that in the service URL, I just supplied the name of the server to deploy to. This is the server I have configured the MSDeploy service on; in this case, my dev machine...


With all the great features coming in VS2010 and .NET 4.0, 1-Click Publishing is one of the most important in my opinion. The ease of use and simplicity really stands out. The fact that you now can deploy your database and your configuration changes along with your application in one zipped file is great! Add to this that you can do this without even leaving your development machine is really cool...


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

You may also be interested in...

Comments and Discussions

QuestionUnclear connection string instructions Pin
Member 982163610-Jul-15 8:07
memberMember 982163610-Jul-15 8:07 
GeneralUsefull Pin
AWdrius9-Nov-09 5:55
memberAWdrius9-Nov-09 5:55 
Nice overview. Thanks for interesting reading.

Trust is a weakness.

GeneralRe: Usefull Pin
mohamad halabi9-Nov-09 17:47
membermohamad halabi9-Nov-09 17:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web04 | 2.8.181207.3 | Last Updated 6 Nov 2009
Article Copyright 2009 by mohamad halabi
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid