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's a good tool, a good database platform."
"For sure, the solution is very stable."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
"It is easy to use. It is simple to implement, which makes it suitable for our projects because we have deadlines. MySQL is also open-source, which is another plus point."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"The product is flexible and easy to use."
"This product is a good teaching tool for students who want to learn about networked databases."
"It is a stable product, and it runs seamlessly. It is not complex."
"It's a flexible solution."
"It is an extremely stable solution."
"It is easy to use and very stable."
"There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request."
"It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"For my business requirements, the performance is good."
"The product's initial setup phase was simple."
"Clusters are hard to perform so we use no SQL alternates like MongoDB."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"It could be more secure."
"We want to continue using MySQL but it merged with Oracle and the scalage changed."
"We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."
"Some problems with big table operations, and a struggle to keep the servers responding in peak situations."
"MySQL could introduce more indexing strategies."
"The documentation is pretty weak and should be improved."
"Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit."
"Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."
"Additional interfaces would be an improvement."
"Linux-based editions are not yet proven to be on par with Windows deployments."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"SQL Server could improve by increase the performance, it cannot handle large amounts of data. I did not find any additional features compared to others solutions."
"SQL Server has good performance, but it could be better."
"The security features of the solution could be better."
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while SQL Server is ranked 1st in Relational Databases Tools with 259 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.