4.8 Upgrading the CCDB

This section describes the steps required to upgrade a CCDB.

You can upgrade CCDBs on remote SQL Servers. You do not have to run the setup program on the SQL Server.

On a SQL Server or instance hosting multiple CCDBs, you must upgrade each CCDB to version 9.x. If you have a version 8.x CCDB on the same SQL Server or instance as a version 9.x CCDB, the Control Center console for the version 8.x CCDB might reflect the version 9.x command queue service in the status pane.

To upgrade the CCDB:

  1. Close connections to the CCDB.

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

  2. Create a CCDB backup.

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

  3. Ensure that your primary QDB meets requirements.

    For more information about QDB requirements, see Section 4.2, Understanding QDB Requirements.

  4. Ensure that any existing components you plan to maintain in your version 9.x Control Center environment meet requirements.

    For more information about maintaining existing components, see Section 1.4.2, Upgrading Components in a Multiple-QDB, Control Center Environment.

  5. Ensure that there are no commands in the Control Center queue.

  6. 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.

  7. 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 CCDB you are upgrading. To specify a SQL Server instance, use the format server_name\instance.

    • Name of the CCDB 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 CCDB data for upgrade.