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.
- 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.
- Click Upgrade .
- A message displays.
- Click Yes.