Solved

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

Posted on 2007-11-20
6
2,534 Views
Last Modified: 2009-05-21
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
Comment
Question by:Kevin Smith
6 Comments
 

Accepted Solution

by:
TNetworks earned 475 total points
Comment Utility
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
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 25 total points
Comment Utility
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
 

Expert Comment

by:TNetworks
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:Kevin Smith
Comment Utility
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
 
LVL 35

Expert Comment

by:David Todd
Comment Utility
Hi Kevin,

Thanks for the points.

Cheers
  David
0
 
LVL 10

Expert Comment

by:jabcoco
Comment Utility
Keep in mind that SQL Express is Free but have a 4gig limit capacity
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now