Changes in Yii2 project to work with SQL Server
Budget: $10 – $30 USD
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 “apphazard.users”, 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
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 “apphazard.users”, 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