We'd like to move from the built-in H2 database to MariaDB, but the migration process doesn't appear to work when I specify the migration path & URL. The Flyway scripts fail on the V2 sql script because it's claiming that MariaDB only supports 768 char columns, rather than the 1000 char columns in the script. I can manually create the tables from the scripts, but then Flyway gets stuck in a migration loop on the next restart.
We're using Git as the backend storage, and can recreate the H2 database from it at-will. If I change to MariaDB and try that, it gets stuck on the Flyway errors again. The documentation on the site doesn't really go into a whole lot of detail on how to accomplish either method. Is there a better way to accomplish this? Thanks! -John John Wise Principal Software Engineer Momentum Engineering
