Re: MSSQL vs Oracle - Just the facts

Doug,
I have been developing systems with Oracle since 1995. I also have some recent exposure to MS SQL 7.
Just to add my 5 cents:

Pro Oracle:

    Oracle PL/SQL is by far lot better programming language than MS SQL Transact SQL is.
Con Oracle:

    One has to buy other products to be productive with PL/SQL (Debugger, IDE etc.)

    There is no graphical database designer out of a box. (You can buy one, of course!)

    Calling COM/DCOM or external DLL is slow from inside packages.     (Who the hell came with this idea of using IPC for it?)

Pro MSSQL 7

    Nice integrated IDE (debugger, graphical database designer)     Price and number of features in the box.     It has row level locking now. (And it works!) Con MSSQL 7

    Only one OS.
    Transact SQL is a relict from the dark past.

Thomas Olszewicki
ThomasO_at_cpas.com
www.cpas.com

Doug Coan <dcoan_at_aegonusa.com> wrote in message news:81ekgs$7n9$1_at_nnrp1.deja.com...
>
>
> Ok guys and girls - This is an issue that keeps on comming back. So, I
> would like to start a true features and functionality comparison. I'll
> probably put it out on a web page in time. Here is the start of a list
> that took me about 5 minutes to develop. Please add or dispute to your
> hearts content. Prove me right or wrong. I don't care. Thanks
> much..........
>
> My experience is 1 year with Oracle supporting 50+ instances on over 20
> servers, 4 years with Sybase on about 12 servers, 2 with MSSQL < 7 on a
> few servers and a two recent MSSQL 7.0 servers. Sybase however, is no
> longer is a contender in this argument in my opinion.
>
> Please enjoy the following as a starting point only.............
>
> For Oracle
>
> Supports multiple platforms (NT, Unix, Linux)
> Many performance tuning options
> Supports multiple instances per server
> Supports shared server setup
> Parallel query and parallel server
> Sequences for automating item increments
> Packages for improved performance
> Ability to Monitor/review sql
> Significant performance information available
> Can run multiple versions from single server
> Support for more table index options (reverse,iot,etc..)
> Procedural language support and ANSI SQL in PL/SQL
> Standby server support
> Able to recover to point in time to failure
> Hot, cold, logical backup options
> Changed block level backups available
> Row Level Locking
> Inherent ROWID Support
>
> Against Oracle
>
> Difficult to setup
> Complex DBA support
> Expensive
>
> Against MSSQL
>
> NT only
> Few performance tuning options
> Single database per server
> Dedicated server setup only
> Single processes only
> Must be coded using tables
> Single stored procedurs
> No SQL monitoring capabilities
> Little performance tuning information available
> Only one version can be installed per server
> Few table index option supported
> ANSI SQL Support only
> n/a
> Only able to recover from last full backup
> Cold and logical backups only
> Datafile backups only
> Page level locking
> Must create own rowids
>
> For MSSQL
>
> Easy to setup
> Simple DBA support
> Cheap
>
> --
> Doug Coan
> Senior Client Server System Integrator
> AEGON USA
> dcoan_at_aegonusa.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 23 1999 - 22:53:26 CST