quarkus.hibernate-orm.database.generation=update with schemes

[Paul6552]

I have several projects with Quarkus and in all of them I use quarkus.hibernate-orm.database.generation=update. A wonderful feature.

However, I have a project where not all data is in the "public-schema" but everything is in schemes. These schemes are generated with random numbers and the number is increasing every year:

Is there somehow a way for Quarkus to take care of all the schemes?

Currently, when we change an entity, we have to do this manually in all schemes using SQL scripts.

[quarkus-bot[bot]]

/cc @gsmet (hibernate-orm), @yrodiere (hibernate-orm)

[yrodiere]

Hello,

First, quarkus.hibernate-orm.database.generation=update is not intended for production. Use at your own risks. You should use Flyway/Liquibase instead.

Regarding the use of a different schema every year, you can set the default schema using quarkus.hibernate-orm.database.default-schema. The schema generation feature should take that into account.
If you need to migrate data from one schema to the next, however, that'll have to be done manually (or, again, use Flyway/Liquibase).