1.5 Understanding Upgrade Prerequisites

This section describes prerequisites your existing AppManager components must meet before you upgrade them.

1.5.1 Understanding Microsoft SQL Server Versions Supported for Upgrade and Migration

Version 9.2 QDBs and CCDBs must be hosted on one of the following versions of Microsoft SQL Server:

  • Microsoft SQL Server 2016 Standard or Enterprise edition

  • Microsoft SQL Server 2014 Standard or Enterprise edition

  • Microsoft SQL Server 2012 Standard or Enterprise edition (32-bit or 64-bit)

  • Microsoft SQL Server 2008 R2 Standard or Enterprise edition (32-bit or 64-bit)

  • Microsoft SQL Server 2008 Standard or Enterprise edition Service Pack 1 or later (32-bit or 64-bit)

AppManager 9.2 supports migrating version 9.1 QDBs and CCDBs hosted on SQL Server 2008 R2 or later to SQL Server 2016. For more information about upgrading a QDB, see Section 2.0, Upgrading Management Site Components. For more information about upgrading a CCDB, see Section 4.0, Upgrading Control Center Components. For more information about migrating an upgraded repository, see Section A.0, Migrating Version 9.1 Repositories.

1.5.2 Understanding AppManager Versions Supported for Upgrade

Before you upgrade AppManager components, ensure that the components meet version prerequisites. The following table lists the components and the AppManager versions supported for upgrade.

Component

Supported AppManager Versions for Upgrade

QDB

9.1

Management server

Agent

  • 7.0.4

  • 8.0.3

  • 8.2

  • 9.1

CCDB

9.1

Command queue service (CQS)

Deployment Service

Deployment Web Service

Control Center console

Operator Console

For more information about obtaining a supported version, contact Technical Support.

If you have a report agent, before you upgrade, you can run the CompVersion report Knowledge Script to generate a report detailing the version number of AppManager components installed on all computers in an AppManager site. For more information about running the Knowledge Script, see the AppManager Knowledge Script Reference Guide, available on the AppManager Documentation page.

If you do not have a report agent, use the methods described in the following table to obtain component version information.

Component

Steps to take

Operator Console

  1. Start the Operator Console.

  2. Select Help > About AppManager Operator Console.

QDB

  1. In the Operator Console, select Extensions > Repository Browser.

  2. From the Tables list, select Version.

  3. Run the following query:

    SELECT * FROM Version

  4. Scroll through the results until you find the following record:

    MachineName: computer name
Component: Repository
Version: current QDB version

Management server

  1. In the Operator Console, right-click the server.

  2. Select Troubleshooter > Management Service Info > Connectivity.

Agent

  1. In the Operator Console, right-click the computer whose agent you want to check.

  2. Select Troubleshooter > Client Resource Monitor Info > Connectivity.

Control Center components

Use the Registry Editor to view the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\NetIQ\AppManager \Control Center\1.0