The following table outlines the differences between Microsoft SQL Server 7.0 and Sybase Adaptive Server Anywhere 6.0.
Topic |
Microsoft SQL Server 7.0 | Sybase Adaptive Server Anywhere 6.0* |
---|---|---|
Client Hardware Requirements | ||
IBM PC or compatible | Yes | Yes |
DEC Alpha | Yes | No |
RAM (total system) | 32 MB | 32 MB (1) |
Disk space (without help/samples) | 66 MB (41 MB if shared components already installed)2 |
50 MB |
Operating System Platforms3 | ||
Windows 9x | Yes | Yes |
Windows 3.1 | No | Yes |
Windows NT | Yes | Yes |
Novell Netware | No | Yes |
Network Support | ||
Named pipes (Windows NT only) | Yes | No |
TCP/IP sockets | Yes | Yes |
Novell Netware IPX | Yes | Yes |
Appletalk | Yes | No |
Banyan VINES | Yes | No |
Shared memory (local only) | Yes | No |
NetBIOS | No | Yes |
SQL Compliance | SQL-92 | SQL-92 |
Database Features | ||
Transaction processing | Yes | Yes |
INSERT, UPDATE, DELETE triggers | Yes | Yes |
Stored procedures | Yes | Yes |
Extended stored procedures (dynamic link libraries) | Yes | Yes |
Bidirectional and scrollable cursors | Yes | Yes |
Row-level locking | Yes | Yes |
Cost-based query analyzer | Yes | Yes |
Parallel query | Yes | No |
Heterogeneous joins | Yes | No |
Online backup and recovery | Yes | Yes |
Binary large object (BLOB) support | Yes | Yes |
Symmetric multiprocessing (SMP) support | Yes | Yes |
Embedded SQL support | Yes | Yes |
Unicode support | Yes | Yes |
Import/export | Any ODBC data source |
xBASE, ASCII, Lotus, DIF |
Microsoft Distributed Transaction Coordinator (MS DTC) | Yes | No |
Database Statistics | ||
Databases per server | 32,767 | 255 |
Index types | Clustered and nonclustered | Nonclustered |
Maximum database size | 1,048,516 terabytes | 12 terabytes |
Columns per index | 16 | 999 |
Object name length (in characters) | 128 | 128 |
Table Statistics | ||
Indexes per table | 249 | 32,767 |
Maximum table size | Limited to database size |
1,024 GB |
Tables per query | 256 | 32,767 |
Tables per database | 2 billion | 32,767 |
Columns per table | 1,024 | 999 |
Row size | 8,060 bytes | 2 GB |
BLOB size per column | 2 GB | 32,767 bytes |
Rows per table | Limited to database size |
Maximum table size |
Security | ||
Integrated Windows NT security | Yes | Yes |
Support for Windows NT groups | Yes | No |
Roles-based security | Yes | No |
Replication4 | ||
Transactional (near real time) | Yes | No |
Merge (two-way) | Yes | Yes |
Snapshot | Yes | No |
Homogeneous | Yes | No |
Administration Tools | ||
Central management console | Yes | Yes |
Programmable management console | Yes | No |
Group management | Yes | No |
DTS | Yes | No |
Performance monitoring | Yes (Windows NT) | Yes |
Query analyzer | Yes | Yes |
Query profiler for tracing SQL network traffic | Yes | No |
Wizards | Yes | Yes |
Alert notification | Yes | No |
* Source: Sybase Adaptive Server Anywhere Reviewer's Guide
1 Sybase documentation states from 8 MB through 16 MB. This does not include the operating system.
2 The Microsoft SQL Server figure includes the master system database.
3 Sybase Central, PowerDynamo, and other tools require the Windows NT, Windows 95 or Windows 98 operating systems.
4 Sybase recommends Replication Server for robust replication.