How to change the database schema to introduce new features or change current features

Question

I am developing an application using Zend Framwork using Git for version control.

What is the best approach for updating the schema and database when one of us is updating the db structure?

we must currently blow the tables and recreate them manually to reflect new updates.

Answer 1

ZF Akrabat Db Schema Manager . , @ceteras. , , Zend_Tool, .

Answer 2

:

• . , , DDL- (alter table add column ..) , Bugzilla/Jira , . , .

, , , svn.

, , .

, . , Navicat . , , . , .

Answer 3

DBDeploy

dbdeploy - . , - - , , .

Theres DBDeploy Phing ( PHP Apache Ant)

Answer 4

migrations. - . SQL , , . Youd , .

ZendFramework , Db_Schema_Manager. , , , , , - ZendTools.

Here is a link to how to use Db_Schema_Manager: http://framework.zend.com/wiki/display/ZFPROP/Zend_Db_Schema_Manager+-+Rob+Allen