--- 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 | | 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 | 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 |