Sql Server

Problem

Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?

Solution

In my modest opinion there is not a simple answer to this question, because we are not comparing apples to apples. Microsoft SQL Server is a feature rich database compared to MySQL however; MySQL's goal is not to keep up with MSSQL or Oracle instead; MySQL’s priorities are: reliability, performance, and ease of use.

So, in my opinion, the answer to the question “Is SQL Server superior to MySQL or not” is: it depends. It depends on the kind of application, environment and budget we have to work with.

Do you plan on upgrading to Microsoft SQL Server 2008? Well, this has certainly been a hot topic for our readers. We’ve had an overwhelming response to an editorial and commentary on this subject. In fact, we’ve devoted an entire page in the October issue to give you an idea of where our readers stand. But, like every opinion, there is always another opinion that has merit and is worth considering. In response to “Too Soon for SQL Server 2008”, one of our regular forum posters and SQL Magazine reader, Kalman Toth, sent us his opinion on why he’s taking a serious look at SQL Server 2008. Kalman has been a regular contributor on our forums since 2005. His article follows:

<< Start < Prev 1 2 Next > End >>

Page 2 of 2