moodle 1.6 with mssql

moodle 1.6 with mssql

by don ko -
Number of replies: 2

 I want using moodle 1.6 with MSSQL (Dont want use mysql)

So I searched this forum. But i cant find solution.

Almost solution is older version than 1.6

And I try to search and change code..

So i complete install(setup) process)

But my moodle cant run correctly.

 

I just make & change sql sentence..

 

example)

copy & make ado_mssql.sql / php - db folder

replace

int8,6-bigint

int4,2 - int

rule - [rule]

................................

 

How can i do?

 

Help me plz....

Average of ratings: -
In reply to don ko

Re: moodle 1.6 with mssql

by Michael Winter -
At the moot I went to in New Zealand Martin talked about mssql and said they are working with Microsoft to get it working with moodle. I can't remember a time frame but I don't think it is in the neer future.
Average of ratings: -
In reply to don ko

Re: moodle 1.6 with mssql

by Dan Marsden -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
Hi Don,

MS Sql is not easily compatible with 1.6 - the patches in the forums are all that is available currently. However Martin Dougiamas and the team at Moodle HQ have been working on a new Database schema to allow full database independence which will allow support for MS SQL and in future Oracle and other widely available databases. This work will be in the 1.7 Moodle release

for your interest - here are the details on the new schema:
http://docs.moodle.org/en/XML_Database_Schema

The Moodle 1.7 release date is sometime in September, so if you are able to wait a couple of months, the new version should suit your needs.

thanks,

smile

Dan
Average of ratings: -