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.
You can perform some of the actions on migration jobs only, while other actions can be performed also on selected databases in a migration job.
User action
Description
Edit
Perform the edit action if you want to make the following changes:
Change between migrating all databases and specific databases.
Add or remove databases in any migration state or phase. You must save the job after you make the changes.
Edit the data dump parallelism level of a running migration job. You must save and restart the job after you make the changes.
Start
Start migration jobs that were created without being started.
Stop
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. However, WAL logs will continue to accumulate in the replication slots, eventually leading to your source database running out of disk space. In addition, Database Migration Service will keep pulling a replication delay, which means that Database Migration Service will continue to consume network traffic.
If the migration job is stopped during the change data capture (CDC) phase, then you can promote or delete the job.
Monitor the replication slot and disk size of your database server. You can choose to delete the migration job, which will clean all replication slots and network traffic.
Resume
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.
Restart
If the migration failed and isn't recoverable, or was stopped during a
full dump, then it can be restarted from the beginning.
If the replication has failed because of an error on one or more source or destination databases, then restarting the migration will wipe all data from any destination databases that are impacted by the errors.
If new databases were created on the source PostgreSQL server since starting the migration, then restarting the migration will also replicate the new databases into the destination instance.
Delete
A migration job can be deleted. The outcome depends on the status of
the job:
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-02-14 UTC."],[],[]]