Main Difference B/T SQL Server & Oracle
- MAIN DIFFERANCE BETWEENSQLSERVER AND ORACLEOracle 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. Likeo Getting PL/SQL closer to ANSI SQL standardso Automatic Management of Undo from 9i onwardso Introduction of special Grouping operators for querieso SQL server GUI is easy to work. SQL server is easy to maintain. Oracle data processing is very good compared to SQL serverKHURAM SHAHZAD
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around