Product Documentation

Upgrade system databases

Jun 05, 2015
Updated: 2014-08-29
Before upgrading the system databases, perform the following tasks:
  • Ensure you have installed and configured the Encryption Service on a server in your deployment
  • Ensure you have backed up all databases in your Services Manager deployment: OLM, OLMReports, and OLMReporting
    Important: The upgrade process makes irreversible changes to these databases. Creating backups ensures you can recover and restart the upgrade process in the event of a failure.

This topic provides instructions for upgrading the system databases in CloudPortal Services Manager 11.0.1 to system databases compatible with Services Manager 11.5.

You can perform this upgrade on the database server for the primary location or on a server that can connect to the database server. When you perform the upgrade, the Configuration Tool imports the key from the Encryption Service and then deploys a set of SQL scripts that are included on the Services Manager installation media. These scripts prepare the system databases for upgrading the other Services Manager components.

To upgrade the system databases using the graphical interface

  1. From the installation media, double-click setup.exe and click Get Started.
  2. On the Select Deployment Task page, select Upgrade Existing Deployment.
  3. On the Upgrade Existing Deployment page, select Upgrade System Databases and then click Install.
  4. When prompted, accept the End User Licensing Agreement and then click Next.
  5. Click Install. The Setup Tool installs the Configuration Tool and displays progress.
  6. Click Finish to continue with the upgrade process.
  7. On the Specify Primary Database Settings page, perform the following actions and then click Next:
    1. Enter the following database details for the primary location:
      • In Server address, specify the database server for the primary location using the DNS alias, IP address, or FQDN.
      • In Server Port, select Use specific port and enter the port number used by the SQL Server. The port for the default instance of SQL Server is 1433.
      • In Authentication Mode, select whether to use Integrated (Windows) or SQL authentication. By default, Integrated is selected.
      • In Connect as, specify the username and password of the SQL administrator user. These fields are available when select the SQL authentication mode.
    2. Click Test Connection to ensure the Configuration Tool can contact the SQL Server.
  8. On the Confirm Databases Are Backed Up page, select This step has been completed and then click Next.
  9. On the Summary page, review the database configuration information. If you want to change anything, click Back to return to the appropriate configuration page.
  10. Click Commit. The Configuration Tool imports the Encryption Service's key, launches the database upgrade scripts and displays the upgrade progress.
  11. When the upgrade is completed, click Finish. The Configuration Tool returns you to the Upgrade Existing Deployment page.

To upgrade the system databases using the command line

Open the Command Prompt window and enter the following command:
CortexConfigConsole.exe /Upgrade:Databases  

The Configuration Tool launches the upgrade database scripts that perform the upgrade. When the upgrade is completed, the command prompt is returned.

After upgrading the system databases, continue the upgrade process by upgrading Services Manager platform server roles. For more information, refer to the topic Upgrade platform server roles using the graphical interface or command line.