Doctrine Migrations vs sqldef
Doctrine Migrations
doctrine-project.org
sqldef
sqldef.github.ioSide by side
| Figure | Doctrine Migrations | sqldef |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 0 |
| Spec score · Database Migration Tools | 8.5 (#6) | 7.2 (#26) |
| License | The GitHub repository identifies the project as MIT licensed. | The sqldef source files are distributed under the MIT License, while the parser is distributed under Apache License 2.0. |
| Purpose | Doctrine Migrations adds database schema versioning and helps deploy schema changes. | sqldef is a CLI tool for diffing SQL schemas and managing RDBMS migrations with regular SQL DDLs. |
| Support | The documentation directs users to the Doctrine mailing list, Slack, GitHub bug reporting, and Stack Overflow for help. | The project invites feature requests through pull requests or GitHub Discussions. |
Plans
In their own words
Doctrine Migrations
Doctrine Migrations is a free, self-hosted PHP library for versioning database schemas and deploying changes in a reviewable, testable way. Built on Doctrine DBAL and ORM, it can generate migration code by comparing a database schema with ORM mapping information, with documentation covering diffing with or without the ORM. Console commands show migration status, perform dry runs, execute one or more migrations, and revert changes. Generated SQL can be written to a file with --write-sql instead of applied directly, while --no-interaction supports unattended execution. Transaction controls cover all-or-nothing behavior and running with or without transactions. Install it through Composer, which provides a doctrine-migrations console application, or download a PHAR from GitHub releases. Doctrine lists integrations for Symfony, Zend, Laravel, Silex, and Nette. Version 3.9.8 is stable; 3.8 and earlier are unmaintained.