Yii Framework 1.x migration system is very powerful and gives you much more power and control over database update process. But it becomes a horrible nightmare, if you have to deal with
.sql files and convert them into Yii migration files manually.
This article should help you in that strike or at least ease your work.
If you have any doubts, why the hell migrations are better than using plan .sql files then this blog post should provide you with at least some reasons.Read More “Converting database structure or .sql file into Yii migration”