Application Driven Database Using Yii Migration

Yii 1.1 General Discussion
1

Hi All,

I am new to Yii. I am currently working on an application with Yii and sqllite database. We have a new requirement to manage the migration of database changes. i.e. due to development changes we sometimes alter the database objects or create new tables. But to implement this database change is difficult on the production to connect to the sqllite prompt and run the scripts to alter the table or create a new one.

Yii migration feature seems to help us but "yiic migrate" command has to be manually invoked. Trying for a solution where this can be automatic or to run the migrate command through php application itself.

Recently found an article where this can be automated.

http://www.yiiframework.com/wiki/270/application-driven-database-with-cdbmigration-and-an-extended-cactiverecord/

But the article says it would work for MySql database only. Unfortunately we have sqllite database.

Is there any solution developed for sqllite DB also?

Thank you

2

Hi,

Found the solution for this. yiic migrate can be run directly from php without shell. Please refer the below link

http://www.yiiframework.com/wiki/226/run-yiic-directly-from-your-app-without-a-shell/

Thanks to jacmoe