Continuous Database Migration & Versioning


Niko Köbler, Qualitects Group

@dasniko

Niko Köbler

  • Software Architect & Consultant
  • Java, JavaScript, EAI
  • Co-Founder of Qualitects Group
  • Co-Lead of JUG DA
  • Speaker, Author

  • e: niko@n-k.de
  • t: @dasniko
  • w: www.n-k.de

Source Code  > VCS


Database > ???

3 Rules for Database Work

  1. Never use a shared database server
    for development work.

  2. Always have a single, authoritative source
    for your schema.

  3. Always version your database!


K.Scott Allen:  http://odetocode.com/blogs/scott/archive/2008/01/30/three-rules-for-database-work.aspx

Liquibase, Flyway, c5-db-migration, dbdeploy, mybatis, MIGRATEdb, migrate4j, dbmaintain, AutoPatch

Flyway

Plain
Old
SQL

Executions:

Java API
Maven
Gradle
Ant
Command-line

Relational Databases


Oracle, DB2, SQL Server, MySQL, PostgreSQL, H2, Derby, SQL Azure, Google Cloud SQL, Hsql

Resources

http://heise.de/-1857773
Demo-Code:  https://github.com/dasniko/flywaydb-demo

Demo

Made with Slides.com