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

"I am totally satisfied with MySQL."
"MySQL is easy to integrate. It works with just about every language."
"The product is flexible and easy to use."
"The most valuable features are that it's free and the documentation is good."
"What I've been most pleased with is the cost point, performance, and ease of use."
"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."
"SKIP LOCKED is a valuable feature."
"​We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications.​"
"SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm."
"The product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"Managing database is very good."
"I have found SQL Server easy to use."
"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"It is a stable product, and it runs seamlessly. It is not complex."
"A big advantage is the ability to store any type of data in SQL Server."
"SQL Server is a very mature solution."
 

Cons

"In MySQL, we need to define every table beforehand."
"The tool needs to improve table visualization."
"On the database side, it should be really lightweight, and the data structure should be like MongoDB."
"As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
"The licensing of the solution is on the expensive side."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"The performance issues in the product can be considered as an area where improvements are required."
"MySQL could introduce more indexing strategies."
"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."
"The performance could improve."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
"The tool is expensive."
"Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits."
"The solution is lacking a compound index for comparing values."
"I would like to see better integration between their link server and other platforms, such as IBM."
"The configuration process can be a little complex."
 

Pricing and Cost Advice

"There is a license needed for this solution."
"We are using the free version of MySQL. We prefer paying for a yearly license."
"We are using the free community edition of MySQL."
"It is an open source platform."
"I am not paying, but I am not sure about the exact licensing requirements."
"Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference."
"The solution is open source so is free."
"MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there are many smaller agencies out there that will readily provide support. You’ll need to spend some time looking around."
"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."
"On a scale of one to ten, when one is cheap and ten is an expensive solution, I rate the product price as seven. The product is expensive."
"There is a license required for the use of SQL Server and we are on an annual subscription."
"For smaller companies, they find this solution expensive."
"With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
"The price of the solution could be cheaper."
"For medium-sized customers who don't need some enterprise features, the tool would be available for 200 USD per month. For the enterprise segment, the tool's cost can go up to 6,000 USD."
"As compared to Oracle Database, SQL Server is less expensive. For mid-sized organizations, SQL Server is completely all right, but people say it can't support large organizations with more than 2,000 users."
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.