Oracle and SQL server comparison
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Oracle and SQL server comparison

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    56
    Hi guys,

    I wonder if anyone of you know some links or sites about Oracle and SQL server comparison articles. Just want to know the pros and cons using both of them.

    Thanks in advance.

    Ric
    Oracle freak & about-to-be DB2 freak
    Singapore

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    there is one article on Technet, go look there

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Microsoft:

    Oracle is ****e and SQL Server is the best.

    Oracle:

    SQL Server is ****e and Oracle is the best.

    Tim:

    They do the same thing in slightly different ways. There's not alot to choose between them these days. People tend to slag-off the product they've not used.

    A guy recently listed several reasons why Oracle was rubbish compared to SQL Server. It soon became obvious he'd not used Oracle since early Version 7. Likewise, most people I hear slagging off SQL Server have only used 6.5 which was crap. If they had used SQL Server 2000 they would be a bit red faced while trying to justify the price of their Oracle licenses to their boses.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    There are lot of things to look at..

    a)price
    b)functional requirements
    c)Skill sets
    d)Infrastructure
    e)Futre growth etc

    etc....I recently was asked to advise on such a project and guess what was the best product for them..it was Mysql...
    the customer is quite happy.

  6. #6
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    IS SQLSErver 2000 available on any other platform other than Windows?
    There Nothing You cannot Do, The problem is HOW.

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi Sudip

    Nope sql server 2000 is not available on other platforms.

    regards
    Hrishy

  8. #8
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    56
    Sanjay, thanks for the articles you gave me. Marketing is always like that. Both say something contradictive to each other products. But it does give me some ideas.

    Hrishy,

    What do you think about mysql? I found it, at a glance, to be a little db which doesn't have many features in it. I wonder what people think of this product because from many sites I realize that mysql is quite a popular product.

    Ric
    Oracle freak & about-to-be DB2 freak
    Singapore

  9. #9
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    It is far from being small in terms of it's speed and the size it can scale to. Where it is a bit toy-like is in the list of features it has. Complexity comes with a performance overhead, which mySQL avoids. No foreign keys means no recursive SQL to check for foreign key violations etc.

    If you want something fast and cheap for simple database operations it's hard to beat. So much so that Sun have, or are going to, buy the company and distribute it as their own database. That may harm the Sun-Oracle relationship somewhat!

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width