Oracle Schema SQL

Support
1

Hi,
I made an application with Jmix using PostgreSQL db.

From the beginning I flagged the "Enable support for several DB types and checked

  • Postgres
  • Oracle

I now would like to migrate to an oracle db.
The administrator asked me for an SQL schema to create the db.

Is there a way to generate the schema for oracle from Jmix?

If not, if I select from the database type “Oracle Database” will Jmix create independently the table in the oracle database?

What can be the best solution to migrate?

Dave

2

Hi Dave,

If you have selected Postgres and Oracle as the supported databases, Jmix Studio should have generated Liquibase changelog files suitable for both these databases. For example, if your entities have UUID primary keys, the table definitions should use the ${uuid.type} variable for PK columns, and this variable is defined as uuid for Postgres and as varchar2(32) for Oracle.

So the same set of Liquibase changelogs should be executed successfully on the Oracle database if you switch the Data Store in the project to Oracle.

Regards,
Konstantin