Is Microsoft SQL Server superior to MySQL or not?
Does MSSQL have any pros or cons that MySQL might not have?
There is not a simple answer to this type of questions. Both MySQL and MS SQL Server database technologies are ready and mature enough to be used in real world production environments.
At the core level, both have a lot in common. Choosing one over the other depends on the business needs, available budget and environment.
- MySQL was designed especially for small and medium web sites and it is very good at servicing these requirements. SQL Server is aimed at corporate markets was developed specifically for large enterprise databases. Advanced set of SQL features, superior replication, clustering, security and management tools are fully implemented for MSSQL.
- MySQL is open source software. In contrast, SQL Server is closed, proprietary storage engine. But MySQL openness does not mean free of charge in production. Usually, LINUX/UNIX maintenance & administration services cost more than WINDOWS ones. And, it is not enough to just acquire licenses.
Another key point of comparison is that MySQL is multi-platform, while SQL Server works on Windows OS only and probably there are no any plans to change that. So, if your applications built with .NET and work mainly on Windows platform, the obvious choice is MS SQL Server as back-end.
- From a database developer’s standpoint, choosing between a MySQL and SQL Server DBMS is a matter of database application scalability. SQL Server databases can be easily migrated to Microsoft SQL Azure servers with no hassle.