We performed a comparison between MYSQL and SQL Server based on our users’ reviews in four categories. After reading the collected data, you can find our conclusion below.
Comparison Results: SQL Server comes out ahead in this comparison because it is less demanding on resources and can more easily be integrated with other solutions. Some users feel that MySQL requires more maintenance and can be a bit buggy and less stable than SQL Server.
"It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do."
"We are completely comfortable with the database’s performance and it is a mature product. My organization was looking for an open-source database for our smaller customers like the community edition. For bigger customers, we can scale into commercial and supported editions."
"Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
"The most valuable features are that it's free and the documentation is good."
"SKIP LOCKED is a valuable feature."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it."
"The tool is open-source and there is no cost involved in its use."
"SQL Server Profiler makes finding and debugging easy."
"The support from Microsoft has been good."
"The solution has proven to be very stable."
"As a data warehouse and storage solution, it's quite good."
"The initial setup was straightforward."
"I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it. You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers."
"SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful."
"For me, the initial setup is very easy as I have years of experience with the product."
"I would like to have the ability to cancel a query in SQL Developer."
"It requires a training platform."
"MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features."
"The manuals or documentation could be better."
"We want to continue using MySQL but it merged with Oracle and the scalage changed."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"The solution could be more secure."
"Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."
"The pricing of the product could be better."
"The integration could be better. They are not open-source, so the integration with other platforms is not that easy."
"The solution could be more secure."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"More things in SQL Server need to be automated."
"SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. MySQL is rated 8.2, while SQL Server is rated 8.4. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and Oracle Database, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and Vertica. See our MySQL vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.