ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Drops the proxy tables that were created for migration purposes.
sa_migrate_drop_proxy_tables ( local_table_owner )
None
None
sa_migrate_create_remote_table_list system procedure
sa_migrate_create_tables system procedure
sa_migrate_data system procedure
sa_migrate_create_remote_fks_list system procedure
sa_migrate_create_fks system procedure
Migrating databases to Adaptive Server Anywhere
The sa_migrate_drop_proxy_tables stored procedure is used with the other migration stored procedures. These procedures must be executed in the following order:
sa_migrate_create_remote_table_list
sa_migrate_create_tables
sa_migrate_data
sa_migrate_create_remote_fks_list
sa_migrate_create_fks
sa_migrate_drop_proxy_tables
This procedure drops the proxy tables that were created for the migration. The user who owns these proxy tables is specified by the local_table_owner argument.
If the migrated tables are not all owned by the same user on the target Adaptive Server Anywhere database, you must call this procedure for each user in order to drop all the proxy tables.
As an alternative, you can migrate all tables in one step using the sa_migrate system procedure.
local_table_owner The user on the target Adaptive Server Anywhere database who owns the proxy tables. This user is created using the GRANT CONNECT statement. A value is required for this parameter.
For more information, see GRANT statement.
The following statement drops the proxy tables on the target Adaptive Server Anywhere database that belong to the user local_a.
CALL sa_migrate_drop_proxy_tables( 'local_a' )