The comparison of SQL Server 2000 with Oracle 9i
Alexander Chigrik, chigrik@mssqlcity.com
Introduction
Often people in newsgroups ask about some comparison of Oracle and
Microsoft SQL Server. In this article, I compare SQL Server 2000
with Oracle 9i Database regarding price, performance, platforms
supported, SQL dialects and products limits.
Platform comparison
SQL Server 2000 only works on Windows-based platforms, including Windows 9x,
Windows NT, Windows 2000 and Windows CE.
In comparison with SQL Server 2000, Oracle 9i Database supports all known
platforms, including Windows-based platforms, AIX-Based Systems, Compaq
Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, Sun Solaris and so on.
Hardware requirements
To install SQL Server 2000, 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
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)
To install Oracle 9i Database under the UNIX Systems, such as AIX-Based
Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun
Solaris, you should have the following hardware:
Hardware
Requirements
Memory
A minimum of 512 MB RAM
Swap Space
A minimum of 2 x RAM or 400 MB, whichever is greater
Hard disk space
4.5 GB
Software requirements
SQL Server 2000 comes in six editions: Enterprise, Standard, Personal,
Developer, Desktop Engine, and SQL Server CE (a compatible version for
Windows CE) and requires the following software:
Operating System
Enterprise Edition
Standard Edition
Personal Edition
Developer Edition
Desktop Engine
SQL Server CE
Windows CE
No
No
No
No
No
Yes
Windows 9x
No
No
Yes
No
Yes
No
Windows NT 4.0 Workstation with Service Pack 5
No
No
Yes
Yes
Yes
No
Windows NT 4.0 Server with Service Pack 5
Yes
Yes
Yes
Yes
Yes
No
Windows NT 4.0 Server Enterprise Edition with Service Pack 5
Yes
Yes
Yes
Yes
Yes
No
Windows 2000 Professional
No
No
Yes
Yes
Yes
No
Windows 2000 Server
Yes
Yes
Yes
Yes
Yes
No
Windows 2000 Advanced Server
Yes
Yes
Yes
Yes
Yes
No
Windows 2000 DataCenter
Yes
Yes
Yes
Yes
Yes
No
Windows XP Professional
No
No
Yes
Yes
Yes
No
Oracle 9i Database comes in three editions: Enterprise, Standard and Personal
and requires the following software:
Platform
Operating System Version
Required Patches
Windows-based
Windows NT 4.0
Service Pack 5
Windows-based
Windows 2000
Service Pack 1
Windows-based
Windows XP
Not Necessary
AIX-Based
AIX 4.3.3
Maintenance Level 09 and IY24568,
IY25282, IY27614, IY30151
