Migrations

A common tasks in evolving applications is the need to migrate data and data structures to a specific format. Common examples are adding a new column to a database table or changing data.

To be able to execute migration changes across environments, Pimcore integrates the Doctrine Migrations Bundle library which provides a powerful migration framework.

To create your project or bundle specific migrations you can just follow the official guide linked above. However, Pimcore adds one small yet helpful feature to the provided commands by the Doctrine Migrations Bundle. Normally Doctrine Migrations just runs/lists all available migrations, defined in the config. Since it could be useful to filter migrations for a certain path (core, bundle or project), Pimcore adds the --prefix option to all Doctrine commands, which let's you filter migrations by the given namespace.

If you'd like to create migrations for your bundle, please have a look at our bundles documentation. We're providing a customized abstract for bundles which makes using bundles even more comfortable.

Example Commands

# just run migrations of the Pimcore core
./bin/console doctrine:migrations:migrate --prefix=Pimcore\\Bundle\\CoreBundle

# run migrations of a certain bundle
./bin/console doctrine:migrations:migrate --prefix=Vendor\\PimcoreExampleBundle

# generate a project specific migration
./bin/console doctrine:migrations:generate --namespace=App\\Migrations

# run project specific migrations
./bin/console doctrine:migrations:migrate --prefix=App\\Migrations

Config Examples for your Project (config/config.yaml)

doctrine_migrations:
    migrations_paths:
        'App\Migrations': '%kernel.project_dir%/src/Migrations'

Run all available migrations after composer update

If you'd like to run all available migrations after composer update including bundles and your app-specific migrations, just include the following part in your composer.json.

"post-update-cmd": [
    "./bin/console doctrine:migrations:migrate"
]