asked on

Pros and Cons of SQL SERVER vs MySQL...which should I choose?

I am developing a couple of projects that will be using a backend database. Without the cost/free argument, what are the pros and cons of SQL SERVER vs MySQL? I'm familiar with SQL Server, so I naturally lean towards that, but I want to be able to make the best decision between ASP and PHP (different thread!)...I basically want to know the goods and bads of each.

Would major companies rely on MySQL considering the opensouce roots? Is it reliable?

Thanks!
Kevin

ASKER CERTIFIED SOLUTION

TNetworks

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

David Todd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TNetworks

Yes, I had a go with that, quite a good deal of functionality. No Web Service endpoint support though.
I think the Standard edition costs around $2000. Not too prohibitive if it's a larger project but still enough to make one think twice.

The availability of the Express version, royalty free was a very good move by Microsoft.

Cheers.

Kevin Smith

ASKER

Thanks for the in depth response TN! I think you may have confirmed my ideas and will feel a little more confident presenting my suggestion to my client. I'm actually gonna throw a couple of points towards dtodd for participating.

Thanks, and happy Thanksgiving!
Kevin

David Todd

Hi Kevin,

Thanks for the points.

Cheers
David

jabcoco

Keep in mind that SQL Express is Free but have a 4gig limit capacity