Upgrading Volt MX Foundry Manually
Additional steps for Foundry upgrade to V9 GA and later
The Identity provider and user information which resides in the Identity schema should be moved to the Workspace schema. Perform the following steps to execute a successful data migration from Identity to Workspace:
- Perform a backup of your schemas.
- Upgrade the Identity schema to Volt MX Foundry V9 or later.
- Upgrade the Workspace schema to version 899.00 by setting the
flyway.target
parameter in theflyway.conf
to the target version. For example, setflyway.target=899.00
while executing flyway scripts. The Workspace schema must be at v899.00 for the data migration step to be completed successfully. Once the data migration step has been completed, the schema upgrade resumes to Volt MX Foundry V9 or later. -
Execute a command line jar which takes a config.yml file as the input.
Sample config.yml file
Database specific inputs as follows:
Database Type | JDBC URL format | Database Driver | Hibernate dialect |
---|---|---|---|
MySQL | jdbc:mysql:// |
com.mysql.cj.jdbc.Driver | org.hibernate.dialect. MySQLDialect |
MariaDB | jdbc:mariadb :// |
org.mariadb.jdbc.Driver | org.hibernate.dialect. MySQLDialect |
Oracle DB | jdbc:oracle:thin:@ |
oracle.jdbc.driver.OracleDriver | org.hibernate.dialect. Oracle10gDialect |
MS SQL Server | jdbc:sqlserver:mbaastest18.hcl.net: |
com.microsoft.sqlserver.jdbc. SQLServerDriver | org.hibernate.dialect. SQLServerDialect |
- Begin the data migration from the identity schema to the workspace schema by executing the following command:
- Check the status of data migration by executing the following command:
- Resume the Console schema upgrade to the latest version by commenting the flyway.target parameter or leaving it blank in the flyway.conf file while executing the flyway scripts.