Updated on 2024-01-02 GMT+08:00

Creating Table Structures in the Destination Database

Currently, only data can be migrated from the source RDS for MySQL database to the destination DDM instance. Source table structures and other objects cannot be migrated, so you need to create table structures and indexes in the destination database based on the table structures of the source schema. Objects that are not created in the destination database are not to be migrated. For more constraints, see Before You Start.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select CN-Hong Kong.
  3. Click Service List on the left and choose Databases > Distributed Database Middleware.
  4. On the Instances page, locate the required instance and click Log In in the Operation column.
  5. On the displayed page, enter the username and password created in Creating a DDM Account, and then click Test Connection.
  6. After the connection is successful, click Log In to log in to the DDM instance.
  7. Click the db_test schema created in Creating a Schema and Associating It with the RDS for MySQL Instance.
  8. Run the following statements in database db_test to create table table3_ with the same structure as the source table:

    CREATE TABLE `db_test`.`table3_` (
    	`Column1` INT(11) UNSIGNED NOT NULL,
    	`Column2` TIME NULL,
    	`Column3` CHAR NULL,
    	PRIMARY KEY (`Column1`)
    )	ENGINE = InnoDB
    	DEFAULT CHARACTER SET = utf8mb4
    	COLLATE = utf8mb4_general_ci;