?
Solved

Difference bettwen Oracle and SQL Server

Posted on 2011-03-02
5
Medium Priority
?
289 Views
Last Modified: 2012-05-11
Can some very briefly explain to me the difference Oracle Database vs Sql Server?  Is Oracle just designed better for managing larger volumes of data?  
0
Comment
Question by:Hojoformo
5 Comments
 
LVL 10

Accepted Solution

by:
himanshut earned 2000 total points
ID: 35023555
Got his from : http://www.greenspun.com/bboard/q-and-a-fetch-msg.tcl?msg_id=0090bA

1. Oracle runs on many platforms, SQL on Windows only 2. Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database 3. Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users) 4. SQL is #1 in Cost/Performance and overall Performance, although Oracle will refute that 5. Replication is much easier in SQL (I have been at clients where even the Oracle consultant couldn't get it working w/oracle) 6. Failover support in SQL is much, much easier 7. JDBC support is much better in Oracle, although Microsoft is working on it 8. ODBC support in both 9. SQL is ANSI-SQL '92 compliant, making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in. 10. SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though. 11. SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line (Back in SQL 6.5 days I had a customer who was so proud that after a day's worth of work he had managed to script his database. I showed him how it was a 3 click operation in SQL ;-) 12. Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in 13. SQL Analysis Services is included (A very powerful OLAP server). For Oracle it is a separate purchase.
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 35023647
I agree with a lot of the gerneral ideas in the previous post, but that really seems to be from a very MS SQL biased view.  And some of it seems old, talking about "Back in SQL 6.5 days", they have both come a long ways since the mid-90s.
Oracle is definately percieved by many (outside MS) to be the high end database for high volume and size, but MS is making very good headway to VLDB status.
Oracle administration is percieved to be harder to learn and do probably because it is usually deployed by big companies with expert SysAdmin types that know all the internals and such, which also help explain why administrators are more expensive and harder to find.  MS SQL on the other hand has been geared more for the average business to be able to get set up with simpler GUI interfaces and lots of adequite defaults.
Overall Oracle installations are going to be more expensive and ellaborate but MS claiming all the extras like Analysis Services and Reporting Services are included for free is a little misleading.  If you follow their own best practices and separate the funtions onto their own servers, you get to PAY for the licenses anyway, not really free.  Not saying they are not good tools, just not really "Free".
Being in the consulting world we typically see only the larger companies that can afford it using Oracle, no startup or small business trying to do things on the cheep are going to go down that route.
Personally I liked and miss working on Oracle databases, I did back in those early "SQL 6.5" days mentioned before, but I have to say MS has come a long way and we have clients doing amazing things with it these days.
HTH,
Chris
0
 
LVL 11

Expert Comment

by:SAMIR BHOGAYTA
ID: 35023874
   * The FIRST biggest difference: Transaction control. In Oracle EVERYTHING is a transaction and it is not permanent until you COMMIT. In SQL Server, there is (by default) no transaction control. An error half way through a stored procedure WILL NOT ROLLBACK the DDL in previous steps.

Obviously, if you wrap the TSQL DML in BEGIN TRANSACTION and COMMIT then it will roll back but this is rare in SQL Server code I've seen.

    * The SECOND biggest difference: MVCC. In SQL Server and Oracle is different. SQL Server will allow dirty reads, and writes can block reads in MS SQL (Again, it's configurable but the default in SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.
0
 
LVL 20

Expert Comment

by:informaniac
ID: 35024594
To the asker: Wht is ur requirement when u say database.
0
 
LVL 16

Expert Comment

by:Kalpesh Chhatrala
ID: 35046519
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question