Difference between MS SQL Server and PostgreSQL

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

2. PostgreSQL :
PostgreSQL is a powerful, open-source Object-relational database system. It provides good performance with low maintenance efforts because of its high stability. It was the first DBMS that implemented multi-version concurrency control (MVCC) feature.



Difference between MS SQL Server and PostgreSQL :

S.NO. MS SQL SERVER POSTGRESQL
1. Developed by Microsoft Corporation and initially released on April 24, 1989 Developed by PostgreSQL Global Development Group on 1989.
2. MS SQL server is written in C++ language. PostgreSQL is written in C language.
3. It is a Microsoft relational DBMS. It is widely used open source RDBMS.
4. The primary database model for MS SQL Server is Relational DBMS. The primary database model for PostgreSQL is also Relational DBMS.
5. It also has two Secondary database models – Document store and Graph DBMS. It has Document store as Secondary database models.
6. The license for MS SQL Server is Commercial. The license for is Open Source.
7. Server operating systems for MS SQL Server are Linux and Windows. Server operating systems for PostgreSQL are FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix and Windows.
8. In MS SQL Server, partitioning methods are Horizontal partitioning and Sharding through federation. In PostgreSQL, partitioning can be done by range, list and hash.
9. It support replication but in depends on the SQL-Server Edition. It support only one replication methods – Master-master replication.
10. It supports in-memory capabilities. It does not supports in-memory capabilities.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory 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.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.