Difference between MS SQL Server and IBM DB2

1. Microsoft SQL Server :
It is relational database management system (RDBMS) developed by Microsoft Corporation and initially released on April 24, 1989. It is written in C and C++ languages. It is platform-dependent and it is both GUI and command based software. It supports a variety of transaction processing, analytics applications, and business intelligence in corporate environments.

2. IBM DB2 :
It is Relational Database Management System (RDBMS) product from IBM. It is made to analyze, store, and retrieve the data efficiently. DB2 product is increased with the support of Object-Oriented features and non-relational structures with XML. It is written in C and C++ languages.



Difference between Microsoft SQL Server and IBM DB2 :

S.NO. Microsoft SQL Server IBM DB2
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.

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.