Difference between MYSQL and MS SQL?

[witly]

Hey, is there anyone could tell us your conclusion of the difference between MYSQL and MS SQL on Dedicated Web Server ?
Both Technical and non-technical will be ok.
Many thanks.

[sainsalex]

Technical - As of versions 4.x MySQL does not support views, triggers, stored procedures, user defined functions, XML, while all these are suported by MS SQL
Non Technical - MS SQL is an expensive (*relatively*) proprietory RDBMS developed & owned by Microsoft Corporation while MySql is an open source RDBMS developed & maintained by MySQL AB of sweden with free as well as paid enterprise versions available.

[sam]

I would say probably most high-traffic sites on the internet use MySQL and are quite successful with it.

[robocop]

Well, i dont think that there is any connection with traffic in this case

[taslayer]

mysql=nix
mssql=windows
case closed

[Lazlo90]

Yeah MSSQL is mainly for Windows based apps. for PHP open source scripts I'd recommend sticking with MySQL as it'll be much easier to get help if something goes wrong as most people are familiar with that set up instead.

I personally haven't really toyed around too much with MSSQL so I can't really evaluate it, but for my needs I'll definitely say MySQL has gotten the job done.

[Joseph]

I agree with you Lezlo. Most of the applications are supported by MYSQL whereas MSSQL mostly supports Windows based applications only. If someone is looking for SQL database for an application which is not a Windows based application like PHP, HTML or any other, then I would suggest MYSQL as it is better for this purpose.

[Shane Phillips]

MySQL is free. However, MS SQL except MS SQL 2005 Express Advanced Edition have a license cost.