Contents Index Adaptive Server Enterprise features unsupported in Adaptive Server Anywhere Synchronizing data over a message system

SQL Remote User's Guide
  Deploying and Synchronizing Databases
    Using the extraction utility
      Using the extraction utility for Adaptive Server Enterprise

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.

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.

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.


Contents Index Adaptive Server Enterprise features unsupported in Adaptive Server Anywhere Synchronizing data over a message system