You actually can specify a different connection in some way. Since the migrate command is part of the yiic tool, it looks at the settings defined in the "protected/config/console.php" configuration file while the webapp normally looks in the "protected/config/main.php" configuration file.
This way, you can have a db connectionstring for migrate that has a lot more rights than what the one you are using in the web application itself has.
You actually can specify a different connection in some way. Since the migrate command is part of the yiic tool, it looks at the settings defined in the "protected/config/console.php" configuration file while the webapp normally looks in the "protected/config/main.php" configuration file.
This way, you can have a db connectionstring for migrate that has a lot more rights than what the one you are using in the web application itself has.
Thanks , follow your instruction I got it working but seems that it calls only yiic.bat from within the application not the yii/framework/yiic.bat , if i call shell using yii/framework it is not working , so is it possible to get the yii-dbmigration to put into the yii/framework as all applications develop should use the same yii-dbmigration extension. ?