Help Center/ Distributed Database Middleware/ Best Practices/ Migrating Data from RDS for MySQL to DDM Using DRS/ Preparing for the Destination DDM Instance/ Creating Table Structures in the Destination Database
Updated on 2022-08-01 GMT+08:00
View PDF
Share

Creating Table Structures in the Destination Database

Currently, only data can be migrated from RDS for MySQL instances to DDM instances. To migrate table structures and other objects, you need to create table structures and indexes in the destination database based on table structures of the source schema. Any source objects that have no corresponding objects created in the destination cannot be migrated. For more constraints, see Before You Start.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select region CN-Hong Kong.
  3. Click the service list icon 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. In the displayed dialog box, enter the username and password created in Creating a DDM Account, and 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 SQL statements in database db_test to create table table3_ with the same structure as the source: 

    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;