sa_migrate_create_remote_fks_list( server_name )

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.

This system procedure is used in conjunction with several other migration system procedures. The note in the Remarks section of the sa_migrate_create_fks system procedure contains the list of migrate procedures, and the order in which you must execute them.

None

None

• CREATE SERVER statement
• Database migration to SQL Anywhere
• sa_migrate system procedure
• 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

The following statement creates a list of foreign keys that are in the remote database.

CALL sa_migrate_create_remote_fks_list( 'server_a' );