Try our new research platform with insights from 80,000+ expert users

MySQL vs SQL Server comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

MySQL
Ranking in Relational Databases Tools
3rd
Average Rating
8.2
Reviews Sentiment
7.4
Number of Reviews
148
Ranking in other categories
Open Source Databases (1st)
SQL Server
Ranking in Relational Databases Tools
1st
Average Rating
8.4
Reviews Sentiment
6.8
Number of Reviews
268
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Relational Databases Tools category, the mindshare of MySQL is 8.5%, down from 8.8% compared to the previous year. The mindshare of SQL Server is 18.6%, down from 23.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Muzzamil  Hussain - PeerSpot reviewer
Native encryption ensures secure data management with a simple deployment
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.
Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The speed is very good."
"It's a good tool, a good database platform."
"What I really like about MySQL is the opportunity to search for information and organize it any way I like."
"MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand."
"Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
"However, it is easy to scale MySQL using the functions provided with the product."
"The solution is very stable."
"The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"It is stable, and it works okay."
"Comparing with other database management systems that I tried in other companies, SQL Server is quite easy to install, configure, and maintain."
"The Azure SQL Server database requires almost zero maintenance and management."
"It is an extremely stable solution."
"It's a very stable solution."
"It is a stable product, and it runs seamlessly. It is not complex."
 

Cons

"Clusters are hard to perform so we use no SQL alternates like MongoDB."
"It could be a little bit simpler to use."
"It could be more secure."
"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 could be improved by adding more automation."
"When I run into issues, I really have to research how to fix them."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."
"SQL Server is an expensive solution"
"Technical support could be better."
"The treatment of database storage could be improved."
"There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
"The solution could offer better integration with other solutions - specifically Microsoft."
"The solution is expensive. The licensing costs are high."
"The tool is expensive."
 

Pricing and Cost Advice

"MySQL is a free and open-source solution."
"It is an open source platform."
"MySQL is a cheap solution."
"The price of the solution is good because we have a good partner."
"The pricing falls within the moderate range."
"I don't pay for a license."
"We do have a couple of clients who choose to use the paid, enterprise version of the solution and who take full advantage of it."
"This is an open-source product that can be used free of charge."
"We're looking at alternative solutions because we think Microsoft's licensing costs have been expensive."
"The price of the solution could be cheaper."
"I would rate the tool's pricing a six out of ten. It is not extremely cheap but also it's not the most expensive product."
"The price of SQL Server could be reduced, the license is expensive. We have an annual subscription."
"For smaller companies, they find this solution expensive."
"We are on a monthly subscription and the price could improve. However, the price has worked out well in some deployments. The problem is you never know what kind of services been installed and you have to be in touch with many people, such as which servers are active or which are not. I did face a couple of issues in terms of subscriptions and the pricing model. They have improved over time."
"The price of SQL Server could be better in the African market. The licensing model needs to be improved, it is confusing."
"There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
842,767 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
7%
Government
6%
Educational Organization
53%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about MySQL vs. SQL Server and other solutions. Updated: March 2025.
842,767 professionals have used our research since 2012.