Continuous Database Migration with Flyway

Lightning talk/introduction to continuous database migration with Flyway as part of the Auckland Continuous Delivery meetup group.

Transcript

1. Continuous Database Migration with Flyway @EFFDEEDEE FREDERIK@TORQUE-ITS.COM 2014-09-16 1
2. Continuous Database Migration Database migration = schema & data DB version and application version (usually) go together DB should be considered part of application and sit in version control 2014-09-16 2
3. DB Migration Tools Static Changesets vs Dynamic Diffs Native (SQL) vs DSL Migration Type Declaration Flyway Changeset Native, Java Liquibase Changeset XML, JSON, YAML, Native SQL Server Data Tools Diff Native 2014-09-16 3
4. Flyway Automatic migration based on (transactional) changesets Plain/native SQL or Java (JDBC) based changesets Cloud/cluster ready Convention over configuration Supports lots of relational DBMSs incl. MSSQL, SQL Azure, MySQL, Oracle, Postgres, Derby, DB2 and others 2014-09-16 4
5. Flyway Versioning Images from http://flywaydb.org/documentation/migration/sql.html 2014-09-16 5
6. Flyway Execution Command line ◦ For any (incl. non-Java) applications ◦ Out of process migration API ◦ Java (incl. Android) only ◦ In-process migration/bundled with application Maven, Gradle, Ant… 2014-09-16 6
7. Flyway Issues Multi DBMS support = double up of scripts No downgrade support No API wrapper for .net or other platforms 2014-09-16 7
8. Links http://flywaydb.org/ http://www.liquibase.org/ http://msdn.microsoft.com/en-us/data/tools.aspx https://newzealand.msteched.com/conference/sessions/who-says-you- can%E2%80%99t-deploy-your-database-every-day/ 2014-09-16 8