Contents Index An overview of Transact-SQL support Servers and databases

ASA SQL User's Guide
  Transact-SQL Compatibility

Adaptive Server architectures


Adaptive Server Enterprise and Adaptive Server Anywhere are complementary products, with architectures designed to suit their distinct purposes. Adaptive Server Anywhere works well as a workgroup or departmental server requiring little administration, and as a personal database. Adaptive Server Enterprise works well as an enterprise-level server for the largest databases.

This section describes architectural differences between Adaptive Server Enterprise and Adaptive Server Anywhere. It also describes the Adaptive Server Enterprise-like tools that Adaptive Server Anywhere includes for compatible database management.


Servers and databases
Device management
Defaults and rules
System tables
Administrative roles
Users and groups

Contents Index An overview of Transact-SQL support Servers and databases