| 1 |
It is developed by Apache Software Foundation in 1997. |
It is developed By D. Richard Hipp. in 1989. |
| 2 |
It is written in Java language. |
It is written in C and C++ language. |
| 3 |
The primary database model for Derby is Relational DBMS. |
The primary database model for MS SQL Serve is Relational DBMS. |
| 4 |
Server operating systems for Derby are Windows, macOs, Linux, Unix, BSD and z/OS. |
Server operating systems for MS SQL Server are Linux, Windows. |
| 5 |
It has Java Stored Procedures for Server-side scripts. |
It has Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Java for Server-side scripts. |
| 6 |
APIs and other access methods used by Derby is JDBC. |
APIs and other access methods used by MS SQL Server are ADO.NET, JDBC, Tabular Data Stream (TDS)and ODBC. |
| 7 |
It supports only Java programming language. |
It supports C#, C++, Java, JavaScript, Visual basics, PHP, PL/SQL, Python, R, Ruby, etc. |
| 8 |
It supports Master-Slave Replication methods. |
It supports replication method but depending on the SQL-Server Edition. |
| 9 |
It is a open source software framework. |
It is a commercial databases. |
| 10 |
It supports fine grained access rights according to SQL-standard. |
It also supports fine grained access rights according to SQL-standard. |