ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Populates the dbo.migrate_remote_fks_list table.
sa_migrate_create_remote_fks_list ( server_name )
None
None
sa_migrate_create_remote_table_list system procedure
sa_migrate_create_tables system procedure
sa_migrate_data system procedure
sa_migrate_create_fks system procedure
sa_migrate_drop_proxy_tables system procedure
Migrating databases to Adaptive Server Anywhere
The sa_migrate_create_remote_fks_list 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 populates the dbo.migrate_remote_fks_list table with a list of foreign keys that can be migrated from the remote database. You can delete rows from this table for foreign keys that you do not want to migrate.
As an alternative, you can migrate all tables in one step using the sa_migrate system procedure.
server_name The name of the remote server that is being used to connect to the remote database. The remote server is created with the CREATE SERVER statement. A value is required for this parameter.
For more information, see CREATE SERVER statement.
The following statement creates a list of foreign keys that are in the remote database.
CALL sa_migrate_create_remote_fks_list ( 'local_a' )