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:
Close connections to the QDB.
For more information about the connections to close, see Preparing to Migrate the Repositories.
Create a QDB backup.
For more information about creating a QDB backup, see 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.
Start the upgrade and generate a pre-installation check report.
For more information about generating the report, see Starting an Upgrade and Generating a Pre-Installation Check Report.
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.