Desktop

Ask something
Discussion Locked

Database Question

0 helpful
9 replies

by arongirl

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

1) I want to know what the major differences between MS SQL Server 2000 (Enterprise Edition) and Oracle 9i Database (Enterprise Edition) are?

2) Why are these differences important to a business planning to migrate from a non-relational database to one of these relational databases?

Thanx in advance, I hope you'll be able to help me out....

arongirl@home.com

9 replies

by vramji

1. Oracle & MS-SQL Server are RDMS.

2. Oracle is a Sun MicroSystems Product

3. Ms-SQL Server is a Microsoft Product

4. Oracle 9i using 11 rules of RDMS concept

5. SQL Server using 10 rules of RDMS Concept

by pak

The first answer was wrong about Oracle being a Sun Mirocsystems Product. IT is an Oracle Product that can run on multiple platforms. This would be the Key difference (platform). Other considerations would be budget and development language/platform.

by jurasek

SQL Server is easier to administer and is cheaper. Oracle has a reputation of being a more robust database, but the current version of SQL2000 is very comprable in performance, especially with the improved clustering capability.

by donq

If your client is entering the relational database world for the first time their problem should not focus on which ODBC product to use, but how to model (or warehouse) their business data for ANY database. That is CRITICAL for ANY databas engine available today - and remains the biggest problem for most companies.

This discussion is closed to new replies.