Tweet
Tweet

Slide 1

Slide 1 text

Database Versioning – the agile way with FlywayDB Niko Köbler @dasniko

Slide 2

Slide 2 text

SourceCode > VCS Database > ???

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

• flywaydb.org • Apache v2.0 Licence • Open Source Java Library • Current Release: 2.1.1 • Download from Website or Central Maven Repository

Slide 5

Slide 5 text

Plain Old SQL

Slide 6

Slide 6 text

Java Migrations

Slide 7

Slide 7 text

Convention Configuration

Slide 8

Slide 8 text

Convention Configuration

Slide 9

Slide 9 text

Convention Configuration

Slide 10

Slide 10 text

Execution: Java API

Slide 11

Slide 11 text

Execution: Maven

Slide 12

Slide 12 text

Execution: Others • Ant Tasks • Command-line Tool

Slide 13

Slide 13 text

Various Databases

Slide 14

Slide 14 text

Go ahead and use it!