sa_migrate_create_fks system procedure

Creates foreign keys for each table listed in the dbo.migrate_remote_fks_list table.

Syntax
sa_migrate_create_fks( i_table_owner )
Arguments
  • i_table_owner   Use this VARCHAR(128) parameter to specify the user on the target SQL Anywhere database who owns the migrated foreign keys. If you want to migrate tables that belong to different user, you must execute this procedure for each user whose tables you want to migrate. The i_table_owner is created using the GRANT CONNECT statement. A value is required for this parameter. See GRANT statement.

Remarks

This procedure creates foreign keys for each table that is listed in the dbo.migrate_remote_fks_list table. The user specified by the i_table_owner argument owns the foreign keys in the target database.

If the tables in the target SQL Anywhere database do not all have the same owner, you must execute this procedure for each user who owns tables for which you need to migrate foreign keys.

Note

This system procedure is used in conjunction with several other migration system procedures, which must be executed in sequence as listed below:

  1. sa_migrate_create_remote_table_list

  2. sa_migrate_create_tables

  3. sa_migrate_data

  4. sa_migrate_create_remote_fks_list

  5. sa_migrate_create_fks

  6. sa_migrate_drop_proxy_tables

As an alternative, you can migrate all tables in one step using the sa_migrate system procedure.

Permissions

None

Side effects

None

See also
Example

The following statement creates foreign keys based on the dbo.migrate_remote_fks_list table. The foreign keys belong to the user local_a on the local SQL Anywhere database.

CALL sa_migrate_create_fks( 'local_a' );