| Oracle DB |
Microsoft-SQL Server |
- Oracle is built for different platforms (Vendors) and operation (IBM, HP, Linux, Sun-Java, IFS, Flash).
|
- Microsoft SQL is also built for different operating system but not compatible with all of them like Java. Some supported platforms for windows are AIX-based, Compaq, Hp9000 series, Linux-Intel etc.
|
- Oracle installation process is easy in windows but difficult in other operation systems.
|
- Microsoft SQL installation is very easy and understandable for different operation system.
|
- Oracle server administration is difficult in all platforms with GUI and command line prompt.
|
- Microsoft SQL server administration is easier than Oracle.
|
- Oracle is not pure database because it was built with different techniques collaboration.
|
- Microsoft SQL is pure database.
|
- JDBC & ODBC support is better in Oracle.
|
- Microsoft SQL support ANSI methodology.
|
- Oracle OLAP sever is very costly and not imbedded in oracle.
|
- Microsoft SQL analysis services shows OLAP server is powerful in this technology.
|
- Oracle is very costly to purchase.
|
- Microsoft SQL is very cheap.
|
- Oracle is true enterprise solution because it has very good client/server methodology and ensures data integrity.
|
- SQL Server has no multi-version consistency model, which means that “writers block readers and readers block writers” to ensure data integrity.
|
- Oracle is very supportive for Parallel and RAC server technique.
|
- Microsoft SQL Server is positioned between Microsoft Access and Oracle in terms of functionality, performance and scalability in market.
|
- Oracle is much more challenging in test case and database connectivity.
|
- Generally testing performance is easy in SQL with easy accessible query plan and statistics.
|
- To check Oracle’s reliability and performance, more than 10 million entries have to be entered in database.
|
- To check the SQL server performance one million entries have to be entered.
|
- If any problem occurs in the database, you can’t find any training or human resource material in limited time frame.
|
- If problem arises in SQL Server, you can find material and training resources easily in market.
|
- Oracle is given the full control to allocate the cache memory in table spaces. Oracle support partitioning the table in different format.
|
- In SQL Server, the DBA has no “real” control over sorting and cache memory allocation.
|
- Oracle PL/SQL is more power tool than T-SQL.
|
- T-SQL is less powerful tool than PL/SQL.
|
- Oracle supports 1000 columns per table.
|
- SQL server supports 1024 columns per table.
|
- Oracle9i Enterprise Edition With OLAP and Data Mining price is $2,560,000
|
- SQL Server Enterprise Edition price is $639,968.
|
- Oracle requires minimum 512 Ram and 4.5GB space for installation in Linux operation (But different in windows).
|
- SQL Server requires 128 MB Ram and 270 MB space for installation.
|
- Oracle DB Server is supported by Windows 2000 server, Windows 2003 server, Windows XP, Windows vista, Windows 7, AIX-Based, Compaq Tru64 Unix, HP-UX, Linux, Sun Solaris 32 n 64 bit. Oracle DB Server is more supported in Internet base transaction process.
|
- MS-SQL server is supported by window 2000 advanced, Windows 2000 Data-Center, Windows XP-Professional, Windows Vista, and Windows 7, Linux-Intel operation system.
|
- 32 Number CPU in Oracle Standard edition cost $480,000.
|
- 32 number CPU in SQL standard edition cost $160,000.
|
- Oracle Server PL/SQL supports B-Tree Indexing, Bitmap, partitioned, Function-based and Domain indexing. It also supports Relational and temporary table format.
|
- Microsoft SQL Server only supports B-Tree indexing.
|
- Oracle PL/SQL supports before, after and instead triggers.
|
- Microsoft SQL server support only after and instead triggers.
|
- Oracle PL/SQL procedures support PL/SQL statements, Java methods, Third generation language and 3GL routines.
|
- Microsoft SQL supports T-SQL statements.
|
- Oracle PL/SQL supports Arrays method.
|
- Microsoft SQL server does not support Arrays method.
|
- ORACLES DB Server constant string sizes in SELECT statements are 4000 only.
|
- In SQL-server constant string sizes in SELECT statement are 16777207.
|
- Maximum query sizes in Oracle are 16777216.
|
- Maximum query sizes in SQL Server are 16777216.
|
