1. |
Developed by Microsoft Corporation. |
Developed by IBM. |
2. |
MS SQL Server was initially released on April 24, 1989. |
IBM DB2 was initially released in 1983. |
3. |
For MS SQL Server, Server operating systems are Linux and Windows. |
IBM DB2 Server operating systems are AIX, HP-UX, Linux, Solaris, Windows, z/OS. |
4. |
APIs and other access methods include ADO.NET, JDBC, ODBC, OLE DB, Tabular Data Stream (TDS). |
APIs and other access methods include ADO.NET, JDBC, JSON style queries, ODBC and XQuery. |
5. |
MS SQL Server supports C#, C++, Delphi, Go, Java, JavaScript (Node.js), PHP, Python, R, Ruby, Visual Basic programming languages. |
IBM DB2 supports C, C#, C++, Cobol, Delphi, Fortran, Java, Perl, PHP, Python, Ruby, Visual Basic programming languages. |
6. |
Secondary database models are Document store and Graph DBMS. |
Secondary database models are Document store and RDF store. |
7. |
In MS SQL Server tables can be distributed across several files (horizontal partitioning) and sharding is done through federation. |
IBM DB2 supports Sharding Partitioning methods. |
8. |
Famous companies like Bank of America, UPS, etc uses MS SQL Server. |
Famous companies like Wells Fargo, Citi, JPMorgan Chase, Bank of America, etc uses IBM DB2. |