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.
"The solution is great for small applications in particular."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things."
"The fact that it is free is what appeals to me the most."
"The most valuable feature is the ease of use."
"The solution is easy to use."
"MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better."
"Similar to Microsoft SQL, it is easy to scale."
"A big advantage is the ability to store any type of data in SQL Server."
"It is stable, and it works okay."
"The solution offers very high performance."
"SQL Server is a stable product."
"We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use."
"The tool helps us by being available always."
"The GUI could improve in MySQL."
"The analytics features are in need of improvement."
"If the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business."
"Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"MySQL's performance requires attention. For optimal performance, one should review and sometimes revise the code, particularly when using server-side scripting."
"Could use some additional JSON query support in the solution."
"MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."
"SQL Server could improve the integration with nonrational database solutions, such as MongoDB."
"Scalability of the database could be improved if it could handle increased volumes of data."
"CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server."
"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."
"The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on."
"Performance could be better. But I don't know if it's a problem with my application or with my database."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"Query optimitzer could be simplified."
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.