We help IT Professionals succeed at work.

SQL Server V/s Oracle

raghav3
raghav3 asked
on
Medium Priority
421 Views
Last Modified: 2008-02-01
what is the difference between SQL Server7.0 and Oracle8?
Which is more powerfull? What are the merits and demerits of SQL Server over Oracle? What is the architecture of SQL Server?
Comment
Watch Question

Commented:
you should be comparing SQL Server 2000 and Oracle 9i.

the biggest difference, off-hand, that you will see is price. Oracle is very much more expensive than SQL Server.
http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp

the other really big difference is that Oracle is not just a database application - it's an entire E-Commerce/E-Business suite. the root of all, of course, is the actual Oracle Database system.

here is Microsoft's "Competative Comparison" page for SQL2K & Oracle 9: http://www.microsoft.com/sql/evaluation/compare/default.asp

i'm a SQL Server 2000 fan, myself, though both have similar functionality and capabilities.

the real question is: is your company a Microsoft shop, or not? this one question usually plays about a %50 difference in which database server you go with.

in the long run, Oracle has more "built in" features, but SQL Server is usually easier to setup/configure, and get going - especially in terms of integrating into other Microsoft applications.
I work with both Oracle 8i and SQL 7.0, and I find Oracle to be a much more difficult to administer and work with in general.  Esp. when comparing SQL+ to Query Analyzer, Query Analyzer wins hands down.  SQL Server's maintenance wizards are also a nice feature I haven't seen in Oracle.

Oracle's internal recovery mechanisms are superior to SQL Server's but I'm not fond of their actual backup/restore functionality.

I don't work with large enough databases to give a good comparison on performance on a large scale, but they seem fairly evenly matched on a small scale.  Of course it all matters how the db engines are configured too.  Oracle seems to have more performance tweaking abilities the SQL Server, but you also have to tweak it for it to run right.  

Out of the box, I'd choose SQL Server for cost and ease of use.  I have yet to see any gains that would outweigh the extra hassle and overhead of Oracle in the < 10GB database realm.

HTH

Explore More ContentExplore courses, solutions, and other research materials related to this topic.