Upgrade an NDB

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

  • 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 NDB status is seen as follows:
    Outdated: The database needs to be upgraded.
    NOTE: In case of Outdated database, you need to explicitly upgrade the NDB. This will add the NDB under the Database infrastructure tree and link to the upgraded project.
  1. Select the Security expander and check if the displayed user names are as required.
    a. DB owner: You can change it as required. The NDB owner must be different than the NDB user and the NDB service user.
    b. DB user: Project user who requires NDB user rights for read and write operations.
    c. DB service user: Service user who requires NDB service user rights for maintenance operations.
    NOTE: For more information on the security expander, refer to the Security Expander section in the Notification Database Configuration in SMC topic.
  • The Upgrade icon is enabled in the SMC toolbar.
  1. Click Upgrade .
  • A message displays.
  1. Click Yes.