Loading ...
Sorry, an error occurred while loading the content.

Main Difference B/T SQL Server & Oracle

Expand Messages
  • khuram shahzad
    MAIN DIFFERANCE BETWEEN SQLSERVER AND ORACLE Oracle is like apple and Sql Server is like Orange. For a Poor man Orange is better and for a rich man apple is
    Message 1 of 1 , Jul 12, 2006
    • 0 Attachment
                     
       
                                                                        
                      
      MAIN DIFFERANCE BETWEEN
      SQLSERVER AND ORACLE
       
      Oracle is like apple and Sql Server is like Orange. For a Poor man Orange is better and for a rich man apple is better.
       
      Ø      Oracle runs on many platforms, SQL on Windows only
       
      Ø      Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database
       
      Ø      Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users)
       
      Ø      SQL is #1 in Cost/Performance and overall Performance, although Oracle will refute that Replication is much easier in SQL
       
       
      Ø      Failover support in SQL is much, much easier
       
      Ø      JDBC support is much better in Oracle, although Microsoft is working on it
       
       
      Ø      ODBC support in both SQL is ANSI-SQL '92 compliant, making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in.
       
      Ø      SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though.
       
      Ø      SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line
       
      Ø      Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in
       
      Ø      SQL Analysis Services is included (A very powerful OLAP server). For Oracle it is a separate purchase.
       
      Ø      Oracle will be used especially in large database. But if we use SQL server in such a environment, the data processing will become very slower. Oracle database very closely supports Java rather than SQL server.
       
      Ø      Oracle 7 was RDBMS, i.e. it was a relation database and the one's after that i.e. 8 onwards Oracle introduced the concept of OODBMS. Which stands for Object Oriented Database Management Systems. With every major release Oracle has initiated a lot of changes for the better. Like
       
       
      o        Getting PL/SQL closer to ANSI SQL standards
      o        Automatic Management of Undo from 9i onwards
      o        Introduction of special Grouping operators for queries
      o       SQL server GUI is easy to work. SQL server is easy to maintain. Oracle data processing is very good compared to SQL server
       
      KHURAM SHAHZAD
       

      __________________________________________________
      Do You Yahoo!?
      Tired of spam? Yahoo! Mail has the best spam protection around
      http://mail.yahoo.com

    Your message has been successfully submitted and would be delivered to recipients shortly.