This blogs is designed for students OR beginners those are interested to know difference between MySQL and MS SQL. Please don’t make your decision of switching your database platform just after reading this blog rather my suggestion would be to do intensive research and testing in pre – production environment to confirm which technology best suite your business requirement.
MySQL, MSSQL, ORACLE and many more are RDBMS (Relational Database Management System) technology that uses SQL (Structured query language) for insert/update/delete/select rows from table. All above database technology extend their product with their unique feature on top of RDBMS technology. As per some extreme experts none of the above are true RDBMS system.
MySQL is an open-source relational database management system (RDBMS). The MySQL development project has made its source code available under the terms of the GNU General Public License. It was originally developed by Swedish company, MySQL AB, founded by ‘David Axmark’. The first release of MySQL came on 23 May 1995. MySQL AB was acquired by Sun Micro system in 2008 and Sun Micro subsequently acquired by ORACLE in 2010. The latest version of MySQL is 8.0.0-dmr (Milestone Release) was announced 12 September 2016
On the other side, MSSQL (Microsoft SQL) is developed by Microsoft. The first version of MS SQL was ‘SQL Server 1.0’, a 16-bit server for the OS/2 operating system in 1989. Most of the version so far was only designed to be install and operate from Windows OS, however the latest release ‘SQL 2016’ can be installed on Linux as well. MS SQL comes up with various different edition in which ‘express’ is free with certain limitation and web edition for test environment.
MS SQL is widely used by the companies operating in Bank, Finance & insurance sector as they need to have an assurance of compliance with laws and treaty’s and other legal requirements that open source software cannot provide.
MySQL may not be widely accepted by finance organization but some of the major internet players such as Facebook, google adworks, twitter & wordpress uses MySQL as RDBMS platform.
As I mentioned before, MySQL & MSSQL both are RDBMS system that uses SQL queries as standard way to perform database operation but still there are difference in the syntax both use. Such as one example below:-
---Select all columns of top 10 rows using MySQL query. SELECT * FROM TestTable WHERE id=12 LIMIT 10 ---Select all columns of top 10 rows using MSSQL query. SELECT TOP 10 * FROM TestTable WHERE id=12
Following two links can be referenced in case of migration from MySQL to MSSQL OR vice versa with key difference in functionality.
Following certification are listed MySQL Engineer.
Exam Title: MySQL 5.6 Database Administrator
Exam Number: 1Z0-883
Exam Title: MySQL 5.6 Developer
Exam No: 1Z0-882
Following certification are listed MSSQL Engineer.
Exam Title: Querying Microsoft SQL Server 2012/2014
Exam no 70-461
Exam no 70-462
Exam Title: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Exam no 70-463