The below are the few point about differences between MY SQL and SQL Server
1. MySQL is an open source and now its owned by ORACLE where as SQL Server is not open source and payment has to be made to Microsoft to use SQL Server .
2. MySQL doesn't support XML data type where as SQL Server supports XML .
3. MySQL supports only table level security where as SQL Server supports table level ,column level and row level (from SQL Server 2014 ) .
4. MySQL supports triggers from 5.0 version on wards only where as SQL Server supports triggers from beginning versions itself.
5. Transaction Support, Replication Support and online backup support is very limited in MySQL
6. Auto Tuning is not supported in MySQL .
7. Log Shipping , Clustering and Mirroring are not available in MySQL .
8. Reporting and OLAP services are not available from MySQL .
9. Job scheduling and profiling are not available in MySQL .
1. MySQL is an open source and now its owned by ORACLE where as SQL Server is not open source and payment has to be made to Microsoft to use SQL Server .
2. MySQL doesn't support XML data type where as SQL Server supports XML .
3. MySQL supports only table level security where as SQL Server supports table level ,column level and row level (from SQL Server 2014 ) .
4. MySQL supports triggers from 5.0 version on wards only where as SQL Server supports triggers from beginning versions itself.
5. Transaction Support, Replication Support and online backup support is very limited in MySQL
6. Auto Tuning is not supported in MySQL .
7. Log Shipping , Clustering and Mirroring are not available in MySQL .
8. Reporting and OLAP services are not available from MySQL .
9. Job scheduling and profiling are not available in MySQL .
Awesome
ReplyDeleteThank you Vidhya.
ReplyDelete