Changes in Yii2 project to work with SQL Server

I have a project actually working with MySQL, I need to change it to SQL Sever database, but I have some issues in this process.

The problem is with the schema name that SQL Server database work in tables, for example I have a “users” table in MySQL but in SQL the table is “[login to view URL]”, is not problem for me to change it in the users model and works correct, but I can´t do it in the “authManager” process, I mean the access, roles, login processes, that use some tables like “x_auth_assignment” and others that don´t have a model to manage this, the I obtain result like “[ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'x_auth_assignment'”

My requirement is if I can change them with minor changes

What I already did:

- database migration to SQL server

- database connection with SQL server with a correct driver

- possibility to use my own tables with the sql server schema

What I need:

- adapt the “authManager” control to work with sql server database with schema

- it has to work in all the parts: login page, user maintenance, roles use, etc.

- the requirement is if it can do it with minor changes, if this requires major changes then suggest it to evaluate the proposal

Yii2 Server Microsoft SQL

ID Proiect: #32664872

Detalii despre proiect