Re: Oracle vs Microsoft SQL Server

In article <33A81839.41E2_at_panther.gsu.edu> Min Zhu <gs01mmz_at_panther.gsu.edu> wrote:

> We are selecting a database for our new project, the candidate for our
> database is Oracle or Microsoft SQL Server. Our design team are like to
> use Oracle, but some of our clients want us to use Microsoft SQL Server.
> Is there anyone can give me comparison between these two database,
> especial the futures Oracle has and Microsoft don't. Any inputs are
> welcome, please send me via e-mail, my e-mail address is
> gs01mmz_at_panther.gsu.edu. Thank you very much.

A lot depends on what you are trying to accomplish.

Some things that favor Oracle are:

1. Ability to support a large volume of users.
2. Available on multiple platforms.
3. Locking mechanism. Yes, I should stress on the word "LOCKING" - "Row Level Locking". This has been a big MS SQL Server killer.

Things that favor MS SQL Server:
1. If your OS is Windows NT, SQL Server is the way to go. It has been around on this platform for a while. It is tightly integrated into the OS. Oracle under NT is very immature. I have fought a lot of serious problems with Oracle under NT - like memory leaks. But I know that they are trying to play the "catch-up" game. 2. MS SQL Server is more cost effective for a small workgroup. 3. MS SQL Server support is a little cheaper than Oracle support. Microsoft has better Technical support resources. Many of them are free of charge.

Good luck with your selection.

Murali Received on Sat Jun 21 1997 - 00:00:00 CDT