Help Center/ Relational Database Service/ Best Practices/ RDS for MySQL/ Migrating Data from Self-Managed MySQL Databases to RDS for MySQL/ Cloud Migration/ Confirming Migration Results
Updated on 2024-09-06 GMT+08:00
View PDF
Share

Confirming Migration Results

You can check migration results with either of the following methods:

Automatic: Viewing Migration Results on the DRS Console. DRS automatically compares migration objects, users, and data of source and destination databases and provides migration results.

Manual: Viewing Migration Results on the RDS Console. You can log in to the destination instance to check whether the databases, tables, and data are migrated.

Viewing Migration Results on the DRS Console

  1. Log in to the management console.
  2. Click in the upper left corner and select CN-Hong Kong.
  3. Click the service list icon on the left and choose Databases > Data Replication Service.
  4. Locate the required DRS instance and click its name.
  5. Click Migration Comparison.

    Figure 1 Migration comparison

  6. Select Compare Data - Validate All Rows/Values and Compare Data -Double Check During Cutover to check whether the objects of the source database have been migrated to the destination database.

    If any check fails, rectify the fault by referring to Solutions to Failed Check Items.

Viewing Migration Results on the RDS Console

  1. Log in to the management console.
  2. Click in the upper left corner and select CN-Hong Kong.
  3. Click the service list icon on the left and choose Databases > Relational Database Service.
  4. Locate the required RDS instance and click Log In in the Operation column.
  5. In the displayed dialog box, enter the password and click Test Connection.
  6. After the connection test is successful, click Log In.
  7. Check and confirm the destination database name and table name. Check whether the data migration is complete.
Parent Topic: Cloud Migration