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

Taidot: Yii2, Microsoft SQL Server

Tietoa työnantajasta:
( 8 arvostelua ) San Miguel, Peru

Projektin tunnus: #32664872

4 freelanceria on tarjonnut keskimäärin $52 tähän työhön

(45 arvostelua)
(2 arvostelua)

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress SQL development, Python,C#, power bi. I will be able to help you with the project. Please ping me offline to discuss fur Lisää

$78 USD 3 päivässä
(3 arvostelua)

Hi there, I can help you to solve the auth assignment issue in SQL Server. Please chat with me for more detailed discussion. Thank you

$30 USD 1 päivässä
(1 arvostelu)