MYSQL & SQL Difference Between SQL Server And MYSQL.

Difference between MySQL and SQL Server

My SQL:-

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

*MySQL offers only updateable views.

*MySQL does not support XML.

*MySQL provides only table level security.

*MySQL does not offer any certification for security.

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

*User defined functions are not supported in MySQL.

*Cursor feature is not available in MySQL.

*Transaction support is very much limited in MySQL.

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

*Import and Export functions have very limited support in MySQL

*Log Shipping and Storage Area Network support

is not available in MySQL.

*Online backup support and clustering support is limited in MySQL.

SQL Server:-

*SQL Server is not an open source and payment has to be made to use SQL Server.
*SQL Server offers indexed views which are much more powerful, performance wise.
*SQL Server supports XML.
*SQL Server provides column level security.
*SQL Server has C2 compliant certification. Database
security is verified by third party.
*SQL Server provides triggers.
*User defined functions are supported in SQL Server.
*Cursor feature is available in SQL Server.
*Stored procedures and full join facility are offeredin SQL Server.
*Transaction support is extensively and fully offered in SQL Server
*Auto tuning is supported in SQL Server.
*Job scheduling and profiling are available in MySQL.
*Online backup support and clustering support is extensive and complete in SQL Server.
*Log Shipping and Storage Area Network support is available in SQL Server.