Schema to SQL for Yii?

Hi,

when developing the model layer, Yii’s approach is to generate model files out of existing database structure.

As the development continues, some of the tables are slightly modified, extended with a field or whatever.

However some of the previous version are already deployed on client’s servers. While updating the system to most recent version, one need to manually check whether the database structure is the same as expected by code model.

What I’m looking for is something similar to Django’s “syncdb” command. Any recommendations?

Sync the db changes using migrations: http://www.yiiframework.com/doc/guide/1.1/en/database.migration