yii schema.mysql.sql_php – 使用Yii2在sqlserver中选择Schema和table？

我有sql server数据库,它有多个架构.我尝试使用sqlsrv驱动程序从不同模式的表中选择一个,但是表示无效配置,该表不存在.

如何使用sqlsrv驱动程序在表中选择架构？

MyConnection的

return [

'class' => 'yii\db\Connection','dsn' => 'sqlsrv:Server=192.168.10.70;Database=mydatabase',// MS sql Server,sqlsrv driver public ip

'username' => 'user_username','password' => 'user_password','charset' => 'utf8',];

?>

我的模特

namespace app\models;

use Yii;

use yii\db\ActiveRecord;

class Transaction extends \yii\db\ActiveRecord

{

/**

* @inheritdoc

*/

public static function tableName()

{

return 'schema2.transaction';

}

public static function getDb()

{

return \Yii::$app->db3; // use the "db3" application component

}

/**

* @inheritdoc

*/

public function rules()

{

return [[['id','number','amount','date','status','description'],'required']];

}

/**

* @inheritdoc

*/

public function attributeLabels()

{

return [

'id' => Yii::t('app','Uid'),'number' => Yii::t('app','Number'),'date' => Yii::t('app','Date'),'amount' => Yii::t('app','Amount'),'description' => Yii::t('app','Item Description'),'status' => Yii::t('app','status'),];

}

}

?>