Download the PHP package portrino/px_dbmigrator without Composer
On this page you can find all versions of the php package portrino/px_dbmigrator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package px_dbmigrator
TYPO3 extension px_dbmigrator
Database Migrator for TYPO3
1 Features
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.
1.1 What it does
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.
2 Usage
2.1 Installation
Installation using Composer
The recommended way to install the extension is using composer.
Run the following command within your Composer based TYPO3 project:
Installation as extension from TYPO3 Extension Repository (TER)
Download and install the extension with the extension manager module.
2.2 Setup
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:
2.3 Invoke
Use the TYPO3 CLI to invoke the command to execute the migrations:
3 Troubleshooting
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.
4 FAQ
Can I use timestamps as migration numbers/ filename prefix?
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.
Do I need the leading zeros?
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
Can I undo a migration?
No, the migrator only knows one direction. You’ll need to do it manually.
5 Compatibility
| PxDbmigrator | TYPO3 | PHP | Support / Development |
|---|---|---|---|
| 3.x | 13.4 - 14.x | 8.2 - 8.5 | 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 |
6 Authors
- See the list of contributors who participated in this project.
Based on other great extensions:
- etobi/typo3-migrator by Tobias Liebig
- smichaelsen/typo3-migrator by Sebastian Michaelsen
