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.