2.7 Upgrading the QDB

This section describes the steps required to upgrade a QDB. You can upgrade QDBs on remote SQL Servers. You do not have to run the setup program on the SQL Server.

To upgrade the QDB:

  1. Close connections to the QDB.

    For more information about the connections to close, see Section A.2, Preparing to Migrate the Repositories.

  2. Create a QDB backup.

    For more information about creating a QDB backup, see Section A.2.1, Creating Backup Copies of the Repositories. Since you are not migrating the QDB to a different computer, it is not necessary to copy the backup files to a different location.

  3. Start the upgrade and generate a pre-installation check report.

    For more information about generating the report, see Section 1.10, Starting an Upgrade and Generating a Pre-Installation Check Report.

  4. When you reach the Target SQL Server and Repository Name window, provide the following information and click Next:

    • Name of the SQL Server and, if applicable, instance that hosts the QDB you are upgrading. To specify a SQL Server instance, use the format Server_Name\instance.

    • Name of the QDB you are upgrading.

    • Account that can log in to the SQL Server for the upgrade. Ensure that the account is a member of the sysadmin SQL Server role.

    The setup program prepares the existing QDB data for upgrade and checks in current Knowledge Scripts.

After you upgrade a QDB, for the QDB to function correctly, you must also install the Task Scheduler service and add the QDB to the service. For more information about installing and configuring the Task Scheduler service, see Understanding Task Scheduler Service Installation in the Installation Guide for AppManager.