Hi,
I want to know what is the differance b/w oracle and Sql server ,which is better technicaly and why?
Printable View
Hi,
I want to know what is the differance b/w oracle and Sql server ,which is better technicaly and why?
We can compare sql server with oracle database regarding price, performance, platforms supported, sql dialects and products limits.
Platform comparison
sql server only works on windows-based platforms, including windows 9x, windows nt, windows 2000 and windows ce.
In comparison, oracle 9i database supports all known platforms, including windows-based platforms,unix,linux intel, sun solaris and so on.
Hardware requirements
to install sql server, you should have the intel or compatible platforms and the following hardware:
hardware requirements
processor pentium 166 mhz or higher
memory 32 mb ram (minimum for desktop engine),
64 mb ram (minimum for all other editions),
128 mb ram or more recommended
hard disk space 270 mb (full installation),
250 mb (typical), 95 mb (minimum),
desktop engine: 44 mb
analysis services: 50 mb minimum and 130 mb
typical english query: 80 mb
oracle supports intel or compatible platforms, aix-based systems, compaq tru64 unix, hp 9000 series hp-ux, linux intel, sun solaris and so on.
To install oracle under the intel or compatible platforms, you should have the following hardware:
hardware requirements
processor pentium 166 mhz or higher
memory ram: 128 mb (256 mb recommended)
virtual memory: initial size 200 mb,
maximum size 400 mb
hard disk space 140 mb on the system drive
plus 4.5 gb for the oracle home drive (fat) or 2.8 gb for the oracle home drive (ntfs)
sql server comes in six editions: enterprise, standard, personal, developer, desktop engine, and sql server ce (a compatible version for windows ce)
oracle database comes in three editions: enterprise, standard and personal and requires the following software:
performance comparison
it is very difficult to make the performance comparison between sql server and oracle database.
The performance of your databases depends rather from the experience of the database developers and database administrator than from the database's provider.
Price comparison
one of the main microsoft sql server advantage in comparison with oracle database is that sql server is cheaper.
Other sql server advantage is that microsoft includes the online analytical processing (olap) and data mining as standard features in sql server 2000 enterprise edition. So, you can save up to four times with sql server 2000 enterprise edition if you use olap and data mining.
conclusion
it is not true that sql server is better than oracle or vice versa. Both products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider.
But sql server has some advantages in comparison with oracle and vice versa.
The sql server advantages:
sql server is cheaper to buy than oracle database. Sql server is generally accepted as easier to install, use and manage.
The oracle database advantages:
oracle database supports all known platforms, not only the windows-based platforms.
Thanks & regards trainee_tester