Upgrade an HDB

The History Database must be upgraded for a new version. The following workflow illustrates the preconditions and different variants for upgrading the History Database.

  • SMC is launched with a Windows account configured on the SQL Server with sysadmin fixed server role. If the required privileges are not available a dialog box appears to provide a Windows account configured on the SQL Server with sysadmin fixed server role.
  • The HDB status is seen as follows:
    Outdated: The database needs to be upgraded.
    Outdated - Resolve conflicts before upgrade: The database needs to be upgraded but before upgrade the HDB owner must be changed to a user other than the HDB user and the HDB service user.
  1. Select the Security expander and check if the displayed user names are as required.
    a. DB owner: Desigo CC SMC user who requires HDB owner rights. You can change it as required. The HDB owner must be different than the HDB user and the HDB service user.
    b. DB user: Desigo CC project user who requires HDB user rights for read and write operations. You can change it as required in System Account Settings. See Settings Expander in SMC System Settings.
    c. DB service user: Desigo CC service user who requires HDB service user rights for maintenance operations. You can change it as required HDB Service Account Settings. See Settings Expander in SMC System Settings.
  • The Upgrade icon is enabled in the SMC toolbar.
  1. Click Upgrade .
  • A message displays.
  1. Click Yes.
  • The HDB is upgraded successfully is stopped by default and is linked to the named SQL Server instance under History Databases in the SMC tree and the HDB status is seen as Current.