ORACLE DBMS vs. SQL sever DBMS

15 pts.
Tags:
Data base management
DBMS
Oracle
Oracle DBMS
SQL Server
SQL Server DBMS
What are some key differences between Oracle DBMS versus an SQL server DBMS? Also, What are factors that would make someone want to use an Oracle DBMS versus an SQL server DBMS?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hopefully the answer to this doesn’t turn into a slug fest.

(First post is from the SQL Server point of view, hopefully one of the Oracle guys will post as well.)

Key Differences
SQL Server using T/SQL language, Oracle uses PL/SQL
SQL Server can only be installed on Windows – Oracle can be installed on several OSs included Unix, Linux and Windows
Oracle’s licensing system is much more complex than SQL Servers.
Oracle’s CPU licenses are done per CPU Core, SQL Servers are done per physical CPU.

Both products are very good database platforms and when run on similar hardware will usually give similar performance.

Typically deciding which one to use comes down to a personal preference, and what product you have prior experience with.

In general, I agree with Mrdenny, and I think the most important difference is the one related to the supported Operating Systems.

There are many internal differences, such as the way concurrency is managed, the types of indexes that can be created, maximum length for table and column names, etc, but in general, I also think that both products are very good.

Having worked mainly with Oracle, I have the impression that PL/SQL is more powerful than T/SQL, but that is just my opinion.

Being SQL Server a Microsoft product, I think the integration with the operating system is an advantage of SQL Server, and I also think that it has easier administration, although Oracle has improved this point with the last versions.

Oracle is more expensive…

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,085 pointsBadges:
    report
  • Kccrosser
    I think there are a couple of key items in favor of Oracle IFF you need them. 1. Full DoD "Orange Book" compliance. If you are doing anything that requires real security compliance, Oracle is fully compliant, while SQL Server meets few, if any, of the compliance requirements. Not a big deal if you aren't worried about security at that level. 2. Ability to use Oracle Packages to encapsulate information with session persistence. This is the biggest single difference I have encountered between Oracle and SQL Server. In Oracle PL/SQL, you can create Packages, which can contain local, session-persistent data structures, plus layers of stored procedures, functions, memory table structures (arrays), user-defined new structured data types, etc. You can essentially build structured business objects with public and private structures and interfaces all within the Oracle PL/SQL environment. There is no equivalent capability in SQL Server - to do something similar requires writing external code, creating temporary tables, and in general, creating much more complex code to solve similar problems. (Yes, you can achieve the same end result, but debugging will be much more complex - you won't be able to trace and obtain variable information throughout the process, as you can within the Oracle environment.) 3. As noted - ability to run on multiple OS platforms. Not a big deal if you are a Windows shop. If you don't need any of the above, then it probably comes down to price. The biggest factor in favor of SQL Server is price. Both Oracle and SQL Server are available in "free" versions for small or single-user development environments, and for small servers/workgroups the prices are pretty competitive. However, as your server size and/or number of CPUs goes up, the Oracle price goes up quite a bit faster than SQL Server. One note - for a long time, SQL Server was sold with the claim "it doesn't require a DBA". I would put that claim right up there with "the check is in the mail." Both SQL Server and Oracle require someone with DBA expertise - if Oracle seems to require more DBA expertise, that is because it offers a LOT more opportunities to fine-tune a large implementation. For smaller implementations, the amount of DBA activity and knowledge required for either product is similar.
    3,830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following