SQL Server Alternative

by Jorge R
The main focus of my article is to explain the advantages from moving from SQL Server to MYSQL. The author starts by stating that he worked as a SQL Server DBA, and at the time there was no other program that matched Microsoft’s user friendly interface. As timed progressed he found MYSQL to be a database that could match SQL Server ease of use, reliability and performance. One of the benefits of using MYSQL is the running the program in a multitude of operating systems, with low computer resources and hardrive space. Another advantage of using MSQL is the use of storage engines. This allows the DBA to have a flexibility to have transactional tables, main memory, and compressed data. A point expressed by the article is the companies using MYSQL such as Google, Yahoo, and Facebook. Their performance and scalability is above and beyond their competitors. There are wide arrays of monitoring and tuning tools packed into MYSQL; they are trying to make their products as user friendly to use. The article states that there are multiple ways to transition into MYSQL. A method is to use a program made to convert SQL Server data into MYSQL data.  One of the most attractive features of MYSQL is the low costs.

This was a very interesting article explaining the difference between SQL Server and MYSQL. It is good to know the different alternatives out there.  The author does a good job trying to be neutral when evaluating the pros and cons of each system. This article relates to the class by going over multiple database systems. We as students need to evaluate our choices and be diverse in our knowledge.  I can see why businesses would choose MYSQL over SQL Server. They both have different options to offer, but MYSQL is chosen by most based on their performance and low costs.

References

Schumacher, R. (n.d.). MySQL ::  Why Move to MySQL from Microsoft SQL Server?. MySQL Cluster 7.2. Retrieved February 19, 2012, from http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html

5 thoughts on “SQL Server Alternative”

  1. Nice article! We are starting to learn to use Microsoft's SQL server, and based on what the article says it seems like MySQL is a better choice than SQL Server. And I remember reading an article before that said MySQL cost less than SQL server. Hopefully we will get to learn a bit about MySQL in class.

  2. This was an interesting article. I also do agree with you about knowing the different kinds of alternatives that are out there. It is also cool how the SQL language is pretty much similar and can be used on almost any type of application such as MYSQL and Microsoft Server but of course I am sure that there will be a few differences with the data types and the way it performs. I too would like to see how MYSQL works and what the major differences are between them.

  3. Great article. I didn't know that MYSQL is so powerful. It is good to know that MYSQL can run multitude operating system. Thank you for posting this article.

  4. I agree, this was an interesting. It's nice to know that there can be alternatives available to users. I didn't really know what was the difference between SQL Server and MYSQL, but this article explained a lot. MYSQL does sound like a good alternative to SQL Server, and the lower cost is always a plus 🙂

  5. great article! I actually did not know what was the difference between SQL and MYSQL server. I was going to do some research on that but your article made it easy for me lol thanks for that, and thanks for sharing. Once again great article!

Comments are closed.