WordPress.org

Ready to get started?Download WordPress

Forums

MySQL vs. MS SQL (12 posts)

  1. DaRk_DrOnE_ZX1
    Member
    Posted 9 years ago #

    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.

  2. http://codex.wordpress.org/Hosting_WordPress

    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)

  3. jalenack
    Member
    Posted 9 years ago #

    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: http://www.tss2000.nl/vbforum/showthread.php?mode=hybrid&t=175
    Perhaps that'll help

  4. DaRk_DrOnE_ZX1
    Member
    Posted 9 years ago #

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

  5. jerryhung
    Member
    Posted 8 years ago #

    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

  6. Cypher
    Member
    Posted 8 years ago #

    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.

    Regards

  7. MichaelH
    Member
    Posted 8 years ago #

    You might add your wish here:
    http://codex.wordpress.org/Version_1.6

    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!)

  8. Beel
    Member
    Posted 8 years ago #

    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.

  9. RustIndy
    Member
    Posted 8 years ago #

    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.

    http://dev.mysql.com/downloads/mysql/4.1.html is the page to download MySQL 4.1 if you have PHP5.

    http://dev.mysql.com/downloads/mysql/4.0.html is the MySQL 4.0 download if you use PHP4.

  10. jerryhung
    Member
    Posted 8 years ago #

    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!

  11. lonecrow
    Member
    Posted 8 years ago #

    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.

  12. RustIndy
    Member
    Posted 8 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.