|| Mysql is Available for free. Mysql is an open source.
|| Sql Server is not open source payment has to be made fro use of sql server.
|| Mysql offers only updateable view
|| Sql Server offfers indexed view which are much more powerful performance wise.
|| Mysql doesnot support XML.
|| Sql server supports XML.
|| User defined function are not supported in MySql.
|| User defined functions are supported in Sql server.
|| Mysql provide only table level security.
|| Sql server provide column level security.
|| Mysql doesnot for offer any security certification.
|| Sql server has C2 compliant certification.Database security verified by third party.
|| Earlier versions of Mysql doesnot support triggers. Only Mysql 5.0 supports triggers.
|| Sql server provides trigger.
|| Cursor feature not available in MYsql.
|| Cursor features available in Sql server.
|| Stored procedures and full join facility is not offered in Mysql.
||Stored procedures and full join facility offered in sql.
|| Import and export functions have very limited support in Mysql.
|| Import and export functions have extensively support in Sql server.
|| Transaction support is very limited in Mysql.
|| Transaction support is extensively and fully offered in Sql Server.
|| Job scheduling and profiling are nor available in mysql.
||Job scheduling and profiling are available sql server.