Support » Installing WordPress » MySQL vs. MS SQL

  • I am trying to get word press running. I have a Web Server running W2K3 enterprise edition. I am wondering if I have to use MySQL can I use MS SQL (which I have on my server). If not, what do I have to download exactly, because the MySQL website is confusing and I dont understand what I need to download from them to get it working. If yes, I can use MS SQL, can someone give me instructions to configure WP. Thanks in advance.

Viewing 11 replies - 1 through 11 (of 11 total)

    WordPress server requirements, as of version 1.2.2:

    * PHP version 4.1 or greater
    * MySQL version 3.23.23 or greater
    * (Optional) Apache mod_rewrite module (for clean URI’s known as Permalinks)

    WordPress requires MySQL. There has been talk of broadening support to other databases, but for now it’s just MySQL.

    I found this on google:
    Perhaps that’ll help

    What from the MySQL do i have to download. I don’t see which one I supposed to click they have so many variations.

    And 3 months later, still only MySQL?
    Not that I’m against it, but it’s bad news if you have a Windows/MS-SQL environment

    Maybe WP can incorporate ADODB into it, so it’ll work with MANY databases

    WP has only supported MySQL for a long time, you didn’t expect that to change in just 3 months, did you??

    I recently read that MySQL is on track to become the market share leader in database deployment fairly soon and it being free and all, I doubt there is a BIG push to support, least of all, MS SQL.


    You might add your wish here:

    And with MySql 5.0 about to hit the streets maybe convert your MS SQL to MySql so you can take advantage of WordPress 😉

    Added comment:
    Since you can run two MySQL servers on the same box don’t know why you couldn’t get MySql working on an MS Sql machine (just speculating here!)

    Can you imagine what that would do here? For that reason alone I hope WP doesn’t add the option of using a second database program.

    Our server actually runs MySQL 4.0 (for the PHP4/IIS server), MySQL 4.1 (for the PHP5/Apache2 server), MySQL 5.0 RC (for fun), and SQL Server 2000 (mainly for IIS). All that on one machine, and no problems whatsoever. is the page to download MySQL 4.1 if you have PHP5. is the MySQL 4.0 download if you use PHP4.



    I personally don’t mind WP using PHP + MySQL
    It’s that companies don’t usually use MySQL (we use ColdFusion + MS-SQL) and certainly rules out using WP for our blog purposes.

    Thanks anyway though!



    Years ago I considered mySQL but the lack of support for stored procedures was a show stopper for me. So now I have dozens of applications and ecommerce sites running on my MS SQL. (best product ever made by MS IMHO).

    So I suppose I could throw out years of accumulated knowledge and infrastructure just for the privilige of using WordPress, or during your next re-write, you could add ADODB as the other member mentioned.

    Considering this is blogware I can’t imagine that there are many routiens that require vendor specific db services anyway it should be to hard to generalize it.



    Wow, no need to be so snipey.

    WP currently does require MySQL and PHP, end of story. There is absolutely no reason you cannot have MS SQL Server and MySQL 4.1 or 5.0 (or both) installed on the same machine, unless memory is at a premium. If port 80 is free on one of the machine’s IP addresses, you can even install Apache for the full experience.

    You have to understand that there are probably NO routines that require a vendor-specific approach in the blogware itself (with the possible exception of permalinks). However, MS SQL and MySQL have very different SQL syntax in some cases, and MySQL actually has support for a couple of things that SQL Server lacks. So to get WP to support other databases, either almost every SQL statement must be rewritten or surrounded by SELECT CASE statements, or a complete DAL must be written and all the SQL statements replcaed with calls to the DAL.

    BTW, MySQL 5.0 introduced stored procedures and triggers. Give it another look if you’re so inclined, and remember that there is NO reason you can’t have SQL Server and MySQL running on the same machine.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘MySQL vs. MS SQL’ is closed to new replies.