Title: MySQL vs. MS SQL Last modified: August 18, 2016 --- # MySQL vs. MS SQL * [dark_drone_zx1](https://wordpress.org/support/users/dark_drone_zx1/) * (@dark_drone_zx1) * [20 years, 9 months ago](https://wordpress.org/support/topic/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) * [viper007bond](https://wordpress.org/support/users/viper007bond/) * (@viper007bond) * [20 years, 9 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251200) * [http://codex.wordpress.org/Hosting_WordPress](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) * [jalenack](https://wordpress.org/support/users/jalenack/) * (@jalenack) * [20 years, 9 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251216) * 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](http://www.tss2000.nl/vbforum/showthread.php?mode=hybrid&t=175) Perhaps that’ll help * Thread Starter [dark_drone_zx1](https://wordpress.org/support/users/dark_drone_zx1/) * (@dark_drone_zx1) * [20 years, 9 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251217) * What from the MySQL do i have to download. I don’t see which one I supposed to click they have so many variations. * [jerryhung](https://wordpress.org/support/users/jerryhung/) * (@jerryhung) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251350) * 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 * [Cypher](https://wordpress.org/support/users/cypher/) * (@cypher) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251351) * 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 * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251352) * You might add your wish here: [http://codex.wordpress.org/Version_1.6](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!) * [Beel](https://wordpress.org/support/users/beel/) * (@beel) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251353) * 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. * [rustindy](https://wordpress.org/support/users/rustindy/) * (@rustindy) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251354) * 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](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](http://dev.mysql.com/downloads/mysql/4.0.html) is the MySQL 4.0 download if you use PHP4. * [jerryhung](https://wordpress.org/support/users/jerryhung/) * (@jerryhung) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251355) * 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! * [lonecrow](https://wordpress.org/support/users/lonecrow/) * (@lonecrow) * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251371) * 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. * [rustindy](https://wordpress.org/support/users/rustindy/) * (@rustindy) * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251372) * 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. * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 11 replies * 9 participants * Last reply from: [rustindy](https://wordpress.org/support/users/rustindy/) * Last activity: [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-vs-ms-sql/#post-251372) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics