zend database migration scripts

Question

I would like to know how do you guys work in Zend Framework environment especially how to keep the database table up to date with others team (database change management) . I have small team who works at their home and we need to have latest database table everytime. We works at home so sometimes we work after finishing our main job at office.

Any idea ?

ps: just like Rails migration

Answer 1

We're using the db deploy feature of phing to keep track on database changes over time and to update the database between our developers. We're also using it to deploy new versions of our application, which usually include database updates.

Basically each time someone need to update the database scheme, he adds a database migration script. Each developer can then run phing to execute these db migration scripts automatically.

For more details, see a good guide on the subject here: http://www.davedevelopment.co.uk/2008/04/14/how-to-simple-database-migrations-with-phing-and-dbdeploy/