Migration Hub:Batch assistant parameter reference

Parameter

Description

Remarks

Task name

Task name for this migration configuration.

Instance type

Source or destination instance type.

Alibaba Cloud database:

• RDS: ApsaraDB RDS for MySQL, ApsaraDB RDS for SQL Server, ApsaraDB RDS for PostgreSQL, or ApsaraDB RDS for MariaDB TX instance

• PolarDB: PolarDB for MySQL cluster

Self-managed database:

• OTHER: self-managed database that can be accessed from a public IP address

• EXPRESS: self-managed database that is connected over Express Connect

• DG: self-managed database that is connected over Database Gateway

Note

• To migrate from a self-managed database, complete the prerequisites inPreparation overview.

Instance area

Region of the source or destination instance.

• Use a region ID from the Appendix: Region IDs section below.

Instance ID

The instance ID.

• The instance ID must be unique within a task.

• If the instance with the specified ID has been used in a migration plan, make sure that the instance is not in the Migrating state.

• For an Alibaba Cloud database, use the database instance ID. For example, if Instance type is RDS and Database type is MYSQL, specify the ApsaraDB RDS for MySQL instance ID.

• For OTHER instance type, set to any random string.

• For EXPRESS instance type, set to the VPC ID connected to the source database.

• For DG instance type, set to the database gateway ID.

Database type

Database engine of the source or destination instance.

• MYSQL: ApsaraDB RDS for MySQL instance or self-managed MySQL database

• POLARDB_O: PolarDB for Oracle cluster

• ORACLE: self-managed Oracle database

Database name

Source or destination database name.

• Required only when Database type is POLARDB_O.

IP address

IP address of the source or destination database.

• Required only when Instance type isOTHER, EXPRESS, or DG from the Instance type drop-down list.

Port

Port for connecting to the source or destination database.

• Required only when IP address is configured.

Database account

Database account for the migration.

• The account must have read and write permissions on the databases and tables to migrate.

Database password

Password of the database account for the migration.

Table mapping definition

Database and table mappings for the migration.

• CMH provides example table mapping definitions.

• Objects of DTS tasks.

Parameter

Description

Remarks

Batch assistant name

The name of the batch assistant task.

Database type

The database engine of the source instance.

• Automatically configured.

• Used for identification only. Does not affect Step 1 configurations.

Migration type

The migration method.

• Full migration: schema migration and full data migration.

• Full + Incremental Migration: schema migration, full migration, and incremental migration.

• Incremental migration does not stop automatically. Manually stop the task in the DTS console.

Instance size

Specifications of the purchased DTS instance.

Migration plan name

Target migration plan for this task.

• The submitted task is automatically added to the specified migration plan.

• If the task already exists in another plan, the system moves it to the newly specified plan.

Whether to start the migration task automatically

Specifies whether to start the migration task automatically.

• Yes: Precheck and migration start automatically after submission.

• No: Precheck starts automatically, but you must manually start migration in the DTS console.

Whether to join packet scheduling

Whether to add the task to a scheduling group.

• Yes: adds the task to an Open scheduling group. CMH schedules the task based on the configured rules.

• No: the task starts immediately after submission without scheduling.

Region

Region ID

China (Hangzhou)

cn-hangzhou

China (Shanghai)

cn-shanghai

China (Qingdao)

cn-qingdao

China (Beijing)

cn-beijing

China (Zhangjiakou)

cn-zhangjiakou

China (Hohhot)

cn-huhehaote

China (Shenzhen)

cn-shenzhen

China (Heyuan)

cn-heyuan

China (Guangzhou)

cn-guangzhou

China (Chengdu)

cn-chengdu

China (Hong Kong)

cn-hongkong

Singapore

ap-southeast-1

Malaysia (Kuala Lumpur)

ap-southeast-3

Indonesia (Jakarta)

ap-southeast-5

Philippines (Manila)

ap-southeast-6

Thailand (Bangkok)

ap-southeast-7

Japan (Tokyo)

ap-northeast-1

South Korea (Seoul)

ap-northeast-2

US (Silicon Valley)

us-west-1

US (Virginia)

us-east-1

Germany (Frankfurt)

eu-central-1

UK (London)

eu-west-1

SAU (Riyadh - Partner Region)

me-central-1

UAE (Dubai)

me-east-1

China East 1 Finance

cn-hangzhou-finance

China East 2 Finance

cn-shanghai-finance-1

China South 1 Finance

cn-shenzhen-finance-1

China North 2 Finance (Preview)

cn-beijing-finance-1

China North 2 Ali Gov 1

cn-north-2-gov-1