Overview
You can perform actions from the migration jobs list or from the single migration page. You can perform an action on multiple jobs simultaneously on migration jobs that all have the same status.
Stop a running migration job at any time. During either the full dump phase or the CDC phase, the data migration is halted, and the migration job status changes to Stopping
and subsequently to Stopped
.
- If the migration job is stopped during the full dump phase, then you can delete or restart the job.
- If the migration job is stopped during the change data capture (CDC) phase, then you can resume, promote, or delete the job.
If the time period between stopping the replication and resuming it is too long, the log position may be lost and the migration job must be deleted or recreated.
If a migration was stopped during the CDC phase, then it can be resumed. Resuming the migration job resumes replication of the events that were accumulated during the stopped time.
If the migration failed and isn't recoverable, or was stopped during a full dump, then it can be restarted from the beginning.
Restarting the migration wipes all data from the destination instance; then the migration restarts immediately, including with a new dump. If the dump was manually provided, then it's highly likely that the restart will fail because the dump will be out of date.
- If the migration job status was
Completed, then the record is deleted from the migration job list. - If the migration job was in any other status, then there's an option to choose to delete the destination Cloud SQL instance/primary pair.
