MySQL vs Microsoft SQL

[General Apocalypse]

Which one is better and why ?

Constructive posts welcomed

 

[wh00p101]

Personally I find MySQL to be better. Because it's Open Source. I'm a great support of open source software. It's free. Unless you want go to for the enterprice edition and even then it's still greatly cheaper than MS SQL. It's the most widely supported out of the two.
But that's just my opinion.

Chris

 

[Derek]

I think Microsoft SQL is faster or something thats what I've heard.

 

[nightscream]

there isn't much diffrents.. But i would go for mysql because the most websites are using apache and mysql so you will find more coders and more scripts for it.

 

[jptosso]

i think that mysql is better, its easier to make php interact with him, easy to managge the console, full of interesting stuffs, its everythink that i need

 

[shauntp]

Definitely MySQL. It is the most supported, and is open-source.

 

[eminemix]

I learn Microsoft SQL at school but i prefer MySql cause i can get more help on the net with it.

 

[Slothie]

MsSQL for stored procedures

Really depends on what you're trying to do. MsSQL Works best with asp.net whereas MySQL works great with php.

I prefer Oracle as a whole, seconded by DB2 and firebird.

 

[jptosso]

but asp only works with windows ¿?

 

[Micro]

jptosso -- Mono
Edit:
Forgot, MySQL

I even use it with VB.NET + PHP

 

[Laos101]

Well, This is a bit confusing of a question

each are used in databases etc. However, MySQL is far more popular and used in many MMORPGs, and webservers. MSSQL is closed source and thus less open to people,

Its not a factor of whos better, its a factor of who uses them

 

[Sohail]

I would have to say that MySQL is the best option. I have had experience with both flavours and it is not only more popular, but its easy to work with, supported by many webhosting services and it simply has more features so there you go.

 

[munim]

MySQL.. it is free and powerful! If you have your server, you have to pay to install any windows server OS. You can have a complete linux server setup (Linux, Apache, MySQL, PHP) for free.
I just read a report on what large websites use at the backend to power their websites (some site called high scalability). It seems most of them use MySQL as the database server.

 

[satheesh]

My vote for MYSQl.
It is good database.

 

[osgcity]

MySQL came, MySQL saw, MySQL kicked Microsoft

 

[DarkDragonLord]

when i saw 'microsoft' sql, i already knew the other will win lol


but anyways, mySQL rule over all, its opensource ^_^

 

[Avalanche]

Well, there is not a definite 'best' but rather which suits your needs.

Eventhough I would have to say MySQL all the way, why? Cross-platform... And also the fact that administration interfaces like phpMyAdmin work through a normal browser.

I dont see a real advantage for MsSQL over MySQL, I would dare to say that MsSQL is slower sometimes. MsSQL's strength lies within the tight integration into MS dev environments and the DB driver models.

So yeah, as long as you're going php, MySQL and you wont have to worry about which platform it may run on.