diff b/w oracle and sql server

[Guest_imported]

Plz tell me as soon as possible the diff. b/w sql server and oracle

thankx
Fraz

 

[SQLBill]

There's a lot of difference....but the main thing is SQL Server is way easier to use, maintain, program, and everything else than ORACLE is. I started off with ORACLE training and was hired to maintain an ORACLE Database, but when the vendor (not ORACLE but a reseller) was unable to meet the deadline and requirements we went with SQL Server and I had to go through new training. I find SQL Server MUCH easier. As for the SQL, if you know ORACLEs SQL, MS SQL Server's T-SQL won't give you much problem. There are new commands to learn in T-SQL, but nothing hard.

-SQLBill

 

[phreak22]

In my opinion,

Aside from efficiency, speed and security.

One word: Simplicity!

I never thought I'd say that Microsoft Software is good but MS SQL 2000 is simple, easy to use, good GUI tools and user interfaces.

I was trained in Microsoft SQL Server 2000 first and then in Oracle 8i. What a shocker when we hit Oracle, a lot more to know, a lot more command line. Even with Oracle Enterprise Manager Package, there's alot to learn and there are quite a few changes to their (Oracle's) proprietary PL/SQL.

Dominic S. Vautour
Oracle Certified Professional

---
These would be my two cents... if I had two cents.

 

[DBAwhosaysNIE]

and let's not forget about a little thing called UPTIME: I've got 5 prod Oracle instances which have been up > 100 days (so far, on Linux no less; new hardware) & once had 1 stay up > 400 (Sun box went off lease or would still be going). these are not internal apps w/10 users but serve a 10+M page/day website & switch a 100M logfile every ~15/min (RE: heavy query & DML).

what's the best anyone's done on M$? I want to see the logs for any SQL Server instance which supposedly saw its 2nd full moon...

not trying to flame but don't kid yourself: SQL Server is fine for departmental apps but I would seriously ? the judgement of anyone who builds mission critical/revenue driving apps on it...

DBAwhosaysNIE, also OCP & reluctant SQL Server DBA

 

[amir1]

Hi Fraz,
I have read the comments regarding your query. I had worked on both produtcs and all I can add is if you are running a small scale application where volume is just couple of 000s, Response time just does not matter, data security is not a big issue and at last if you need something where you do not want to spend your time to dig something out GO for SQL server.
If all above does matter try Oracle.

Amir Hussain

 

[SQLBill]

I'm DBA'ing MS SQL Advanced Server 2000 on a two-node cluster with a 14 x 36 Gig hard drive unit and a 14 x 73 Gig hard drive unit, running 7x24 since January 1, 2002. The database grows by approximately 7.5 MB daily and one table is up to 122 Million rows. I'm not having any problem with MS SQL Advanced Server.

We started with an ORACLE database, but had to give it up after less than six months.

-SQLBill