Re: SQL server Vs Oracle

Frédéric BROUARD wrote in message <3731696B.273E4D36_at_simog.com>...
>Ling wrote:
>
>> Hi all,
>> Our project team is looking into upsizing a VB/Access database to
>> either MS
>> SQL Server/ Oracle on NT. We don't know what their main differences
>> are and
>> which one we should use. Any information regarding this subject or any
>>
>> recommendation will be very appreciated.
>>
>> Thanks in advance
>>
>> Ling
>
>1 - Oracle runs on more plateforms than Microsoft SQL Server

Irrelevant, since he wants to run on NT

>2 - SQL statement in Oracle are closest to standard than SQL server

Oracle does not support ANSI join syntax, meaning he will have to rewrite all of his Access JOINs

>3 - Oracle had a greater part of the SQL C/S market than SQL Server, so
>you will find more specialist on Oracle designing.

Or he can administer SQL Server himself and not have to pay anyone.

>4 - Larry Ellison had make a 1 million $ bet to anyone can demonstrate
>that Oracle is under 100 time faster than SQL server
>And the bet has not been paid yet !!!

True, but this is a hardware scalability issue. Larry wins this bet by using some 1000+CPU/hard drive machine that NT won't run on.

>5 - the strategy of Microsoft is to make you a prisonner of thoses
>systems, so that, when your data will be on a MS system, it will ever
>coste a lot : to maintain version or to migrate... MS is a super,
>maximized, and optimized making money machine and that's all !

Completely agreed, but for those of us that have already been seduced by the Dark Side of The Force, MS will forever dominate our destinies... 8)

>
>Frederic BROUARD - databases conceptor in FRANCE
>DELPHI - Paradox - SQL C/S expert
>Professionnal e-mail address : f.brouard_at_simog.com
>Private e-mail address : brouardf_at_club-internet.fr
>
>
>
Received on Thu May 06 1999 - 07:34:45 CDT