• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 25224
  • Last Modified:

My SQL, SQL Server, DB2, Oracle Advantages Disadvantages?

Hi,
  I am designing a conference management system, I have not determined which database to use and would desperately like to know what are the main advantages/disadvantages to implmenting such a system in the following databases:

- MySQL
- SQL Server
- DB2
- Oracle

Any help would be greatly appreaciated

Thanks

Dan
0
danny1979
Asked:
danny1979
1 Solution
 
thehazeCommented:
MySQL: The software and support are free. All of the others cost money.
0
 
Brendt HessSenior DBACommented:
One other to consider - PostgreSQL ( http://www.postgresql.org )

Advantages:
SQL Server
   Good tools
   Much support available
   Stable
   Complete

DB2
   Much Support Available
   Runs on multiple platforms
   Easily Scalable
   Stable

Oracle
   Much Support Available
   Runs on multiple platforms
   Easily Scalable
   Stable
   Arguably fastest for large datasets

MySQL
   Free
   Much support available
   Good Developer community
   Stable
   Runs on multiple platforms

PostgreSQL
   Free
   Stable
   Runs on Multiple Platforms
   Good Developer community
   
Disadvantages:
SQL Server
   Only runs on MS platforms
   Not as robust as DB2 or Oracle (unknown compared to MySQL and PostgreSQL)
   Can be expensive
   Requires some administration

DB2
   Not as robust as Oracle
   Can be expensive  
   Requires administration

Oracle
   Can be Very expensive
   Requires trained administrator

MySQL
   Not as many features as above in default config
   No direct ADO support

PostgreSQL
   No direct ADO support

That's my 2c worth
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now