SQL server

[CabrioCar]

What a great project,
but our system has SQL-Server / sql-express.
Can you make an additional PDO connection possible to SQL server.
There are some LIMIT issues between SQL-server and MySQL.
But the sql commands are not explained in the API so it is not so clear what needs to change.
Can you make the software compatible for this connection?
https://www.microsoft.com/en-US/download/details.aspx?id=42299

[abiusx]

Migrating to SQL Server would be a major change. I don't believe it's easy to do that. It would probably need dozens of hours of work.

…

On Mar 31, 2020, at 9:30 PM, CabrioCar ***@***.***> wrote: What a great project, but our system has SQL-Server / sql-express. Can you make an additional PDO connection possible to SQL server. There are some LIMIT issues between SQL-server and MySQL. But the sql commands are not explained in the API so it is not so clear what needs to change. Can you make the software compatible for this connection? https://www.microsoft.com/en-US/download/details.aspx?id=42299 <https://www.microsoft.com/en-US/download/details.aspx?id=42299> — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#121>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAKWGW4JXIBPL63A5LZ7EQLRKIZC5ANCNFSM4LX3FV6Q>.

[CabrioCar]

PDO was used and this is the transparent connection from the application to the database.
What special queries are used, or settings on the database.

[abiusx]

The system is tightly coupled with performance of normal SQL servers and thus uses Nested Sets to improve this performance. Databases like SQL Server may support tree structures already. I'm not sure. Regardless, all queries need to be tested and adjusted for it.

…

On Mar 31, 2020, at 10:02 PM, CabrioCar ***@***.***> wrote: PDO was used and this is the transparent connection from the application to the database. What special queries are used, or settings on the database. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#121 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAKWGW2A24Q2DEHTPZPGG43RKI42VANCNFSM4LX3FV6Q>.