Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
203 lines (142 sloc) 7.61 KB
.. index::
   single: Introduction


The Doctrine Migrations offer additional functionality on top of the database abstraction layer (DBAL) for versioning your database schema and easily deploying changes to it. It is a very easy to use and powerful tool.

In order to use migrations you need to do some setup first.


There are two ways to use the Doctrine Migrations project. Either as a supplement to your already existing Doctrine DBAL (+ ORM) setup or as a standalone "PHP Binary" (also known as PHAR).

Use as Supplement

To use the Migrations as supplement you have to get the sources from the GitHub repository, either by downloading them, checking them out as SVN external or as Git Submodule.

Then you have to setup the class loader to load the classes for the DoctrineDBALMigrations namespace in your project:

require_once '/path/to/migrations/lib/vendor/doctrine-common/Doctrine/Common/ClassLoader';

use Doctrine\Common\ClassLoader;

$classLoader = new ClassLoader('Doctrine\DBAL\Migrations', '/path/to/migrations/lib');

Now the above autoloader is able to load a class like the following:


Register Console Commands

Now that we have setup the autoloaders we are ready to add the migration console commands to our Doctrine Command Line Interface:

// ...

    // ...

    // Migrations Commands
    new \Doctrine\DBAL\Migrations\Tools\Console\Command\DiffCommand(),
    new \Doctrine\DBAL\Migrations\Tools\Console\Command\ExecuteCommand(),
    new \Doctrine\DBAL\Migrations\Tools\Console\Command\GenerateCommand(),
    new \Doctrine\DBAL\Migrations\Tools\Console\Command\MigrateCommand(),
    new \Doctrine\DBAL\Migrations\Tools\Console\Command\StatusCommand(),
    new \Doctrine\DBAL\Migrations\Tools\Console\Command\VersionCommand()

Additionally you have to make sure the 'db' and 'dialog' Helpers are added to your Symfony Console HelperSet.

$db = \Doctrine\DBAL\DriverManager::getConnection($params);
// or
$em = \Doctrine\ORM\EntityManager::create($params);
$db = $em->getConnection();

$helperSet = new \Symfony\Component\Console\Helper\HelperSet(array(
    'db' => new \Doctrine\DBAL\Tools\Console\Helper\ConnectionHelper($db),
    'dialog' => new \Symfony\Component\Console\Helper\QuestionHelper(),

You will see that you have a few new commands when you execute the following command:

$ ./doctrine list migrations
Doctrine Command Line Interface version 2.0.0BETA3-DEV

  [options] command [arguments]

  --help           -h Display this help message.
  --quiet          -q Do not output any message.
  --verbose        -v Increase verbosity of messages.
  --version        -V Display this program version.
  --color          -c Force ANSI color output.
  --no-interaction -n Do not ask any interactive question.

Available commands for the "migrations" namespace:
  :diff      Generate a migration by comparing your current database to your mapping information.
  :execute   Execute a single migration version up or down manually.
  :generate  Generate a blank migration class.
  :migrate   Execute a migration to a specified version or the latest available version.
  :status    View the status of a set of migrations.
  :version   Manually add and delete migration versions from the version table.

PHP Binary / PHAR

You can download the Migrations PHP Binary, which is a standalone PHAR package file with all the required dependencies. You can drop that single file onto any server and start using the Doctrine Migrations.

To register a system command for the migrations you can create a simple batch script, for example on a *nix Environment creating a /usr/local/bin/doctrine-migrations:

php /path/to/doctrine-migrations.phar "$@"

You could now go and use the migrations like:

myshell> doctrine-migrations

Because the PHAR file is standalone it does not rely on the Symfony Console 'db' Helper, but you have to pass a --db-configuration parameter that points to a PHP file which returns the parameters for DoctrineDBALDriverManager::getConnection($dbParams). If you don't specify this option Doctrine Migrations will look for a migrations-db.php file returning that parameters in your current directory and only throw an error if that is not found.


The last thing you need to do is to configure your migrations. You can do so by using the --configuration option to manually specify the path to a configuration file. If you don't specify any configuration file the tasks will look for a file named migrations.xml or migrations.yml at the root of your command line. For the upcoming examples you can use a migrations.xml file like the following:

<?xml version="1.0" encoding="UTF-8"?>
<doctrine-migrations xmlns=""

    <name>Doctrine Sandbox Migrations</name>


    <table name="doctrine_migration_versions" />



Of course you could do the same thing with a configuration.yml file:

name: Doctrine Sandbox Migrations
migrations_namespace: DoctrineMigrations
table_name: doctrine_migration_versions
migrations_directory: /path/to/migrations/classes/DoctrineMigrations

With the above example, the migrations tool will search the migrations_directory recursively for files that begin with Version followed one to 255 characters and a .php suffix. Version.{1,255}\.php is the regular expression that's used.

Everything after Version will be treated as the actual version in the database. Take the file name VersionSomeVersion.php, SomeVersion would be the version number stored in the migrations database table. Since versions are ordered, doctrine :doc:`generates </reference/generating_migrations>` version numbers with a date time like Version20150505120000.php. This ensures that the migrations are executed in the correct order.

While you can use custom filenames, it's probably a good idea to let Doctrine :doc:`generate migration files </reference/generating_migrations>` for you.

And if you want to specify each migration manually in YAML you can:

table_name: doctrine_migration_versions
migrations_directory: /path/to/migrations/classes/DoctrineMigrations
    version: 20100704000000
    class: DoctrineMigrations\NewMigration

If you specify your own migration classes (like DoctrineMigrationsNewMigration in the previous example) you will need an autoloader unless all those classes begin with the prefix Version*, for example path/to/migrations/classes/VersionNewMigration.php.