SQL Server vrs MySQL

Question

SQL Server vrs MySQL

j mangual

Ten Centuries

Points: 1197
More actions
June 20, 2007 at 8:16 pm

#124508

One employee thru our employee suggestion program submitted an entry indicating that we could potentailly save several thousands of dollars if we switch to MySQL instead of using SQL Server. Now I have to submitted a writing document for upper management about both products etc etc.
Im pretty sure that someone else out there has been in the same position I'm facing now. Any articles or site that could assist us for the above writing is greatly appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

Sure the company would have hundred thousand dollars if they use MySQL as its a opensource database. But i don't think so that MySQL has all the features and support that SQL Server has. Just google out to find the difference between both. Some sites are given below.

http://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htm

http://www.tometasoftware.com/mysql_vs_sqlserver.asp

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 2

And, they would have to rewrite any existing code because the many of the advanced SQL Extensions in both are different... SQL is NOT SQL

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 3

Here's a couple of other things from a more recent article that compares MySQL 5 against SQL Server... these things are crucial, in my book, and favor SQL Server... a LOT!

Another important consideration is security certificates - the verification of the database security by a third party. SQL Server has been certified as C-2 compliant, which means the database system has adequate security for government applications. MySQL has no such certification.

SQL Server is more failsafe and less prone to data corruption. SQL has a robust checkpoint mechanism whereby the data passes from the keyboard to the hard drive before showing in the monitor. Even if the databases shut down unexpectedly without warning, the data can be recovered.

From a database developer’s perspective, choosing between a MySQL and SQL Server DBMS is a matter of the scale of the database application. For enterprise-level applications, SQL Server wins hands down. It has advanced set of SQL features, superior replication, clustering, security and management tools.

For lower-tier database applications, MySQL can offer the core functionality you require at a very low cost. Some might argue that the latest offering from MySQL has made the open source database system enterprise “worthy”, but this remains to be seen. The advanced functionalities implemented are yet to stabilise and be rationalised across the database engine. What's more, Microsoft has upped the ante with even more advanced features of its own. It’s up to MySQL to rise up to the challenge, but at this point in time MySQL is nowhere near the competitive enterprise field of the more established SQL Server 2005.

Here's the link I got the above from...

http://www.tometasoftware.com/MySQL-5-vs-Microsoft-SQL-Server-2005.asp

The Google search I used was "SQL Server 2000 vs MySQL "

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 4

Here's a few more links from the Google search...

http://www.vesigo.com/SQLServer/DatabaseServerComparison.aspx

http://www.promoteware.com/Module/Article/ArticleView.aspx?id=23

http://builder.com.com/5100-6388-1054385.html

http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1211452,00.html

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)