flyway-dbunit-test or flyway-spring-test ?

[Ivan-Masli-GDP]

If I use Springtestdbunit (https://github.com/springtestdbunit/spring-test-dbunit) on my Unit tests, should I use flyway-dbunit-test or flyway-spring-test ?

[FlorianGWE]

I can not give you a general answer. It depends really on your project set up.

May be I can give you a hint for your use case.

1. flyway-spring-test you should use if your project setup use Flyway to setup your database and in your test cases you need to reset your database to defined initial state. In this case you should use annotation @FlywayTest. So Flyway is your database master.
2. flyway-dbunit-test is a add on for flyway-spring-test with that you can save table content or the whole database after a test run or load specific test data in your database. It does not add any support for database test validation as dbunit have. it is a load or export utility.

spring-test-dbunit have a different approach. It give you the whole DbUnit functionality support to compare and validate the database result after a test run. With this you can load complete a previous saved database, but this fit not complete to Flyway style. In this case you will setup our database with Flyway than take a snapshot of your database with dbunit and use this snaphot in your test. This must always be done with each schema migration!

Conclusion

• When you will combined both project because you need the after test database validation and want or need the setup with Flyway, than you should try flyway-spring-test with spring-test-dbuint. In this case may be it can be little be tricky to get the both execution listener run in correct order Flyway for DbUnit.
• When you only want to load some simple test data or test table in your database you should use flyway-dbunit-test without spring-test-dbunit.