SQL Remote User's Guide
Deploying and Synchronizing Databases
Using the extraction utility
Using the extraction utility for Adaptive Server Enterprise
There are some features in Adaptive Server Enterprise that are either not supported or are only partially supported in Adaptive Server Anywhere. The extraction utility handles some of these features partially, and some not at all.
For a full description of Adaptive Server Enterprise/Adaptive Server Anywhere compatibility, see the part Transact-SQL Compatibility, in the Adaptive Server Anywhere User's Guide.
Features not supported in ssxtract include the following:
Grouped procedures Adaptive Server Anywhere does not support procedure groups, and they are not extracted by ssxtract.
Named constraints and defaults Adaptive Server Anywhere does not support named constraints and named defaults. Any such objects are extracted directly as constraints and defaults that apply to a single object, and the name is lost.
Roles ssxtract extracts roles using the Adaptive Server Anywhere concept of groups. It creates a group with the named role, and assigns users to it.
Passwords If the user for whom a database is being extracted does not have an entry in SYSLOGINS, no password is extracted. If the user does have a login ID, a dummy password is extracted.
NCHAR, NVARCHAR These data types are extracted as CHAR and VARCHAR, with NULLS allowed.
timestamp columns Although Adaptive Server Anywhere does provide a timestamp column, it is a different data type from that of Adaptive Server Enterprise. Timestamp columns are not extracted.