Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

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