class m151223_062347_data_transfer extends Migration
{
public function setDb($db)
{
$this->db = $db;
}
public function safeUp()
{
$this->db = $this->setDb('db');
$this->db2 = $this->setDb('db2');
$shema = $this->db2->schema->getTableSchema('users');
public function up()
{
Yii::$app->db->createCommand()->batchInsert('users',
['id', 'name', 'email', 'role'], [
[1, 'Vanya', 'vanya@example.com', 10],
[2, 'Kolya', 'kolya@example.com', 1],
[3, 'Dima', 'dima@example.com', 1],
])->execute();
}