Re: Oracle and Microsoft SQL Server

Hi

My (rather limited) experience with the true product have biased me strongly towards MS SQL Server.

1. If your platform policy is Microsoft directed, and NT is a choice available to you, go for MS SQL Server. NT is a good platform getting stronger very quickly. MS SQL Server rides on the back of the OS to a large extent. If you need to be cross-platform or on Unix, go for Oracle.
2. MS SQL Server has the best price/performance up to about 7000 tpcC. Although these systems are highly tuned, you can't tune Oracle to give better price/performance. Oracle will be more expensive for the same performance. (Sure other issues such as reliability are important, I haven't noticed much difference in practice though).
3. Administration and general maintenance is more difficult and more expensive on Oracle. Oracle 'experts' tend to be more difficult to find, more expensive and equally ignorant. (ALL generalization are false :-) ).
4. Tuning and configuration tends to be more difficult but more flexible on Oracle. This is not neccessarily good (See point 2), but might be required in your scenario. Often Oracle NEEDS more setup/tuning just to work, but you have a lot more variables to play with.
5. If you develop in a Microsoft environment, MS SQL Server tends to fit in better than Oracle (especially with the tools available in Visual Studio, e.g. debugging tools for stored procedures).

At the end of the day, there are arguments for both (like mine, most replies will be very biased). However Oracle and SQL Server are both likely to be up to the task. The back-end is just one part of a solution, your choice is unlikely to break or make the project.

G

Min Zhu <gs01mmz_at_panther.gsu.edu> wrote in article <33A2D76E.5329_at_panther.gsu.edu>...
> 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.
>
Received on Thu Jun 19 1997 - 00:00:00 CDT