Help Center/ GaussDB(for MySQL)/ Best Practices/ From Other Cloud MySQL to GaussDB(for MySQL)/ Checking Migration Results
Updated on 2023-10-19 GMT+08:00
View PDF

Checking Migration Results

You can use either of the following methods to check the migration results:

  1. DRS compares migration objects, users, and data and provide comparison results. For details, see Checking the Migration Results on the DRS Console.
  2. Log in to the destination side to check whether the databases, tables, and data are migrated. Confirm the data migration status. For details, see Checking the Migration Results on the GaussDB(for MySQL) Console.

Checking the Migration Results on the DRS Console

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select region EU-Dublin.
  3. Under the service list, choose Databases > Data Replication Service.
  4. Click the DRS instance name.
  5. Click Migration Comparison and select Object-Level Comparison to check whether database objects are missing.
  6. Choose Data-Level Comparison and check whether the number of rows of migrated objects is consistent.
  7. Click Account-Level Comparison and check whether the accounts and permissions of the source and destination instances are the same.

Checking the Migration Results on the GaussDB(for MySQL) Console

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select region EU-Dublin.
  3. Under the service list, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, locate the destination instance, and click Log In in the Operation column.

  5. In the dialog box that is displayed, enter the password and click Test Connection.
  6. After the connection is successful, click Log In.
  7. Check whether the destination databases and tables are the same as the source instance. Check whether migration is complete.