Dbup, a simple PHP migration tool

Dbup is a simple migration tool for PHP.

• You have only to download dbup.phar.
• Dbup has only up command. Dbup does not have down command.
• Dbup use just a plain old sql, so you don't have to learn ORM nor DSL. You write sql file and just call up command.
• Dbup use just PDO class to migrate.
• Dbup doesn't need the table in a database to migrate.

Applied migration sql files are copied to .dbup/applied directory. If a same file exists both sql and .dbup/applied directory, up command ignores this sql file.

simple...simple..simple..

Requirements

Dbup works with PHP 5.4.0 or later.

Install

Installing Dbup is as easy as it can get. Download the dbup.phar and run init, then .dbup and sql directory are created and set a sample .env file and sqlfile.

php dbup.phar init

change the database config in .env.

DB_URI=localhost:3306/testdatabase?user=testuser&password=testpassword

see also http://www.php.net/manual/en/pdo.construct.php

Naming

You have to name a sql file like below:

V[version_number]__[description].sql

V is prefix. the separator is __ (two underscores). Suffix is .sql

Usage

List all commands.

php dbup.phar

You have to write a sql file to sql directory.

Show status.

php dbup.phar status

dbup migration status
================================================================================
          Applied At | migration sql file
--------------------------------------------------------------------------------
 2013-05-01 22:37:32 | V1__sample_select.sql
        appending... | V2__sample.sql
        appending... | V3__sample.sql
        appending... | V20__sample.sql
        appending... | V100__sample.sql

Up database after writing a new sql file.

php dbup.phar up

that's all.

License

Dbup is licensed under the MIT license.