Installing OpManager on Linux with MSSQL database
From version 12.8.330, MSSQL database is supported for Linux setups. As of now MSSQL database cannot be configured directly from the installation wizard for OpManager's Linux installation. Instead, perform a default installation with PgSQL database in Linux environment and then migrate the database to MSSQL.
Note: MSSQL database is not included with the setup for Linux installations.
Steps to migrate to MSSQL DB
After installing, follow the below steps before starting the product, to migrate from PgSQL to MSSQL database in Linux installations.
- Step 1: In terminal, go to <OpManager_Home>/bin directory and execute the DBConfiguration.sh file.
- Step 2: Provide the SQL server details with the DB name.
- Step 3: Leave the Migrate data from existing database option unchecked.
- Step 4: Then, click OK to start migration.
A success message will be displayed in a dialog box after the migration is successful.
Note:
- The DBConfiguration.sh file can be executed either directly from the Linux machine or from X11 enabled environments.
- Executing DBConfiguration.sh from the console mode is currently not supported.
- For BCP utility details, please refer this link.