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.
"MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
"It's a good tool, a good database platform."
"MySQL gives us a very user-friendly workspace in which to query the database."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"The most valuable feature of MySQL is the informative error outputs of command line interface."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable."
"The solution seems to be pretty flexible."
"Features like autoscaling, business continuity, and security are beneficial. The tool's compatibility with almost all of the enterprise-class applications is also beneficial for users."
"If you need to, you can scale the solution very easily."
"The solution is very intuitive and easy to use."
"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."
"It is stable, and it works okay."
"It could be a little bit simpler to use."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"The documentation is pretty weak and should be improved."
"Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."
"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."
"MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."
"Security is a concern. MySQL could have better security features."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"The tool is expensive."
"The tool's support needs to be improved."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"The solution's stability can be improved."
"SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."
"Microsoft support is an issue unto itself."
"It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."
"SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."
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.