mysql vs ms sql server 1

[durug]

Hi everybody!

Could somebody explain me the difference between mysql server and MS sql server.

Thanks a lot.
Durug

 

[TomKane]

I think that there is a limit imposed on how big a mysql database can grow - smaller that it can on ms sql but I don't have any stats on it for you

 

[durug]

But from the programming point of view?

 

[BDC2]

The initial differences between them is:

MS SQL is a Microsoft product
MySQL is by their own admission "the world's most popular open source database"

MS SQL has a costly price tag
MySQL is free

MS SQL is a robust industry standard
MySQL is "recognized for its speed and reliability."

The optimum use for MySQL is use with PHP for web database applications, MS SQL is a much heavier option giving much scope for solution.
BDC.

 

[osjohnm]

durug

Have a look at the following thread where I pointed out some of the main differences between MySQL and SQL Server.

thread183-452364

There is also a link to a article in that thread that reviewed Oracle 9, SQL Server 2000, Sybase 12.5, DB2 and MySQL and compared them to each other.

Hope this helps

John

 

[durug]

Thanks all of you, especially John. I opened my eyes a little