United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
Microsoft SQL Server 2008 outperforms MySQL as an enterprise database platform for all the enterprise capabilities, while providing the largest developer and partner ecosystem, less security risks and 10x less product vulnerabilities.
SQL Server #1 database most widely adopted database, more than Oracle and SQL Server combined, according to IDC. There are 30 times more partner solutions on SQL Server than on MySQL: 15,000 ISVs support SQL Server, fewer than 400 ISVs are mentioned in MySQL site. SQL Server has more than 1,000 engineers working on SQL Server, compared to less than 100 in MySQL before their acquisition by Sun.
SQL Server has been proven for the most demanding applications in the planet, through benchmarks like SAP Sales & Distribution (93,000 concurrent users: 10x largest customer in the planet), the #1 price/performance 10TB TPC-H benchmark, and production Data Warehouses of more than 400TB. The industry standard databases test the database in realistic, complex, and demanding workloads; MySQL has no industry standard benchmarks and can currently address only 4 CPUs/cores vs 256 for SQL Server. SQL Server provides scale out, scale up, failover technologies, disaster recovery, parallel online operations, and many other capabilities required for large complex deployments.
SQL Server provides capabilities for solutions that require the highest availability and security, and need capabilities like mirroring to simplify failover, transparent data encryption to secure all data with no application changes, external hardware key management for advanced security, and online CPU changes with no downtime. MySQL has none of these capabilities.
Design and deliver reports of existing data, mine millions of rows to find trends, and move data from applications like SAP or excel sheets to a data warehouse with no development – all this is integrated out of the box with SQL Server. MySQL does not have any Business Intelligence capabilities.
SQL Server has had less than 10 vulnerabilities according tothe third party National Vulnerability Database. MySQL has had more than 70 vulnerabilities. Third party Security Innovations found that SQL Server on Windows is more secure than MySQL on Linux, with 46% fewer vulnerabilities and 48% fewer days of risk. ESG reported that SQL Server is “years ahead” than MySQL, which had more vulnerabilities than Microsoft SQL Server, Sybase, and IBM DB2. SQL Server is C2-certified and Common Criteria-certified, which ensures adequate coverage of government requirements. SQLServer is integrated with Microsoft Update for security updates. MySQL has no automatic update patching, has no C2 or CC certifications.
SQL Server includes compression, which reduces disk space from 30% to 70%, thus reducing storage and backup costs – MySQL does not have this capability. SQL Server has advanced management capabilities, like policy based management to manage hundreds of servers centrally, auto tuning to minimize DBA time spent on tuning, and has the user-friendly SQL Server Management Studio -- MySQL has none of these. In a typical scenario, SQL Server Standard could cost US$12K*, versus MySQL Gold Edition US$9K for three years – though MySQL has no enterprise capabilities, no reporting, no analysis, no ETL, higher security risk, lower scalability, and far less commercial applications available.
Online Postal Mail Service Saves $750,000 with Move from Linux/MySQL to Windows/.NET/SQL Server
Event Management firm chooses SQL Server over Linux and MySQL
MySQL
