Difference Between Sql/Server and Oracle

[natram]

Hello,

I would like to know the key difference between sql/server vs oracle.

thanks
nat

[slimdave]

• Platform independence
• Scalability
• ... feel free to add more

[raghud]

Did your Oganization wants evaluate both products ??

Search google .. You will find so many links for comparision.

[cruser3]

This reminds me to post:
Any1 here administering both Oracle and Sql server as I may have to do the same i.e manage a couple of SQL server db's sometime in the near future and was wondering if I could get any pointers on getting upto speed.

[adrianomp]

My impressions, since I work with both:

SQL Server has some nice features like DTS and the SQL Server Agent, much easier to configure than Oracle.

However, when properly used Oracle is quite more powerful. It seems the approach on 10g is to make the DB as easy as MSSQL.

The better choice falls on the obvious considerations of scalability, costs and sizing.

[abhaysk]

one thing on sql server i cant forget is "Locking mechanism sucks in MS Sql Server"

Abhay.

[dknight]

concurrency control is not the same in SQL Server and oracle.

[gandolf989]

Originally posted by abhaysk
one thing on sql server i cant forget is "Locking mechanism sucks in MS Sql Server"

Abhay.

IMHO, in SQL Server 6.5 the locking mechanism was pathetic.
It has improved a lot since then.

[abhaysk]

Originally posted by gandolf989
IMHO, in SQL Server 6.5 the locking mechanism was pathetic.
It has improved a lot since then.

So was 7.x.. But 2000 is also no good ..

Abhay.

[gandolf989]

Originally posted by abhaysk
So was 7.x.. But 2000 is also no good ..

Abhay.

I once worked at a place that had a SQL Server 2000 cluster running with over 1,200 concurrent users pounding it all day, and SQL Server worked fine. Tha'ts not to day that I prefer SQL Server, instead I prefer Oracle for the number of things that I can do with it.