Sybase SQL Remote DC38133-01-0902-01 User Manual
Chapter 9. Deploying and Synchronizing Databases
☞
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.
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.
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.
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.
Adaptive Server Enterprise. Timestamp columns are not extracted.
Customizing the system tables
The objects that are to be loaded into an Adaptive Server Anywhere database
are described in the system catalog. The extraction utility for Adaptive
Server Enterprise first creates a set of Adaptive Server Anywhere system
tables in TEMPDB, and fills them with data from the Adaptive Server
Enterprise catalog. It then unloads this set of tables to provide the reload
script that in turn builds an Adaptive Server Anywhere database.
are described in the system catalog. The extraction utility for Adaptive
Server Enterprise first creates a set of Adaptive Server Anywhere system
tables in TEMPDB, and fills them with data from the Adaptive Server
Enterprise catalog. It then unloads this set of tables to provide the reload
script that in turn builds an Adaptive Server Anywhere database.
There may be cases where you wish to change the content of the Adaptive
Server Anywhere system tables held in TEMPDB. SQL Remote provides a
place for you to do that.
Server Anywhere system tables held in TEMPDB. SQL Remote provides a
place for you to do that.
The stored procedure that creates and fills the Adaptive Server Anywhere
system objects in TEMPDB is called sp_populate_sql_anywhere. As its
final operation, this procedure calls a procedure called
sp_user_extraction_hook. This procedure, by default, does nothing. If you
wish to customize the extraction procedure, you can do so by writing a
suitable sp_user_extraction_hook procedure.
system objects in TEMPDB is called sp_populate_sql_anywhere. As its
final operation, this procedure calls a procedure called
sp_user_extraction_hook. This procedure, by default, does nothing. If you
wish to customize the extraction procedure, you can do so by writing a
suitable sp_user_extraction_hook procedure.
197