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!


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

Demo

Continuous Database Migration & Versioning

By Niko Köbler

Continuous Database Migration & Versioning

  • 3,571