Wrap migration in a transaction?

[mgersten-caxy]

Is there any reason why migrations (up, down) aren't wrapped in a transaction by default? This would seem like a nice feature to have.

[stof]

First, this is the wrong place to ask for it as this bundle does not implement migrations. It only integrates it with Symfony

And the reason why they are not in transaction is simple: support in RDBMS is totally inconsistent for this.
For instance, MySQL does support altering tables in a transaction. If you try to do it, it will commit the current transaction, then alter the table outside it and then start a new transaction for the next part. So doing a rollback would only rollback changes done after the last altering.

[wadjeroudi]

https://www.doctrine-project.org/projects/doctrine-migrations/en/latest/reference/configuration.html#all-or-nothing-transaction