Results 1 to 2 of 2

Thread: what is the technical differance b/w oracle and sql server

  1. #1
    Junior Member
    Join Date
    Mar 2008
    Answers
    4

    Question what is the technical differance b/w oracle and sql server

    Hi,
    I want to know what is the differance b/w oracle and Sql server ,which is better technicaly and why?


  2. #2
    Junior Member
    Join Date
    Feb 2008
    Answers
    25

    Post Re: what is the technical differance b/w oracle and sql server

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact