Follow by Email

Monday, September 1, 2014

Microsoft SQL Server vs. MySQL vs. Oracle Comparison

Hi below is the comparison of the Top 3 Widely Used Databases around the Globe :

Basic Highlights :

1. Microsoft SQL Server : 

Pros:

  • Rich GUI
  • Great Performance
  • Easy to Use
  • Built-in BI Tools
  • Works well with .Net

Cons:

  • Free Version Supports only 10 GB of Database
  • The Paid Version is costly


2. MySql

Pros:

  • Free 
  • Works well with PHP
  • Large Community
  • Runs on Any OS


Cons:

  • no built in tools
  • Sometimes troubleshoot consumes more time due to lack to tools
  • Features are less compared to Oracle and Sql Server


3. Oracle

Pros :

  • Everything is under Transaction, so need to commit every-time
  • Runs on Any OS
  • Works well with Java
  • Good on Performance, Highly Scalable

Cons:

  • GUI is not that great compared to MS Sql Server
  • Expensive
  • More configuration


Detailed Comparison:

Microsoft SQL Server vs. MySQL vs. Oracle Comparison