DBマイグレーションツールまとめメモ

rails(ActiveRecord)

• http://rubyonrails.org/
• http://railsdoc.com/migration
• Ruby製
• DSL
• フレームワーク型

20161019235959_create_users.rb

class CreateUsers < ActiveRecord::Migration
  def change
    create_table :users do |t|
      t.string :name
    end
  end
end

flyway

• https://flywaydb.org/
• https://github.com/flyway/flyway
• Java製
• SQL

Phinx

• https://phinx.org
• https://github.com/robmorgan/phinx
• PHP製
• DSL

20161019235959_create_users.php

<?php
use Phinx\Migration\AbstractMigration;

class CreateUsersTable extends AbstractMigration
{
    // Migrate Up
    public function up()
    {
        $table = $this->table('users');
        $table->addColumn('id', 'integer')
              ->addColumn('name', 'string')
              ->create();
    }

    // Migrate Down
    public function down()
    {
        $this->execute('DELETE FROM users');
    }
}

migr8

• https://github.com/kwatch/migr8
• Ruby製
• SQL

Phpmig

• https://github.com/davedevelopment/phpmig
• PHP製
• SQL

Yii

• http://www.yiiframework.com/doc/guide/1.1/ja/database.migration
• PHP製
• DSL
• フレームワーク型

simple-db-migrate

• http://guilhermechapiewski.github.io/simple-db-migrate/
• https://github.com/guilhermechapiewski/simple-db-migrate
• Python製
• SQL

ridgepole

• https://github.com/winebarrel/ridgepole
• Ruby製
• DSL
• cookpad

goose

• https://bitbucket.org/liamstask/goose
• Go製
• SQL

migo

• https://github.com/meta-closure/migo
• Go製
• JSON Schema

Liquibase

• http://www.liquibase.org/
• Java製
• XML・YAML・JSON・SQL

MyBatis Migrations

• http://www.mybatis.org/migrations/
• Java製
• SQL