Creates a proxy table and base table for each table listed in the dbo.migrate_remote_table_list table.

Syntax

sa_migrate_create_tables( i_table_owner )

Arguments

Remarks

This procedure creates a base table and proxy table for each table listed in the dbo.migrate_remote_table_list table (created using the sa_migrate_create_remote_table_list procedure). These proxy tables and base tables are owned by the user specified by the i_table_owner argument. This procedure also creates the same primary key indexes and other indexes for the new table that the remote table has in the remote database.

If you do not want all the migrated tables to have the same owner on the target SQL Anywhere database, you must execute the sa_migrate_create_remote_table_list procedure and the sa_migrate_create_tables procedure for each user who will own migrated tables.

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

• Migrating databases to SQL Anywhere
• sa_migrate system procedure
• sa_migrate_create_remote_table_list system procedure
• sa_migrate_data system procedure
• sa_migrate_create_remote_fks_list system procedure
• sa_migrate_create_fks system procedure
• sa_migrate_drop_proxy_tables system procedure

Example

The following statement creates base tables and proxy tables on the target SQL Anywhere database. These tables belong to the user local_a.

CALL sa_migrate_create_tables( 'local_a' );