Kapalı

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

Beceriler: Yii2, Microsoft SQL Server

About the Client:
( 8 değerlendirme ) San Miguel, Peru

Proje NO: #32664872

Bu iş için 4 freelancer ortalamada $52 teklif veriyor

(45 Değerlendirme)
5.4
(2 Değerlendirme)
3.3
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 Daha Fazla

$78 USD in 3 gün içinde
(3 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.6