| Number | Base of difference | SQL Server | MySQL |
| 1 | License | SQL Server is a proprietary software. | MySQL is free and open source under GPL v2 license and also distributed as proprietary software. |
| 2 | Written In | SQL Server is written in C and C++ | MySQL is also written in C and C++. |
| 3 | Website | Website for SQL Server is:- softwaretestinghelp.com/sql-vs-mysql-vs-sql-server/ | Website for MySQL is:- mysql.com |
| 4 | Developer | SQL Server is developed by Microsoft since then SQL Server is designed by Microsoft and it is often called as MSSQL Server. | MySQL is developed by Oracle Corporation. |
| 5 | Multilingual | SQL Server available in multiple languages. | MySQL is only avilable in English Language. |
| 6 | Programming Languages | SQL Server will supports multiple programming languages which includes Java, PHP, VB, Delphi, Go, Python, Ruby, R and C++. | When we say about MySQL this will supports all programming languages like we have for SQL Server. MySQL will supports some additional languages which include Perl, Eiffel, Haskel, TCL and Scheme. And this will makes MySQL very popular among developer communitites. |
| 7 | Pricing | The developer edition and express edition of SQL Server 2017 are free of cost. Enterprise edition costs $14,256 per core. Standard – per core edition is priced at $3,717, Standard – Server + CAL costs $931. For the Web edition price, you need to contact your hosting partner. | The standard edition annual subscription is USD 2,000; Enterprise edition costs USD 5,000 and cluster CGE edition costs $ 10,000. |
| 8 | Storage Engine | Single storage Engine which is its native engine. | Multiple storage Engine support. Also has an option for using a plug-in storage engine. |
| 9 | Editions | MS SQL Server offers different editions of SQL Server:-
(1)Enterprise
(2)Standard
(3)Web
(4)Express
(5)Developer Editions.
And each of te editions varies in terms of their features and purposes. | As Due to different business and technical needs MySQL offers 3 different editions as given below:-
(1)MySQL standard edition
(2)MySQL Enterprise Edition
(3)MySQL Cluster CGE
There is also a community edition of MySQL which is open source and free. |
| 10 | Supported Platforms | SQL Server supports below platforms:-
(1)Linux
(2)Mac OS X
(3)Microsoft Windows Server
(4)Microsoft Winodws Operating Systems
This was originally developed for windows exclusively. However, it is also available on Linux and Mac OSX via docker. But, SQL server on Linux or Mac OS X will definitely lack certain features. | MySQL smooth support for below platform:-
(1)Linux
(2)Solaris
(3)Windows
(4)macOS
(5)FreeBSD
operating systems. And runs nearly on every popular OS. |
| 11 | Filtering | This will supports row-based filtering which filters out the records on a database by database way. And it gives the advantages of filtering multiple row without considering a number of databases. Moreover, the filtered data is kept in a separate distribution database. | This will allows filter out the tablet, rows and users in avariety of ways. However, MySQL supports filtering only on individual database basis. So, developers have to filter database tables individually by executing multiple queries. |
| 12 | Backup | When we say about Backup in SQL Server when we backing up the data the database is not blocked. And this allows users to complete the backup and data restoration process completed in less time and efforts. | Backup of the data can be taken by extricating all the data as SQL statements. During the backup process, the database is blocked. This prevents the instances of data corruption while migrating from one version of MySQL to another. However, increases the total time and efforts in the data restoration process because of running multiple SQL statements. |
| 13 | Query Execution | Can truncate the query execution without killing the whole process. It utilizes a transactional engine to hold the state consistent. | We can not cancel or kill the query execution without killing the entire process. |
| 14 | LINQ | As MSSQL Server lets you configure our entity framework classes in .NET and we can begin with LINQ queries. | But we would have to download third-party tools instead for using .NET with MySQL. |
| 15 | Affordability | In MSSQL we will require licenses for servers running the platform, which makes it more costly. | As we knows MySQL is open source and it is free but you will need to pay for support when necessary. |
| 16 | MyISAM and InnoDB | MyISAM and InnoDB are MySQL configurations, enabling developers to undertake various activities related to programming and design.
| MSSQL Server wonot let you specify different engines while creating databases.
|