As an Oracle Fan I would be tempted to give you rhetoric, but I will try
to be fair and
stick to the point :)
- Oracle is scalable, which means that once your database grows too big
for NT, you can move it
to UNIX or another OS without too much of a hassle.
- Oracle gives you a lot of features, row-level locking, web
integration, parallel query,
bit-mapped indexes, MPP support,all datatypes (universal server)
etc......The list is long.
There is nothing which SQL Server does and Oracle does not. In fact,
all features found in SQL server 6.5, were there in Oracle 5.x or
so...For a list, look in any PC week, Oracle loves comparing it with SQL
Server.
I am not sure how SQL server performs without row-level locking.
- For smaller databases, SQL server may appear faster, since, it does
not have most features Oracle has,
but, you gotta decide if you want features or not.
- Most "real" dba's agree that in comparison with Oracle, Sybase,
Informix and DB2, SQL server
should probably be called version 2.0 or 3.0. However, when Bill Gates
suddenly says it is 6.5, it
is 6.5, even though it just cannot compare with the big four ones...
Just my opinion....
Raman Batra, Oracle DBA
Min Zhu wrote:
>
> 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 Sat Jun 14 1997 - 00:00:00 CDT