Re: SQL vs. Oracle

From: Scott Howell <schowell_at_mindspring.com>
Date: Sat, 22 Jan 2000 00:56:40 -0500
Message-ID: <86bgq8$3tu$1@nntp9.atl.mindspring.net>

Yes,

I have had extensive experience in Oracle 7 and some moderate experience in SQL Server 6.5/7.0
As far as SQL 6.5/7.0 they are completely different in both performace and scalability. When I first ran SQL 6.5 it seems like a overgrown Access, but SQL 7 compares favorably to Oracle 7.0 in both speed and ease of use/programming. Here is a summary comparing SQL 7 to Oracle 7

Performance SQL Server (slight edge, but barely Oracle 8 somewhat beats SQL7 though)
Management SQL Server (SQL 7 EM is has a better design and easier to use)

Cluster                   SQL Server (that Oracle FS is AWFUL, useless)

Overall I like Oracle on everything but the NT platform, but since SQL 7 only runs on NT the comparison is rather limited. Owen Southwood wrote in message
<948375520.6079.0.nnrp-02.c2de2f84_at_news.demon.co.uk>...
>If anyone has experience of both, can they tell me what are the basic
>diffrences between SQL and Oracle databases? Are there any
>performance advantages to either? Is one easier to code for than the
>other? Is the syntax very different? etc.
>
>Thanks for any feedback.
>
>Regards
>Owen Southwood - owen_at_listers.co.uk
>If possible please copy reply via e-mail, thanks.
>
>
Received on Fri Jan 21 2000 - 23:56:40 CST