Connection to Azure SQL DB

Yii 2.0 General Discussions
1

I’m trying to migrate an existing app from using a MySQL db to using an Azure db.

I switched the db component to

    'db' => [
        'class' => 'yii\db\Connection',
        'dsn' => 'sqlsrv:Server=****.database.windows.net;Database=****',
        'username' => '****@*****',
        'password' => '****',
        'charset' => 'utf8',
    ],

but now get the following error

SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name ‘auth_assignment’

I was previously getting the error

SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name ‘user’.

but was able to resolve it by prefixing the tablename in the model with the schema name. Where are the auth models defined?

Is my db component okay or did I need to do something else to work with Azure? Is there any documentation on the subject.

This is all running on Azure, how can I know if PDO is install and running? The fact that I get this error, does that indicate one way or another that PDO is running? This is all very new to me so the more information you can share is greatly appreciated.

Thank you in advance for any help.

2

Is there a simple way to define a schema to apply universally?

I tried adding

        'schemaMap' => [
            'sqlsrv'=> [
              'class'=>'yii\db\mssql\Schema',
              'defaultSchema' => '****'
            ]
        ],

but I still get the error:

SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name ‘auth_assignment’.
The SQL being executed was: SELECT * FROM [auth_assignment] WHERE [user_id]=‘1’