Specifications

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.