Re: Sql Server 7 vs Oracle 8

In article <76jrna$krb$1_at_nnrp1.dejanews.com>,   mgogala_at_rocketmail.com wrote:
> In article <76bv9p$30q$1_at_news.worldcom.ch>,
> "boss" <daemon_at_worldcom.ch> wrote:
> > hi,
> > i'm looking for some information about the main difference between Sql
> > server 7.0 and Oracle 8.
> > the advantage and disadvantage.
> >
> >
> Oracle8 runs on almost any conceivable platform with the possible exception
> of coffee machine (I'm not sure that it doesn't), while SQL server runs only
> on NT. Oracle8 has very good network connectivity with gateways to DB2,
> Sybase, and SQL Server which is definitely not true for SQL Server. There
> are many more apps running on top of Oracle then on top of SQL Server.
> Oracle8 is much faster and much more tunable then SQL Server. There are many
> more books published about Oracle then SQL Server, so it's easier to learn.
>
> --
> Mladen Gogala
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

SQL Server 7.0 can do distributed joins with any DB that has a compliant OLE DB driver or even a compliant ODBC Driver right out of the box. Oracle you have to pay for these gatways where SQL Server it comes free along with Data Tranformation Services, Scheduler, OLAP support, etc. By the time you get all of this for Oracle you just bought your Oracle rep a nice new car! I am not ripping Oracle. Oracle has its place with scalability and stability but as far as the price and the features you get out of the box Oracle cannot touch it (and will never unless Larry sells his boat.) SQL Server 7.0 also will require a much smaller DBA staff so I think TCO will be substaintially smaller. The only reason I would go to Oracle right now is database size or needs to support isolation levels that SQL Server will not.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 20:48:16 CST