Hello
I am currently learning and working with Jmix in my thesis.
I am creating a demo application but I realized I am using Hsqldb database and now I want to switch to another database for example: Mysql or PostgreSQl
I want the data on my application to not change anything
I would love to help
Hi!
Jmix doesn’t provide mechanisms for migrating data from one user database to another, as this is beyond the framework’s responsibility.
As an alternative solution, you can use the entity export/import mechanism using the EntityInspector system view (not a production-ready solution).
https://docs.jmix.io/jmix/data-tools/entity-inspector.html
Best regards,
Dmitriy
so is there any way i can change to another database
i want to keep all tables and table properties
If your table properties were set by standard mechanisms of Jmix Studio and Liquibase, then the properties will be applied to the new database. All other proeprties will have to be reproduced independently.
let me ask is my current database saved in my system folders
i want to package my system to send, will the database be packed in there?
thank you very much
If you use hsqldb in file as a database, the database files are located in the following path:
{project-root}/.jmix/hsqldb. These files will be saved when you package the project.