Export a Package through IIS Manager

by Faith A

This quick guide will help you create a package of your Web application using the IIS Manager, including a SQL database.

Prerequisites

This guide requires the following prerequisites:

  • .NET Framework 2.0 SP1 or greater
  • Web Deployment Tool
  • IIS 7.0 or above, or IIS Remote Manager

Prerequisites if you're using SQL

Note: The second and third pre-requisites will be installed automatically if you install the Web Deployment Tool using the Web Platform Installer

  • SQL Server Express or Standard, either local or remote
  • SQL Server 2008 Management Objects (SMO) - x86 or x64
  • SQL CLR Types - x86 or x64

Note: If you have not already installed the Web Deployment Tool, see Installing the Web Deployment Tool.

Export a Package

  1. Always make a backup. Run the following command to backup an IIS 7.0 or above server:

    %windir%\system32\inetsrv\appcmd add backup "PreMsDeploy"
    
  2. Open the IIS Manager by clicking Start > Run and typing inetmgr.

  3. In IIS Manager, expand the Server node and the Sites node, then select the Default Web Site/MyApplication.

  4. In the right-hand Actions pane under Manage Packages, click the Export Application... link to launch the wizard.
    Screenshot of the My Application Home screen's Actions pane with a focus on the Export Application option.

  5. By default, the package will contain the site or application you have selected (in this case the Default Web Site/MyApplication) and its content folders. Click on the Manage Components button.
    Screenshot of the Export Application Package dialog with a focus on the Manage Components option.

  6. The first row is your iisapp provider entry, which is your application. In the second row, choose the dbFullSql provider from the Provider Name drop-down. If you hover over a provider, you will see a description and example path.
    Screenshot of the Provider Name field with a focus on the D B Full S Q L option.

  7. Enter the path to your database or script file in the Path column.
    (Example: "Data Source=.\SQLExpress;Database=MyApplicationDb;User id=MyAppUser;Password=SomePassWord;" without the quotes.)
    Screenshot of the Manage Components screen with the path to a database in the Path column.

  8. You'll notice that the database now shows up in the package contents tree view. Click Next to continue the wizard.
    Screenshot of the Export Application Package dialog box with a focus on the Next option.

  9. Next you will see parameters that are generated based on the two providers that you added in the previous step. We're going to give them friendlier names and descriptions. Select the second parameter in the list, Parameter 2, and click on the Add Parameter Entry button.
    Screenshot of the Export Application Package dialog box with a focus on the Add Parameter Entry option.

  10. We're going to create a parameter entry that points to the connection string inside the application's Web.config file. You'll notice that the parameter entry has 3 fields to fill out.
    Screenshot of the Add Parameter Entry dialog box with no Type selected.

  11. Choose the type of parameter you want. In this case, we'll choose XmlFile because we want to point to the Web.config file.
    Screenshot of the Add Parameter Entry dialog box with the X M L File Type selected.

  12. Enter the scope for the parameter entry. The scope is a regular expression that tells us what file to locate in the package. In this case, we'll choose the Web.config file but we'll add \ to indicate the start of the file and $ to indicate the end of the file name so that Web.config.bak wouldn't also be updated.
    Screenshot of the Add Parameter Entry dialog box with the web dot config dollar sign entry in the Scope field.

  13. Then we'll add a match. For an XmlFile parameter entry, the match is an xpath query that indicates a particular element or attribute in the XML file. We'll add an xpath pointing to the connection string attribute. Click OK to accept the entry.
    Screenshot of the Add Parameter Entry with a connection string entered in the Match field.

  14. You now have parameters that will allow a user installing this package to set the application path (site and app name where they want this app to be installed) and change the connection string (which will be updated in 2 places, first when running the SQL script and second inside the Web.config file). Click Next to continue.
    Screenshot of the Export Application Package dialog with a focus on the Next option.

  15. Finally, choose a location to save your package. For this example, we chose C:\MyApplication.zip.
    Screenshot of the Save Package dialog box showing the Package path.

  16. The wizard will now complete the packaging process and save the package to disk. When it is complete, you will see a Summary page that gives you an overview of what actions were performed.
    Screenshot of the Export Progress and Summary screen's Summary tab.

Summary

Congratulations! You have now created a package based on the Default Web Site. It contains the application, which contains content files and an entry that will mark the folder as an application in IIS, and a SQL database.