Issue Details (XML | Word | Printable)

Key: MDL-17969
Type: Sub-task Sub-task
Status: Open Open
Priority: Minor Minor
Assignee: Eloy Lafuente (stronk7)
Reporter: Petr Skoda
Votes: 1
Watchers: 2
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle
MDL-14679

Implement native MS sql server drivers (freetds and sqlsrv)

Created: 20/Jan/09 02:25 AM   Updated: 08/Oct/09 10:56 PM
Return to search
Component/s: Database SQL/XMLDB
Affects Version/s: 2.0
Fix Version/s: 2.0

Database: Microsoft SQL
Participants: Eloy Lafuente (stronk7) and Petr Skoda
Security Level: None
Affected Branches: MOODLE_20_STABLE
Fixed Branches: MOODLE_20_STABLE


 Description  « Hide
For now we have only adodb based legacy drivers for ms sql server. We have several options in 1.9x, unfortunately the level of support and quality does not meet mysql or pgsql drivers.

I appears that the FreeTDS/mssql driver works fine in Linux, but there are some problems running it on Win 32 platforms (luckily we are now testing newly compiled dlls that could improve the situation).
There is another alternative - Microsoft released recently new sql server PHP driver, unfortunately this driver works only on win32 platforms.

Solution is to create two native DML drivers - freetds/mssql and brand new sqlsrv.

Known problems:
1/ session locking support missing - db sessions do not work, we will have to find some equivalent to get_lock() mysql feature
2/ encoding conversions in sqlsrv driver - it does not support utf-8 :-(
3/ review and testing of new moodle 2.0dev code (last 12 months)

I guess this could take roughly 21 days to get it ready for production use. More time will be required for continual review and testing of new code in HEAD

MS provided us with free licenses for development - at least there would not be any extra license costs for testing of this closed, proprietary database, but I doubt anybody will do this in his/her free time ;-)

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Petr Skoda made changes - 20/Jan/09 02:32 AM
Field Original Value New Value
Summary Implement native sql server drivers (freetds/ms win only) Implement native sql server drivers (freetds and sqlsrv)
Petr Skoda made changes - 20/Jan/09 02:33 AM
Summary Implement native sql server drivers (freetds and sqlsrv) Implement native MS sql server drivers (freetds and sqlsrv)
Petr Skoda made changes - 20/Jan/09 02:34 AM
Database [Microsoft SQL]
Eloy Lafuente (stronk7) made changes - 31/Aug/09 10:59 PM
Assignee Petr Skoda [ skodak ] Eloy Lafuente (stronk7) [ stronk7 ]
Eloy Lafuente (stronk7) made changes - 08/Oct/09 10:56 PM
Fix Version/s 2.0 [ 10122 ]