PDA

View Full Version : Solved: difference between types of databases



philfer
01-13-2008, 11:31 AM
Hi,

If someone is new to this and wanted to learn a language for databases which one is the best/most used.

Whats the difference between SQL Server 2005 and MYSQL. Which one is better or more widely used.

Are Oracle databases still widely used

At work one of our systems is moving from a Paradox server to SQL.

Does this mean that SQL is the future and if it is which of SQL Server and MySQL is better to learn.

Any advice would be appreciated

Bob Phillips
01-13-2008, 04:09 PM
SQL Server is MS' database offering, which you pay for (SQL 2005 Express is free), uses Transact-SQl (a particular flavour of SQL).

MySQL is an open-source (I think it is OS) free database, uses a more generic SQL (but has its own nuances I believe).

Oracle databases are incredibly widely used, probably the most widely used.

SQL is the now not the future, but SQL Server is not necessarily the future. It ties you to MS, it is bloated, but it is used. I am not sure how widely MySql is used.