# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/gcp/gcp.datamigration_migration_job.dataset.md

---
title: Database Migration Service MigrationJob
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: >-
  Docs > DDSQL Reference > Data Directory > Database Migration Service
  MigrationJob
---

# 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

| Title                                      | ID   | Type          | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Description |
| ------------------------------------------ | ---- | ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                                       | core | string        |
| ancestors                                  | core | array<string> |
| cmek_key_name                              | core | string        | The 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_workspace                       | core | json          | The conversion workspace used by the migration.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| create_time                                | core | timestamp     | Output 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_name                       | core | string        |
| destination                                | core | string        | Required. The resource name (URI) of the destination connection profile.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| destination_database                       | core | json          | The database engine type and provider of the destination.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| dump_flags                                 | core | json          | The initial dump flags. This field and the "dump_path" field are mutually exclusive.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| dump_path                                  | core | string        | The 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_type                                  | core | string        | Optional. The type of the data dump. Supported for MySQL to CloudSQL for MySQL migrations only.                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| duration                                   | core | string        | Output 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_time                                   | core | timestamp     | Output only. If the migration job is completed, the time when it was completed.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| error                                      | core | json          | Output only. The error details in case of state FAILED.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| filter                                     | core | string        | This 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_name                           | core | string        | The migration job display name.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| gcp_source                                 | core | string        | Required. The resource name (URI) of the source connection profile.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| labels                                     | core | array<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" }`.                                                                                                                                                                                                                                                                                                                       |
| name                                       | core | string        | The name (URI) of this migration job resource, in the form of: projects/{project}/locations/{location}/migrationJobs/{migrationJob}.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| objects_config                             | core | json          | Optional. The objects that need to be migrated.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| oracle_to_postgres_config                  | core | json          | Configuration for heterogeneous **Oracle to Cloud SQL for PostgreSQL** and **Oracle to AlloyDB for PostgreSQL** migrations.                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| organization_id                            | core | string        |
| parent                                     | core | string        |
| performance_config                         | core | json          | Optional. Data dump parallelism settings used by the migration.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| phase                                      | core | string        | Output only. The current migration job phase.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| project_id                                 | core | string        |
| project_number                             | core | string        |
| region_id                                  | core | string        |
| resource_name                              | core | string        |
| reverse_ssh_connectivity                   | core | json          | The details needed to communicate to the source over Reverse SSH tunnel connectivity.                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| satisfies_pzi                              | core | bool          | Output only. Reserved for future use.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| satisfies_pzs                              | core | bool          | Output only. Reserved for future use.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| source_database                            | core | json          | The database engine type and provider of the source.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| sqlserver_homogeneous_migration_job_config | core | json          | Optional. Configuration for SQL Server homogeneous migration.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| sqlserver_to_postgres_config               | core | json          | Configuration for heterogeneous **SQL Server to Cloud SQL for PostgreSQL** migrations.                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| state                                      | core | string        | The current migration job state.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| static_ip_connectivity                     | core | json          | static ip connectivity data (default, no additional details needed).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| tags                                       | core | hstore_csv    |
| type                                       | core | string        | Required. The migration job type.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| update_time                                | core | timestamp     | Output 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_connectivity                   | core | json          | The details of the VPC network that the source database is located in.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| zone_id                                    | core | string        |