Continuous Database Integration with Flyway

Abstract

“Classical” topics like relational database are often forgotten between hip topic like container. But in the reality we are confronted with task like how to automate my old system based on “old school” technology. This talk tries to show techniques to meet this challenge. Developers often neglect scritpts for relational databases. For the first release, they are generated by the ORM framework. But at the lastest during the second release, developers have to write the database migration scripts by themself. At this point the mess begins: the migration script are attached on tickets in the ticket system; they are shared via emails; maybe they are hidden in release notes and so on. At some point the overview, which migration script is for which software version is lost. This talk shows, why it is important to include database scripts in your continuous integration process and which conditions, not only technical, have to be defined. A demo, based on a Java web application, shows how Flyway

Sandra Parsick

Diplom-Informatiker