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.
"The feature I found most valuable is activity performance."
"When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance."
"It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"I use MySQL for employee service in an OLTP database."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"Table partitioning is most valuable. It is easy to use."
"This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
"can extract data from the server and store it in a local data source for BI purposes."
"The features that we have found the most valuable are reliability, availability perspective, and current scalability."
"Excel integration is one of its most valuable features."
"The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases."
"SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
"It's a very stable solution."
"You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
"What I like most is the management, as it is very easy compared with other products."
"The interface could be improved."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"At times, the autoscaling does not happen when there is a surge in load."
"As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
"It should have some code analytical functions. It can also have a monitoring tool."
"There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."
"MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."
"When I run into issues, I really have to research how to fix them."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
"There is room for improvement in performance when managing a large quality of data and a high number of active users."
"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."
"The GUI needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening."
"Security is an issue."
"I would like to see more integration with other platforms."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"The solution could be better when it comes to security."
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.