When Testing with a Different Database Chokes on Your DDL
I recently found myself writing a test that needed a database. Unfortunately, our testing database,
H2, doesn’t support all of the features of our production database,
PostgreSQL. This meant that the
Flyway migrates used to manage the production database broke in the testing environment. The fix for
this turned out to be pretty simple.