Verifying a migration
In this page, you confirm that the migration job migrated data from your source database instance to the destination Cloud SQL database instance correctly.At a minimum, verify that the database instance and its tables exist in the Cloud SQL instance. You can also verify the tables' row counts or exact contents.
The following steps show a minimal example:
- Go to the SQL Instances page in the Google Cloud console.
- Click the read replica entry of your migration job.
- Click the Activate Cloud Shell icon that appears in the upper-right region of the page.
- At the Cloud Shell prompt, press Enter.
- Optional: If an Authorize Cloud Shell dialog box appears, then click Authorize.
- At the Enter password prompt, enter the password that you either provided or that Database Migration Service generated for you in Define and create the destination Cloud SQL instance.
- Run SQL commands to verify the migration. For example:
- At the mysql prompt, enter
show databases;
to list the databases and verify that you see your source database instance. - At the mysql prompt, enter
use source_database_instance_name;
because you want to see the tables associated with this database instance. - At the mysql prompt, enter
show tables;
to see the tables of this instance. - At the mysql prompt, enter
select * from table_name;
to see the information that's contained in a table of your source database instance. - Verify that you see the correct information in the table.
- At the mysql prompt, enter
If everything you check is as you expect, then Database Migration Service has migrated the data correctly.