In this section, you will upgrade the Performance Warehouse Database (PWDB40).

Tasks

  1. Upgrade the PWDB40 Database
  2. Upgrade the PWDB40 SSIS Package

Upgrade the PWDB40 Database

Procedure UG.35: To upgrade the PWDB40 database

  1. On MOMSQL01, uninstall the old version of PWDB40DBSetup.msi package (PWDB40 Database File Build 4.0.460.0).

  2. Install the new version by running Pwdb40DBsetup.msi in the Monitoring and Reporting folder on the solution distribution media.

  3. Open a command prompt and change directory to C:\Program Files\Microsoft Hosting\Reporting\PWDB40 Package.

  4. At the command prompt, enter PWDB40Scripts.exe to run the executable.

  5. At the prompt “Database PWDB40 already exists. Do you want to recreate it(Y/N)”, type N. The PWDB40 database will be upgraded.

Upgrade the PWDB40 SSIS Package

Procedure UG.36: To upgrade the PWDB40 SSIS database

  1. On MOMSQL01, uninstall old version of PWDB40 SSIS package (SSISSetup Build 4.0.460.0).

  2. In the Monitoring and Reporting folder on the solution distribution media, run Pwdb40ssis.msi to install the files for the PWDB40 SSIS.

  3. Navigate to the C:\Program Files\Microsoft Hosting\Reporting\SSIS Package folder, and then run SSISFORPWDB40.SSISDeploymentManifest.

  4. Follow the wizard to start the installation. Select SQL Server deployment for SSIS package. Accept defaults for target SQL server and installation folder. Modify the package parameters to match where you have the PlanManager and PWDB databases installed. For the reference architecture this would be:

    Property

    Value

    \Package.Connections[ProvisionSourceDbDataConnection].Properties[ServerName]

    MPSSQLVS01

    \Package.Connections[ProvisionWarehouseDbDataConnection].Properties[ServerName]

    localhost
Note:
The job does not need to be updated. It will use the updated package.