MySql vs SQL Server

[terreri]

Hi there,

What is the best tool: mySql or MS SQL? Why?
Thanks!

[jlknauff]

You can accomplish the same with either, it's a matter of your server OS. MySQL is for Linux & MSSQL is for Windows.

[ixpleo]

There's a good article here (http://swik.net/MySQL/MySQL+vs+MS+SQL+Server)

What are you developing? MySQL should fit your requirements. It can hold millions of records, it's fast, open source, and free. Plus if you're not managing your own server, MySQL hosting is cheap. Can't beat that!

[terreri]

Thanks for your help. The article was really good.

We already have a website using MS SQL. The application we are developing will have the basic db operations (read, write, delete), joins (I could not find anything on JOIN on the article, is this still an issue with MySql?), views and a couple of transactions. No triggers or stored procedures for now. And we are going to add a shopping cart (not sure if Miva or OsCommerce).

[BSolveIT]

SQL Server is much more powerful than MySQL, in many ways.
But, its probably overkill for the average person wanting to build/run a website.

By the sounds of what your planning to do, almost any database type would be fine - including MS Access.

:D

[web10]

SQL Server is my fave server to use when Im coding asp.net
But mysql is alot easier and lighter and well ... free :D

[BSolveIT]

I thought I would add, that if your application is going to make use of XML or AJAX, MS SQL Server is likely to be a better option. mySQL has no support for XML.

[pietpaulusma]

Mysql is faster
SqlServer is easier
Sqlserver is more expensive :-)

If money is a factor choose Mysql, for sure...

What about Oracle ? :-)

----
What What When (http://www.whatwherewhen.nl)

[BSolveIT]

SQL Server is much faster than MySQL, but it depends on whether or not you know what your doing in order to optimise yours pages, tables and indexes - and even your queries.

SQL Server 2005 Express edition is FREE.