Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures

 

sa_migrate_create_remote_fks_list system procedure

Populates the dbo.migrate_remote_fks_list table.

Syntax
sa_migrate_create_remote_fks_list( server_name )
Arguments
  • server_name   Use this VARCHAR(128) parameter to specify 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. See CREATE SERVER statement.

Remarks

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. See sa_migrate_create_fks system procedure.

Permissions

None

Side effects

None

See also
Example

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

CALL sa_migrate_create_remote_fks_list( 'server_a' );