Database Migration Service MigrationJob

Database Migration Service MigrationJob in Google Cloud is a managed resource that defines and manages the process of migrating data from a source database to a target database. It handles configuration details such as connection profiles, migration type (one-time or continuous), and execution state. This resource simplifies moving databases into Google Cloud with minimal downtime and reduced manual effort.

gcp.datamigration_migration_job

Fields

TitleIDTypeData TypeDescription
_keycorestring
ancestorscorearray<string>
cmek_key_namecorestringThe CMEK (customer-managed encryption key) fully qualified key name used for the migration job. This field supports all migration jobs types except for: * Mysql to Mysql (use the cmek field in the cloudsql connection profile instead). * PostrgeSQL to PostgreSQL (use the cmek field in the cloudsql connection profile instead). * PostgreSQL to AlloyDB (use the kms_key_name field in the alloydb connection profile instead). Each Cloud CMEK key has the following format: projects/[PROJECT]/locations/[REGION]/keyRings/[RING]/cryptoKeys/[KEY_NAME]
conversion_workspacecorejsonThe conversion workspace used by the migration.
create_timecoretimestampOutput only. The timestamp when the migration job resource was created. A timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds. Example: "2014-10-02T15:01:23.045123456Z".
datadog_display_namecorestring
destinationcorestringRequired. The resource name (URI) of the destination connection profile.
destination_databasecorejsonThe database engine type and provider of the destination.
dump_flagscorejsonThe initial dump flags. This field and the "dump_path" field are mutually exclusive.
dump_pathcorestringThe path to the dump file in Google Cloud Storage, in the format: (gs://[BUCKET_NAME]/[OBJECT_NAME]). This field and the "dump_flags" field are mutually exclusive.
dump_typecorestringOptional. The type of the data dump. Supported for MySQL to CloudSQL for MySQL migrations only.
durationcorestringOutput only. The duration of the migration job (in seconds). A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
end_timecoretimestampOutput only. If the migration job is completed, the time when it was completed.
errorcorejsonOutput only. The error details in case of state FAILED.
filtercorestringThis field can be used to select the entities to migrate as part of the migration job. It uses AIP-160 notation to select a subset of the entities configured on the associated conversion-workspace. This field should not be set on migration-jobs that are not associated with a conversion workspace.
gcp_display_namecorestringThe migration job display name.
gcp_sourcecorestringRequired. The resource name (URI) of the source connection profile.
labelscorearray<string>The resource labels for migration job to use to annotate any related underlying resources such as Compute Engine VMs. An object containing a list of "key": "value" pairs. Example: `{ "name": "wrench", "mass": "1.3kg", "count": "3" }`.
namecorestringThe name (URI) of this migration job resource, in the form of: projects/{project}/locations/{location}/migrationJobs/{migrationJob}.
objects_configcorejsonOptional. The objects that need to be migrated.
oracle_to_postgres_configcorejsonConfiguration for heterogeneous **Oracle to Cloud SQL for PostgreSQL** and **Oracle to AlloyDB for PostgreSQL** migrations.
organization_idcorestring
parentcorestring
performance_configcorejsonOptional. Data dump parallelism settings used by the migration.
phasecorestringOutput only. The current migration job phase.
project_idcorestring
project_numbercorestring
resource_namecorestring
reverse_ssh_connectivitycorejsonThe details needed to communicate to the source over Reverse SSH tunnel connectivity.
satisfies_pzicoreboolOutput only. Reserved for future use.
satisfies_pzscoreboolOutput only. Reserved for future use.
source_databasecorejsonThe database engine type and provider of the source.
sqlserver_homogeneous_migration_job_configcorejsonOptional. Configuration for SQL Server homogeneous migration.
sqlserver_to_postgres_configcorejsonConfiguration for heterogeneous **SQL Server to Cloud SQL for PostgreSQL** migrations.
statecorestringThe current migration job state.
static_ip_connectivitycorejsonstatic ip connectivity data (default, no additional details needed).
tagscorehstore
typecorestringRequired. The migration job type.
update_timecoretimestampOutput only. The timestamp when the migration job resource was last updated. A timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds. Example: "2014-10-02T15:01:23.045123456Z".
vpc_peering_connectivitycorejsonThe details of the VPC network that the source database is located in.