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.
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