Database Migrator for TYPO3
Today TYPO3 projects are mostly developed and deployed using git. The PxDbmigrator extension can help you to work with SQL changes in this environment. Apply SQL changes on all developer instances or even deploy changes to your Production or Staging systems.
The PxDbmigrator extension provides a command that executes migration files (e.g. *.sql files or *.sh or
*.typo3cms files) that you place in a configurable directory.
Once the command is called it checks for new migration files and "executes" them in the given order.
So if you want to distribute a SQL Command (e.g. an INSERT/ REPLACE statement for a new record) across your installations, just create a file with a unique name and push it into your repository. Once others pull it and execute the PxDbmigrator command, they will have your changes applied!
It's recommended to automate the execution of the command using composer pre- or post- scripts.
The recommended way to install the extension is using composer.
Run the following command within your Composer based TYPO3 project:
composer require portrino/px_dbmigrator
Download and install the extension with the extension manager module.
After finishing the installation, head over to the extension settings and adjust the given settings to your needs.
So, a possible configuration in the LocalConfiguration.php of a composer managed TYPO3 installation could look like:
return [
...
'EXTENSIONS' => [
...
'px_dbmigrator' => [
'migrationFolderPath' => '../migrations',
'mysqlBinaryPath' => '/usr/bin/mysql',
'typo3cmsBinaryPath' => '/vendor/bin/typo3',
],
...
],
...
];
Use the TYPO3 CLI to invoke the command to execute the migrations:
./vendor/bin/typo3 migration:migrateall
If the execution of a migration file fails, the associated registry entry of the last executed file won't be stored in the database and the file will be executed again on the next run. Notice that it already might have done changes to your database before it crashed!
If you want to see which migration was executed last, you can check the database table sys_registry with the namespace
PxDbmigrator.
Sure. This is indeed the recommended way to do it, as the filename already contains the date of creation and the files are sorted correctly by name.
No, you can also use 1.sql and so on. But as already mentioned above, the recommended way is to use timestamps.
Example: 1696560849-adds-some-required-pages.sql
No, the migrator only knows one direction. You’ll need to do it manually.
| PxDbmigrator | TYPO3 | PHP | Support / Development |
|---|---|---|---|
| 3.x | 13.4 | 8.2 - 8.3 | features, bugfixes, security updates |
| 2.x | 12.4 | 8.1 - 8.2 | bugfixes, security updates |
| 2.x | 11.5 | 7.4 - 8.1 | bugfixes, security updates |
| 2.x | 10.4 | 7.2 - 7.4 | bugfixes, security updates |
- See the list of contributors who participated in this project.
- etobi/typo3-migrator by Tobias Liebig
- smichaelsen/typo3-migrator by Sebastian Michaelsen