What is the advantages and disadvantages of using MySQL instead if SQL Server?

Posted on 2009-12-22
Last Modified: 2013-11-08
What is the advantages and disadvantages of using MySQL instead if SQL Server?  If a specific software recommends SQL Server, what would be the disadvantage of using MYSQL instead?
Question by:yaknour
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran

    Accepted Solution

    Under the General Public License, MySQL is an open source system. Without spending any amount, a developer can start working with this system. But a person needs to buy a commercial license if he wants to sell the software. But the case is bit different for MS SQL. A developer has to secure a license. For simple development purpose, a free SQL server is given. But if one wishes to use it for commercial purpose, then he has to purchase at least the Standard Edition of SQL server.

    The MS SQL is a closed source compared to MySQL. The latter is available as an open-source and is thus easily accessible. For the MS SQL, one is limited within the Sybase-derived engine. But MySQL offers numerous variations like Heap, Berkeley DB, MyISAM, InnoDB etc.

    If the two systems are compared on the basis of their performance, then it will be seen that MySQL surely has more advantages. It takes a very less storage space in the disk and the MyISAM database gives remarkable performance. Besides Windows, this system also performs well on UNIX and LINUX systems. For MS SQL, its performance is comparatively complex. It is difficult to work with it without very sound knowledge and efficient hardware. Working with MS SQL takes up more disk space compared to MySQL.

    Compared to MS SQL, most of the foreign keys are not supported by MySQL. Some of the relational features found in MS SQL are missing in MySQL.

    If the two systems are considered on the basis of recovery process, then SQL has more benefits than MySQL. Since it has a configuration with MyISAM, it sometimes becomes a drawback for the system. If there is a disturbance or interruption takes place while working with MySQL, then it may result to loss of data. Even if the system faces any problem while working with MS SQL the data is not lost.

    Both MySQL and MS SQL adopt ample security measures from the very beginning. If a port becomes too vulnerable to use then the user is allowed to change it. The user is required to update the software from time to time to protect them from unwanted users and intruders
    LVL 14

    Assisted Solution

    Using rkpanidarapu's very excellent comparison of the two databases, it sounds like a no-brainer to me in favor of MS SQL, when you compare only the most important features:
    1. As for storage space, who cares? As big and cheap as hard drives are today, database size isn't a big concern.
    2. MS SQL might be more difficult to work with, but I believe it is the more popular and used database, and a wealth of info exists out there to solve any problem you'd run into.
    But now for the BIG reasons:
    3. Most foreign keys and some relational features are not available in MySQL.
    4. The "recovery process" issue in his next-to-last paragraph puts the nail in the coffin for  me...a disturbance or interruption will cause MySQL to lose data, whereas MS SQL will not. Do you want to EVER lose data? I rest my case.
    About the licensing issue, we use MS SQL Express, which is free to both us and our customers. No money needed.
    LVL 22

    Expert Comment

    One significant correction to the two previous answers. MySQL DOES support foreign keys when the InnoDB engine is used.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now