dx/dxkit/templates/yii2-basic/db.mssql.php.template

18 lines
No EOL
506 B
Text

<?php
return [
'class' => \yii\db\Connection::class,
'driverName' => 'sqlsrv',
'dsn' => 'sqlsrv:server=db;database=${PROJECT_NAME};encrypt=false',
'username' => '${DB_USER}',
'password' => '${DB_PASS}',
'charset' => 'utf8',
'attributes' => [
\PDO::SQLSRV_ATTR_ENCODING => \PDO::SQLSRV_ENCODING_SYSTEM
]
// Schema cache options (for production environment)
//'enableSchemaCache' => true,
//'schemaCacheDuration' => 60,
//'schemaCache' => 'cache',
];