Changes in Yii2 project to work with SQL Server

Lukket Opslået 2 år siden Betalt ved levering
Lukket Betalt ved levering

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 Microsoft SQL Server

Projekt ID: #32664872

Om projektet

4 bud Remote projekt Aktiv 2 år siden

4 freelancere byder i gennemsnit $52 timen for dette job

bizmanas

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 Flere

$78 USD in 3 dage
(3 bedømmelser)
2.4
xerohoster

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 på 1 dag
(1 bedømmelse)
0.6