Migrate data by using SQL scripts

You can use SQL scripts to migrate data and resource units between tables.

Data migration between tables

You can use the INSERT INTO......SELECT statement to synchronize data between tables.

The following example statement inserts data from table_A to table_B:

INSERT INTO table_B
SELECT col1,col2 from table_A
WHERE [expr];

Resource unit migration

The following example statement initiates the migration of resource units:

ALTER SYSTEM MIGRATE
UNIT = [unit_id] DESTINATION = [ip_port]

The following example statement cancels the migration of resource units:

obclient> ALTER SYSTEM CANCEL MIGRATE UNIT unit_id;