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 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."
"I like MySQL because of its community."
"It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"However, it is easy to scale MySQL using the functions provided with the product."
"This product is a good teaching tool for students who want to learn about networked databases."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties."
"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"The most valuable features are programmability and reliability."
"I would say that it is a stable product."
"The solution is stable."
"SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based."
"Easy to implement and user-friendly relational database management system. This product is stable and scalable."
"This solution is user-friendly and easy to understand."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
"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."
"The analytics features are in need of improvement."
"The full-text search feature must be improved."
"The manuals or documentation could be better."
"I would like to see the automatic backup feature in the solution as well. Data is very important and we need to preserve it in a safe place. It would be good if MySQL can back up the data automatically."
"It should have some code analytical functions. It can also have a monitoring tool."
"They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
"I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage."
"The performance could be better."
"Support could be improved."
"SQL Server backups could be better."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"I would like to see more integration with other platforms."
"Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities."
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.