DB migration

Problems

DB migration

  • Database Structure

    • Tables, constraints, indexes

  • Database Data

    • Initial data like list of post codes, status for order, etc.

  • Database Logic

    • stored procedures, triggers, functions

Versions

  • v1.0.0

  • v1.1.0

  • v1.1.1

  • v1.2.0

  • v2.0.0

RDBMS vendors

  • PostgreSQL

  • MariaDB

  • H2

  • Oracle

  • SQL Server

  • IBM DB2

Solution

DB migration tools

  • Liquibase

  • FlyWay

  • MyBatis migrations

  • DBDeploy

Liquibase