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.
"I like the JSON stuff."
"The connectivity with PHP is quite good."
"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."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"The relations in the database, the dynamic workflow, and the ability to connect with all columns. It's useful for e-commerce."
"While MySQL offers strong basic functionality."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"The replication feature is the most valuable. We are replicating our servers."
"The most valuable features of SQL Server are the speed, great support, and it is from a known vendor."
"The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables."
"The Always On tool improves the SQL server availability."
"I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome."
"The most valuable features are programmability and reliability."
"The ease of administration, in general, is the solution's most valuable aspect."
"It integrates well with other platforms."
"The solution seems to be pretty flexible."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."
"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"The technical support should be more knowledgeable and available worldwide."
"MySQL is not easily scalable on cost effective consumer grade hardware."
"The solution is expensive."
"Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."
"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."
"You do need to have technical knowledge in order to install the solution. It's not something a layperson can do."
"From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week."
"Improvement in SQL Server should focus on lowering the high cost, especially for environments requiring extensive CPU and memory usage like data warehousing"
"The remote access aspect needs to be improved in terms of security."
"Maintenance of the solution is an area of concern, and improvements can be helpful."
"Their support could be better. There should be more visibility on the progress of the ticket, and their last line of support should be more knowledgeable. Other than that, we have nothing to complain about."
"The free version of SQL Server is time-limited before updating to the paid version."
"The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient. It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages."
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.