how to handle database/table changes in PHP?

Question

Ok so now I have this problem i need to add a "balance" column for my users table. I am using the Zend framework and I was hoping to use this one here:

http://framework.zend.com/wiki/display/ZFPROP/Zend_Db_Schema_Manager+-+Rob+Allen#Zend_Db_Schema_Manager-RobAllen-6.Milestones%2FTasks

Unfortunately i suppose it never got into the implementation stage and there's just the header file, the imeplementation file is nowhere to be downloaded.

Would you guys have any suggestion? I don't want to go to 5 mysql database and add manually the column i need - at the same time i don't want to be doing it this way everytime i need to make any db changes. I need something like the zend schema manager component.

score 4 · Accepted Answer · edited May 23 '17 at 11:47

4

I'm currently using Akrabat_Db_Schema_Manager as a database migration tool. It's written in Zend Framework and is pretty straightforward, all database changes should be written in raw SQL.

You can also take a look at Doctrine Migration Tool. It allows you to write migrations using only Doctrine objects, thus skipping writing raw SQL part. Not sure if it exists for Doctrine 2.0 though.

More insights here.

edited May 23 '17 at 11:47

Community

1
1

answered Mar 14 '11 at 15:49

Vika

3,275
18
16

oooh nice so Akrabat is the continuation of the ZEnd Schema Manager written by the same author. – David Mar 15 '11 at 20:33
@David: exactly! sorry, forgot to mention it – Vika Mar 15 '11 at 21:04

how to handle database/table changes in PHP?

1 Answers1