• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2634
  • Last Modified:

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
0
Kevin Smith
Asked:
Kevin Smith
2 Solutions
 
TNetworksCommented:
MySQL is a very basic database server.  It depends on a heavier business layer for the manipulation and preparation of data for presentation. More of a data container than a functioning part of the application logic.

SQL server is an enterprise level database server that allows you to perform business layer functionality within the database server itself - compiled stored procedures, user functions, custom data types, analysis services, etc.  It allows a very thin client architecture because it can "take care of" a lot of the business layer aspects of an application.  

One of the reasons PHP is so "packed" with features is to make up for the lack of them in MySQL. They are almost always used as a "free" pair for simple web apps and compliment each other.

Don't get me wrong, if you're looking to make an online shop or store some simple data structures, or you have a Java (for example)  server dealing with applets for your data manipulation in the form of a thick business layer,  then it has its place for sure.

If you are looking to produce an enterprise level application with a cohesive, reusable design with data logic where it belongs - in the database - then I'd use MS-SQL or Oracle.  Performance is another aspect as well, but that depends a lot on hardware and bandwidth so an objective comparison is not possible on that topic I think.

that's my 2 cents.


0
 
David ToddSenior DBACommented:
Hi,

Don't forget that SQL Express edition is a _FREE_ download. That is, most of the functionality of SQL Server for a download.

HTH
  David
0
 
TNetworksCommented:
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.

0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Kevin SmithAuthor Commented:
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
0
 
David ToddSenior DBACommented:
Hi Kevin,

Thanks for the points.

Cheers
  David
0
 
jabcocoCommented:
Keep in mind that SQL Express is Free but have a 4gig limit capacity
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now