How to set database migration strategy to manual in Keycloak 18

[Avishka Perera]

According to the Keycloak Docs - Upgrading section (Upgrading), using --spi-connections-jpa-default-migration-strategy=manual would write all the necessary queries needed for database migration to a SQL file and would exit the server.

I have tried this config as an in-line argument as well as tried adding it in to the keycloak.conf file but still when I start the server it automatically migrates the database and starts up.

Have I missed anything? or is there another way to do this?

Also what's the default location where this SQL file will be available at once it is created?

[group account]

For Quarkus based KC it's  --spi-connections-jpa-quarkus-migration-strategy=manual and not with "default".

More details found in PR: https://github.com/keycloak/keycloak/pull/11110

[Avishka Perera]

Thanks! This worked!