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.
"A good traditional database that supports JSON."
"It is pretty simple to use and I don't have anything really bad to say about it."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"The solution is very stable."
"The solution is very simple. It's easy to use. That's the most important feature."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"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."
"What I've been most pleased with is the cost point, performance, and ease of use."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups."
"I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks."
"SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
"It is integrated with Microsoft tools."
"The most valuable features of SQL Server are the speed, great support, and it is from a known vendor."
"I have found that SQL Server works very well in the Microsoft Dynamics environment."
"It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
"MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."
"I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."
"MySQL could be improved by adding more automation."
"At times, the autoscaling does not happen when there is a surge in load."
"There should be more tools to manage the on-premises version and more automation features."
"In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be."
"We want to continue using MySQL but it merged with Oracle and the scalage changed."
"On the database side, it should be really lightweight, and the data structure should be like MongoDB."
"The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster."
"SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."
"The solution is lacking a compound index for comparing values."
"When transferring data from the SQL Server to Excel, the data types are not copied correctly. This issue might be associated with the formatting of the data types."
"I would like to have more replication scenarios."
"Maintenance of the solution is an area of concern, and improvements can be helpful."
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.