Feature
|
|
Product Format
|
New DBMS Support
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
DB2 8 & 9
|
|
|
|
|
Firebird 1.5
|
|
|
|
|
Informix 10 & 11
|
|
|
|
|
Ingres R3
|
|
|
|
|
Microsoft SQL Server 2005 and 2008
|
|
|
|
|
MySQL 4.x & 5.x
|
|
|
|
|
Oracle 11
|
|
|
|
|
PostgreSQL 8
|
|
|
|
|
Progress 91E04 &10.x |
|
|
|
|
Sybase 15 |
|
|
|
|
Platform Support
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Mac OS X 10.5.x–10.6.x x86 (64-bit Mode)
|
|
|
|
|
Mac OS X 10.4.x–10.6.x x86 (32-bit Mode)
|
|
|
|
|
Mac OS X 10.0.x–10.5.x PPC
|
|
|
|
|
Linux & Unix (32-bit)
|
|
|
|
|
Linux & Unix (64-bit)
|
|
|
|
|
Windows Itanium2 (IA_64)
|
|
|
|
|
Windows Opteron (x86_64)
|
|
|
|
|
Windows Xeon (x86_64)
|
|
|
|
|
|
ODBC Compliance
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Core
|
|
|
|
|
Level 1
|
|
|
|
|
Level 2
|
|
|
|
|
SQL Compliance
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
SQL-92
|
|
|
|
|
License Management
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Distributed License Management
|
|
|
|
|
Performance & Stability
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Enterprise-grade Performance
|
|
|
|
|
Enterprise-grade Stability
|
|
|
|
|
Unicode Support
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Unicode
|
|
|
|
|
Data Type Support
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Microsoft SQL Server NCHAR , NVARCHAR
|
|
|
|
|
Microsoft SQL Server LARGE Value Data Types (NVARCHAR (max) , VARBINARY (max) , VARCHAR (max)
|
|
|
|
|
Microsoft SQL Server XML Data Type
|
|
|
|
|
MySQL Unicode Data Types
|
|
|
|
|
Oracle BINARY FLOAT , BINARY DOUBLE
|
|
|
|
|
Oracle BLOB , CLOB
|
|
|
|
|
Oracle TIMESTAMP (with Time Zone, Local Time Zone)
|
|
|
|
|
PostgreSQL Unicode Data Types
|
|
|
|
|
Security & Authentication
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Ingres OS Level Authentication
|
|
|
|
|
Informix OS Level Authentication
|
|
|
|
|
Microsoft SQL Server Single Sign On (including Windows NTLMv2 authentication)
|
|
|
|
|
Serverside Rules-based Security
|
|
|
|
|
SSL Data Encryption
|
|
|
|
|
Wire Protocol
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Microsoft SQL Server
|
|
|
|
|
MySQL
|
|
|
|
|
PostgreSQL
|
|
|
|
|
Sybase
|
|
|
|
|
Clustering (Failover, Balancing)
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Diagnostic Resources
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
Built-in Clientside Tracing
|
|
|
|
|
Connection Logging
|
|
|
|
|
Database Specific Capabilities
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
DB2 - Multi-Threading Support
|
|
|
|
|
DB2 - SQLCancel Support
|
|
|
|
|
DB2 - XA-Based Two-Phase Commit
|
|
|
|
|
Informix - MS DTC
|
|
|
|
|
Informix - XA-Based Two-Phase Commit
|
|
|
|
|
Ingres - Return of TID value by SQLSpecialColumns(RowID)
|
|
|
|
|
Ingres - XA-Based Two-Phase Commit
|
|
|
|
|
Microsoft SQL Server - Auto-Discovery of SQL Server instances
|
|
|
|
|
Microsoft SQL Server - Database mirroring compatibility
|
|
|
|
|
Microsoft SQL Server - MS DTC |
|
|
|
|
Microsoft SQL Server - Multiple Active Result Sets (MARS) |
|
|
|
|
Microsoft SQL Server - Named Instance Support |
|
|
|
|
Microsoft SQL Server - Snapshot transaction isolation levels
|
|
|
|
|
Microsoft SQL Server - SQL Server Express Support |
|
|
|
|
Microsoft SQL Server - XA-Based Two-Phase Commit |
|
|
|
|
Oracle - Connection Pooling
|
|
|
|
|
Oracle - Instant Client Support
|
|
|
|
|
Oracle - MS DTC
|
|
|
|
|
Oracle - Real Application Cluster (RAC) Support
|
|
|
|
|
Oracle - Reference Cursors in Stored Procedures
|
|
|
|
|
Oracle - Static, Keyset, Forward-Only Cursors
|
|
|
|
|
Oracle - XA-Based Two-Phase Commit
|
|
|
|
|
Progress - User Level Transaction Isolation Levels configuration
|
|
|
|
|
Sybase - Identity Column Support
|
|
|
|
|
Sybase - MS DTC
|
|
|
|
|
Sybase - XA-Based Two-Phase Commit
|
|
|
|
|
Other
|
|
Single-Tier "Express" Edition
|
Single-Tier "Lite" Edition
|
Multi-Tier "Enterprise" Edition
|
ADO.NET 2.0 Support
|
|
|
|
|
Visual Studio 2005 Integration
|
|
|
|
|