Create and Configure a Database for Workspace Services

To create a database for Workspace Services, follow these steps:

Create a database for mfconsoledb with a custom name along with prefix and suffix. Prefix and suffix are optional. For example, database name is <prefix>mfconsoledb<suffix>.

Note: For Oracle databases, a schema name should be in capital letters.

Note: For Oracle, create necessary tablespaces and Users before proceeding. Refer to Prerequisites for Volt MX Foundry with Oracle.
- The following is a sample query for creating a database in SQL Server:

CREATE DATABASE mfconsoledb;

The following is a sample query for creating a database in MySQL:

CREATE DATABASE \`<DBNAME>\` DEFAULT CHARACTER SET utf8 COLLATE utf8\_unicode\_ci;

For Foundry version V9.2.2.0 or greater:

To create mfconsoledb:

The following is a sample query for creating a database in MySQL: CREATE DATABASE `<DBNAME>` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Important: For workspace, you can create database with a custom name instead the default databases such as mfconsoledb.
For example, if you have created a workspace database with a custom name ( <prefix>mfconsoledb<suffix>), replace the custom database name in all SQL scripts in the \VoltMXFoundry_Plugins\scripts\waasdbmigrations\commondbscripts folder.

Execute all SQL scripts for the component by using the steps provided at Configuring Flyway Command-line Tool.

The following details pre-requisites for Flyway configuration:
- Schema name for workspace: mfconsoledb
- Placeholders for Workspace Services:


      # Volt MX Workspace Services Database, replace the following placeholders 
        # in SQL migrations for your database
        flyway.placeholders.VOLTMX_WAAS_LOG_LOCATION=C:VoltMXFoundry/logs
        flyway.placeholders.VOLTMX_WAAS_LOG_LEVEL=INFO
        flyway.placeholders.VOLTMX_WAAS_LOG_OPTION=logfile
        flyway.placeholders.VOLTMX_WORKSPACES_GLOBAL_DB
        flyway.placeholders.VOLTMX_WAAS_GLOBAL_DB

Tablespace Placeholders for Oracle:

Product Name Tablespace Placeholders for Oracle

Workspace WAAS_DATA_TABLESPACE , WAAS_INDEX_TABLESPACE , WAAS_LOB_TABLESPACE

SQL files paths for Workspace Services in VoltMXFoundry_Plugins folders.

Path for SQL files in the VoltMXFoundry_Plugins folder	Database	Component
\VoltMXFoundry_Plugins\scripts\waasdbmigrations\commondbscripts	MySQL	Workspace
\VoltMXFoundry_Plugins\scripts\mmigrations-waas-oracle\commondbscripts	Oracle
\VoltMXFoundry_Plugins\scripts\migrations-waas-sqlserver\commondbscripts	SQL Server

Execute all SQL scripts by using the steps provided at Configuring Flyway Command-line Tool.

In flyway conf, set flyway.baselineOnMigrate=true

set flyway.validateOnMigrate=false

Click here to view the Workspace schema diagram