Upgrading from Moodle 1.9 to 2.0 on Windows Server

Upgrading from Moodle 1.9 to 2.0 on Windows Server

by Robert G -
Number of replies: 1

Hi, our team is currently having trouble performing this upgrade and I haven't found any solid documentation anywhere.

We currently have Moodle 1.9 installed on our Windows Server with PHP 5.2. It is connecting to a MSSQL database using FreeTDS. We would like to start moving to Moodle 2.0, which requires PHP 5.3. The problem is, when we upgrade to PHP 5.3, we can no longer connected to the MSSQL database. If we look at PHP_info.PHP there is no MSSQL extension running. We tried downloading and enabling this extension from Microsoft as well and it did not work: http://www.microsoft.com/en-us/download/details.aspx?id=20098.

Is there documentation on how to accomplish this upgrade on Windows Server or can someone assist? Thanks

Average of ratings: -
In reply to Robert G

Re: Upgrading from Moodle 1.9 to 2.0 on Windows Server

by Bret Miller -
Picture of Particularly helpful Moodlers

Well, I'm not using this environment, but http://docs.moodle.org/23/en/Using_the_Microsoft_SQL_Server_Driver_for_PHP purports to answer the question you asked. 

From my own experience, ODBC seems the most stable in connecting to MSSQL from PHP, but Moodle doesn't seem to support that. Perhaps it should be suggested that Moodle implement PDO since that supports MySQL, Oracle, ODBC (and thus MSSQL), and PostgreSQL. Overall that would tend to simplify database support within Moodle. I realize that SQL syntax itself differs slightly between database systems, so it wouldn't solve every difference.

Average of ratings: -