What is the difference between MySQL and SQL Server?

MySQL and SQL Server are the two leading databases that support front end applications related to various domains. The differences between MySQL and SQL Server are listed below:

MySQL

SQL Server

MySQL is available for free since MySQL is an open source.

SQL Server is not an open source and payment has to be made to use SQL Server.

MySQL offers only updateable views.

SQL Server offers indexed views which are much more powerful, performance wise.

MySQL does not support XML.

SQL Server supports XML.

MySQL provides only table level security.

SQL Server provides column level security.

MySQL does not offer any certification for security.

SQL Server has C2 compliant certification. Database security is verified by third party.

Earlier versionsof MySQL does not support triggers. Only MySQL 5.0 supports triggers.

SQL Server provides triggers.

User defined functions are not supported in MySQL.

User defined functions are supported in SQL Server.

Cursor feature is not available in MySQL.

Cursor feature is available in SQL Server.

Stored procedures and full join facility is not offered in MySQL.

Stored procedures and full join facility are offered in SQL Server.

Import and Export functions have very limited support in MySQL.

Import and export are extensively supported in MySQL.

Transaction support is very much limited in MySQL.

Transaction support is extensively and fully offered in SQL Server.

Replication support is very much limited in MySQL.

Replication support is extensively and fully offered in SQL Server.

Auto tuning is not supported in MySQL.

Auto tuning is supported in SQL Server.

Job scheduling and profiling are not available in MySQL.

Job scheduling and profiling are available in MySQL.

Online backup support and clustering support is limited in MySQL.

Online backup support and clustering support is extensive and complete in SQL Server.

Log Shipping and Storage Area Network support is not available in MySQL.

Log Shipping and Storage Area Network support is available in SQL Server.

OLAP Services, Data Reporting and Data Mining are not supported in MySQL.

OLAP Services, Data Reporting and Data Mining are supported in SQL Server.