oci_database_migration_migration

This resource provides the Migration resource in Oracle Cloud Infrastructure Database Migration service.

Create a Migration resource that contains all the details to perform the database migration operation, such as source and destination database details, credentials, etc.

Example Usage

resource "oci_database_migration_migration" "test_migration" {
	#Required
	compartment_id = var.compartment_id
	source_database_connection_id = oci_database_migration_connection.test_connection.id
	target_database_connection_id = oci_database_migration_connection.test_connection.id
	type = var.migration_type

	#Optional
	advisor_settings {

		#Optional
		is_ignore_errors = var.migration_advisor_settings_is_ignore_errors
		is_skip_advisor = var.migration_advisor_settings_is_skip_advisor
	}
	agent_id = oci_database_migration_agent.test_agent.id
	csv_text = var.migration_csv_text
	data_transfer_medium_details {

		#Optional
		database_link_details {

			#Optional
			name = var.migration_data_transfer_medium_details_database_link_details_name
			wallet_bucket {
				#Required
				bucket = var.migration_data_transfer_medium_details_database_link_details_wallet_bucket_bucket
				namespace = var.migration_data_transfer_medium_details_database_link_details_wallet_bucket_namespace
			}
		}
		object_storage_details {
			#Required
			bucket = var.migration_data_transfer_medium_details_object_storage_details_bucket
			namespace = var.migration_data_transfer_medium_details_object_storage_details_namespace
		}
	}
	datapump_settings {

		#Optional
		data_pump_parameters {

			#Optional
			estimate = var.migration_datapump_settings_data_pump_parameters_estimate
			exclude_parameters = var.migration_datapump_settings_data_pump_parameters_exclude_parameters
			export_parallelism_degree = var.migration_datapump_settings_data_pump_parameters_export_parallelism_degree
			import_parallelism_degree = var.migration_datapump_settings_data_pump_parameters_import_parallelism_degree
			is_cluster = var.migration_datapump_settings_data_pump_parameters_is_cluster
			table_exists_action = var.migration_datapump_settings_data_pump_parameters_table_exists_action
		}
		export_directory_object {
			#Required
			name = var.migration_datapump_settings_export_directory_object_name

			#Optional
			path = var.migration_datapump_settings_export_directory_object_path
		}
		import_directory_object {
			#Required
			name = var.migration_datapump_settings_import_directory_object_name

			#Optional
			path = var.migration_datapump_settings_import_directory_object_path
		}
		job_mode = var.migration_datapump_settings_job_mode
		metadata_remaps {
			#Required
			new_value = var.migration_datapump_settings_metadata_remaps_new_value
			old_value = var.migration_datapump_settings_metadata_remaps_old_value
			type = var.migration_datapump_settings_metadata_remaps_type
		}
	}
	defined_tags = {"foo-namespace.bar-key"= "value"}
	display_name = var.migration_display_name
	dump_transfer_details {

		#Optional
		source {
			#Required
			kind = var.migration_dump_transfer_details_source_kind

			#Optional
			oci_home = var.migration_dump_transfer_details_source_oci_home
			wallet_location = var.migration_dump_transfer_details_source_wallet_location
		}
		target {
			#Required
			kind = var.migration_dump_transfer_details_target_kind

			#Optional
			oci_home = var.migration_dump_transfer_details_target_oci_home
			wallet_location = var.migration_dump_transfer_details_target_wallet_location
		}
	}
	exclude_objects {
		#Required
		object = var.migration_exclude_objects_object
		owner = var.migration_exclude_objects_owner

		#Optional
		is_omit_excluded_table_from_replication = var.migration_exclude_objects_is_omit_excluded_table_from_replication
		type = var.migration_exclude_objects_type
	}
	freeform_tags = {"bar-key"= "value"}
	golden_gate_details {
		#Required
		hub {
			#Required
			rest_admin_credentials {
				#Required
				password = var.migration_golden_gate_details_hub_rest_admin_credentials_password
				username = var.migration_golden_gate_details_hub_rest_admin_credentials_username
			}
			url = var.migration_golden_gate_details_hub_url

			#Optional
			compute_id = oci_database_migration_compute.test_compute.id
			source_container_db_admin_credentials {
				#Required
				password = var.migration_golden_gate_details_hub_source_container_db_admin_credentials_password
				username = var.migration_golden_gate_details_hub_source_container_db_admin_credentials_username
			}
			source_db_admin_credentials {
				#Required
				password = var.migration_golden_gate_details_hub_source_db_admin_credentials_password
				username = var.migration_golden_gate_details_hub_source_db_admin_credentials_username
			}
			source_microservices_deployment_name = oci_apigateway_deployment.test_deployment.name
			target_db_admin_credentials {
				#Required
				password = var.migration_golden_gate_details_hub_target_db_admin_credentials_password
				username = var.migration_golden_gate_details_hub_target_db_admin_credentials_username
			}
			target_microservices_deployment_name = oci_apigateway_deployment.test_deployment.name
		}

		#Optional
		settings {

			#Optional
			acceptable_lag = var.migration_golden_gate_details_settings_acceptable_lag
			extract {

				#Optional
				long_trans_duration = var.migration_golden_gate_details_settings_extract_long_trans_duration
				performance_profile = var.migration_golden_gate_details_settings_extract_performance_profile
			}
			replicat {

				#Optional
				map_parallelism = var.migration_golden_gate_details_settings_replicat_map_parallelism
				max_apply_parallelism = var.migration_golden_gate_details_settings_replicat_max_apply_parallelism
				min_apply_parallelism = var.migration_golden_gate_details_settings_replicat_min_apply_parallelism
			}
		}
	}
	golden_gate_service_details {

		#Optional
		settings {

			#Optional
			acceptable_lag = var.migration_golden_gate_service_details_settings_acceptable_lag
			extract {

				#Optional
				long_trans_duration = var.migration_golden_gate_service_details_settings_extract_long_trans_duration
				performance_profile = var.migration_golden_gate_service_details_settings_extract_performance_profile
			}
			replicat {

				#Optional
				map_parallelism = var.migration_golden_gate_service_details_settings_replicat_map_parallelism
				max_apply_parallelism = var.migration_golden_gate_service_details_settings_replicat_max_apply_parallelism
				min_apply_parallelism = var.migration_golden_gate_service_details_settings_replicat_min_apply_parallelism
			}
		}
		source_container_db_credentials {
			#Required
			password = var.migration_golden_gate_service_details_source_container_db_credentials_password
			username = var.migration_golden_gate_service_details_source_container_db_credentials_username
		}
		source_db_credentials {
			#Required
			password = var.migration_golden_gate_service_details_source_db_credentials_password
			username = var.migration_golden_gate_service_details_source_db_credentials_username
		}
		target_db_credentials {
			#Required
			password = var.migration_golden_gate_service_details_target_db_credentials_password
			username = var.migration_golden_gate_service_details_target_db_credentials_username
		}
	}
	include_objects {
		#Required
		object = var.migration_include_objects_object
		owner = var.migration_include_objects_owner

		#Optional
		is_omit_excluded_table_from_replication = var.migration_include_objects_is_omit_excluded_table_from_replication
		type = var.migration_include_objects_type
	}
	source_container_database_connection_id = oci_database_migration_connection.test_connection.id
	vault_details {
		#Required
		compartment_id = var.compartment_id
		key_id = oci_kms_key.test_key.id
		vault_id = oci_kms_vault.test_vault.id
	}
}

Argument Reference

The following arguments are supported:

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Attributes Reference

The following attributes are exported:

Timeouts

The timeouts block allows you to specify timeouts for certain operations: * create - (Defaults to 20 minutes), when creating the Migration * update - (Defaults to 20 minutes), when updating the Migration * delete - (Defaults to 20 minutes), when destroying the Migration

Import

Migrations can be imported using the id, e.g.

$ terraform import oci_database_migration_migration.test_migration "id"