New Database Migrator


#1

I have created a new migrator. Traditionally we have used “update.sh” which was executing doc/dbupdate/*.sql creating .ok files, but this new migrator now uses database to store your migration.

The benefit is that if you no longer need filesystem to store your migrations.

Here is how you use it inside your application:

$this->add('Controller_Migrator_MySQL')->migrate();

This should be placed after add-on initiators, this way any additional SQL migration included in your add ons will also be executed. I haven’t implemented the sorting fully.

Please give me your feedback then I’ll add this to 4.3 branch and will properly document:

I haven’t integrated it yet, so look at this file here:


#2

Just giving you an update that the new Migrator is now part of Agile Toolkit (master) and will be released in 4.3.1.

Read full article here: http://www.agiletoolkit.org/blog/native-mysql-migrator