Docs Home
Oracle Cloud Infrastructure v2.17.0 published on Friday, Nov 15, 2024 by Pulumi
oci.DatabaseMigration.Migration
Explore with Pulumi AI
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testMigration = new oci.databasemigration.Migration("test_migration", {
compartmentId: compartmentId,
databaseCombination: migrationDatabaseCombination,
sourceDatabaseConnectionId: testConnection.id,
targetDatabaseConnectionId: testConnection.id,
type: migrationType,
advancedParameters: [{
dataType: migrationAdvancedParametersDataType,
name: migrationAdvancedParametersName,
value: migrationAdvancedParametersValue,
}],
advisorSettings: {
isIgnoreErrors: migrationAdvisorSettingsIsIgnoreErrors,
isSkipAdvisor: migrationAdvisorSettingsIsSkipAdvisor,
},
bulkIncludeExcludeData: migrationBulkIncludeExcludeData,
dataTransferMediumDetails: {
type: migrationDataTransferMediumDetailsType,
accessKeyId: testKey.id,
name: migrationDataTransferMediumDetailsName,
objectStorageBucket: {
bucket: migrationDataTransferMediumDetailsObjectStorageBucketBucket,
namespace: migrationDataTransferMediumDetailsObjectStorageBucketNamespace,
},
region: migrationDataTransferMediumDetailsRegion,
secretAccessKey: migrationDataTransferMediumDetailsSecretAccessKey,
sharedStorageMountTargetId: testMountTarget.id,
source: {
kind: migrationDataTransferMediumDetailsSourceKind,
ociHome: migrationDataTransferMediumDetailsSourceOciHome,
walletLocation: migrationDataTransferMediumDetailsSourceWalletLocation,
},
target: {
kind: migrationDataTransferMediumDetailsTargetKind,
ociHome: migrationDataTransferMediumDetailsTargetOciHome,
walletLocation: migrationDataTransferMediumDetailsTargetWalletLocation,
},
},
definedTags: {
"foo-namespace.bar-key": "value",
},
description: migrationDescription,
displayName: migrationDisplayName,
excludeObjects: [{
object: migrationExcludeObjectsObject,
isOmitExcludedTableFromReplication: migrationExcludeObjectsIsOmitExcludedTableFromReplication,
owner: migrationExcludeObjectsOwner,
schema: migrationExcludeObjectsSchema,
type: migrationExcludeObjectsType,
}],
freeformTags: migrationFreeformTags,
ggsDetails: {
acceptableLag: migrationGgsDetailsAcceptableLag,
extract: {
longTransDuration: migrationGgsDetailsExtractLongTransDuration,
performanceProfile: migrationGgsDetailsExtractPerformanceProfile,
},
replicat: {
performanceProfile: migrationGgsDetailsReplicatPerformanceProfile,
},
},
hubDetails: {
keyId: testKey.id,
restAdminCredentials: {
password: migrationHubDetailsRestAdminCredentialsPassword,
username: migrationHubDetailsRestAdminCredentialsUsername,
},
url: migrationHubDetailsUrl,
vaultId: testVault.id,
acceptableLag: migrationHubDetailsAcceptableLag,
computeId: testCompute.id,
extract: {
longTransDuration: migrationHubDetailsExtractLongTransDuration,
performanceProfile: migrationHubDetailsExtractPerformanceProfile,
},
replicat: {
performanceProfile: migrationHubDetailsReplicatPerformanceProfile,
},
},
includeObjects: [{
object: migrationIncludeObjectsObject,
isOmitExcludedTableFromReplication: migrationIncludeObjectsIsOmitExcludedTableFromReplication,
owner: migrationIncludeObjectsOwner,
schema: migrationIncludeObjectsSchema,
type: migrationIncludeObjectsType,
}],
initialLoadSettings: {
jobMode: migrationInitialLoadSettingsJobMode,
compatibilities: migrationInitialLoadSettingsCompatibility,
dataPumpParameters: {
estimate: migrationInitialLoadSettingsDataPumpParametersEstimate,
excludeParameters: migrationInitialLoadSettingsDataPumpParametersExcludeParameters,
exportParallelismDegree: migrationInitialLoadSettingsDataPumpParametersExportParallelismDegree,
importParallelismDegree: migrationInitialLoadSettingsDataPumpParametersImportParallelismDegree,
isCluster: migrationInitialLoadSettingsDataPumpParametersIsCluster,
tableExistsAction: migrationInitialLoadSettingsDataPumpParametersTableExistsAction,
},
exportDirectoryObject: {
name: migrationInitialLoadSettingsExportDirectoryObjectName,
path: migrationInitialLoadSettingsExportDirectoryObjectPath,
},
handleGrantErrors: migrationInitialLoadSettingsHandleGrantErrors,
importDirectoryObject: {
name: migrationInitialLoadSettingsImportDirectoryObjectName,
path: migrationInitialLoadSettingsImportDirectoryObjectPath,
},
isConsistent: migrationInitialLoadSettingsIsConsistent,
isIgnoreExistingObjects: migrationInitialLoadSettingsIsIgnoreExistingObjects,
isTzUtc: migrationInitialLoadSettingsIsTzUtc,
metadataRemaps: [{
newValue: migrationInitialLoadSettingsMetadataRemapsNewValue,
oldValue: migrationInitialLoadSettingsMetadataRemapsOldValue,
type: migrationInitialLoadSettingsMetadataRemapsType,
}],
primaryKeyCompatibility: migrationInitialLoadSettingsPrimaryKeyCompatibility,
tablespaceDetails: {
targetType: migrationInitialLoadSettingsTablespaceDetailsTargetType,
blockSizeInKbs: migrationInitialLoadSettingsTablespaceDetailsBlockSizeInKbs,
extendSizeInMbs: migrationInitialLoadSettingsTablespaceDetailsExtendSizeInMbs,
isAutoCreate: migrationInitialLoadSettingsTablespaceDetailsIsAutoCreate,
isBigFile: migrationInitialLoadSettingsTablespaceDetailsIsBigFile,
remapTarget: migrationInitialLoadSettingsTablespaceDetailsRemapTarget,
},
},
sourceContainerDatabaseConnectionId: testConnection.id,
});
import pulumi
import pulumi_oci as oci
test_migration = oci.database_migration.Migration("test_migration",
compartment_id=compartment_id,
database_combination=migration_database_combination,
source_database_connection_id=test_connection["id"],
target_database_connection_id=test_connection["id"],
type=migration_type,
advanced_parameters=[{
"data_type": migration_advanced_parameters_data_type,
"name": migration_advanced_parameters_name,
"value": migration_advanced_parameters_value,
}],
advisor_settings={
"is_ignore_errors": migration_advisor_settings_is_ignore_errors,
"is_skip_advisor": migration_advisor_settings_is_skip_advisor,
},
bulk_include_exclude_data=migration_bulk_include_exclude_data,
data_transfer_medium_details={
"type": migration_data_transfer_medium_details_type,
"access_key_id": test_key["id"],
"name": migration_data_transfer_medium_details_name,
"object_storage_bucket": {
"bucket": migration_data_transfer_medium_details_object_storage_bucket_bucket,
"namespace": migration_data_transfer_medium_details_object_storage_bucket_namespace,
},
"region": migration_data_transfer_medium_details_region,
"secret_access_key": migration_data_transfer_medium_details_secret_access_key,
"shared_storage_mount_target_id": test_mount_target["id"],
"source": {
"kind": migration_data_transfer_medium_details_source_kind,
"oci_home": migration_data_transfer_medium_details_source_oci_home,
"wallet_location": migration_data_transfer_medium_details_source_wallet_location,
},
"target": {
"kind": migration_data_transfer_medium_details_target_kind,
"oci_home": migration_data_transfer_medium_details_target_oci_home,
"wallet_location": migration_data_transfer_medium_details_target_wallet_location,
},
},
defined_tags={
"foo-namespace.bar-key": "value",
},
description=migration_description,
display_name=migration_display_name,
exclude_objects=[{
"object": migration_exclude_objects_object,
"is_omit_excluded_table_from_replication": migration_exclude_objects_is_omit_excluded_table_from_replication,
"owner": migration_exclude_objects_owner,
"schema": migration_exclude_objects_schema,
"type": migration_exclude_objects_type,
}],
freeform_tags=migration_freeform_tags,
ggs_details={
"acceptable_lag": migration_ggs_details_acceptable_lag,
"extract": {
"long_trans_duration": migration_ggs_details_extract_long_trans_duration,
"performance_profile": migration_ggs_details_extract_performance_profile,
},
"replicat": {
"performance_profile": migration_ggs_details_replicat_performance_profile,
},
},
hub_details={
"key_id": test_key["id"],
"rest_admin_credentials": {
"password": migration_hub_details_rest_admin_credentials_password,
"username": migration_hub_details_rest_admin_credentials_username,
},
"url": migration_hub_details_url,
"vault_id": test_vault["id"],
"acceptable_lag": migration_hub_details_acceptable_lag,
"compute_id": test_compute["id"],
"extract": {
"long_trans_duration": migration_hub_details_extract_long_trans_duration,
"performance_profile": migration_hub_details_extract_performance_profile,
},
"replicat": {
"performance_profile": migration_hub_details_replicat_performance_profile,
},
},
include_objects=[{
"object": migration_include_objects_object,
"is_omit_excluded_table_from_replication": migration_include_objects_is_omit_excluded_table_from_replication,
"owner": migration_include_objects_owner,
"schema": migration_include_objects_schema,
"type": migration_include_objects_type,
}],
initial_load_settings={
"job_mode": migration_initial_load_settings_job_mode,
"compatibilities": migration_initial_load_settings_compatibility,
"data_pump_parameters": {
"estimate": migration_initial_load_settings_data_pump_parameters_estimate,
"exclude_parameters": migration_initial_load_settings_data_pump_parameters_exclude_parameters,
"export_parallelism_degree": migration_initial_load_settings_data_pump_parameters_export_parallelism_degree,
"import_parallelism_degree": migration_initial_load_settings_data_pump_parameters_import_parallelism_degree,
"is_cluster": migration_initial_load_settings_data_pump_parameters_is_cluster,
"table_exists_action": migration_initial_load_settings_data_pump_parameters_table_exists_action,
},
"export_directory_object": {
"name": migration_initial_load_settings_export_directory_object_name,
"path": migration_initial_load_settings_export_directory_object_path,
},
"handle_grant_errors": migration_initial_load_settings_handle_grant_errors,
"import_directory_object": {
"name": migration_initial_load_settings_import_directory_object_name,
"path": migration_initial_load_settings_import_directory_object_path,
},
"is_consistent": migration_initial_load_settings_is_consistent,
"is_ignore_existing_objects": migration_initial_load_settings_is_ignore_existing_objects,
"is_tz_utc": migration_initial_load_settings_is_tz_utc,
"metadata_remaps": [{
"new_value": migration_initial_load_settings_metadata_remaps_new_value,
"old_value": migration_initial_load_settings_metadata_remaps_old_value,
"type": migration_initial_load_settings_metadata_remaps_type,
}],
"primary_key_compatibility": migration_initial_load_settings_primary_key_compatibility,
"tablespace_details": {
"target_type": migration_initial_load_settings_tablespace_details_target_type,
"block_size_in_kbs": migration_initial_load_settings_tablespace_details_block_size_in_kbs,
"extend_size_in_mbs": migration_initial_load_settings_tablespace_details_extend_size_in_mbs,
"is_auto_create": migration_initial_load_settings_tablespace_details_is_auto_create,
"is_big_file": migration_initial_load_settings_tablespace_details_is_big_file,
"remap_target": migration_initial_load_settings_tablespace_details_remap_target,
},
},
source_container_database_connection_id=test_connection["id"])
package main
import (
"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/DatabaseMigration"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := DatabaseMigration.NewMigration(ctx, "test_migration", &DatabaseMigration.MigrationArgs{
CompartmentId: pulumi.Any(compartmentId),
DatabaseCombination: pulumi.Any(migrationDatabaseCombination),
SourceDatabaseConnectionId: pulumi.Any(testConnection.Id),
TargetDatabaseConnectionId: pulumi.Any(testConnection.Id),
Type: pulumi.Any(migrationType),
AdvancedParameters: databasemigration.MigrationAdvancedParameterArray{
&databasemigration.MigrationAdvancedParameterArgs{
DataType: pulumi.Any(migrationAdvancedParametersDataType),
Name: pulumi.Any(migrationAdvancedParametersName),
Value: pulumi.Any(migrationAdvancedParametersValue),
},
},
AdvisorSettings: &databasemigration.MigrationAdvisorSettingsArgs{
IsIgnoreErrors: pulumi.Any(migrationAdvisorSettingsIsIgnoreErrors),
IsSkipAdvisor: pulumi.Any(migrationAdvisorSettingsIsSkipAdvisor),
},
BulkIncludeExcludeData: pulumi.Any(migrationBulkIncludeExcludeData),
DataTransferMediumDetails: &databasemigration.MigrationDataTransferMediumDetailsArgs{
Type: pulumi.Any(migrationDataTransferMediumDetailsType),
AccessKeyId: pulumi.Any(testKey.Id),
Name: pulumi.Any(migrationDataTransferMediumDetailsName),
ObjectStorageBucket: &databasemigration.MigrationDataTransferMediumDetailsObjectStorageBucketArgs{
Bucket: pulumi.Any(migrationDataTransferMediumDetailsObjectStorageBucketBucket),
Namespace: pulumi.Any(migrationDataTransferMediumDetailsObjectStorageBucketNamespace),
},
Region: pulumi.Any(migrationDataTransferMediumDetailsRegion),
SecretAccessKey: pulumi.Any(migrationDataTransferMediumDetailsSecretAccessKey),
SharedStorageMountTargetId: pulumi.Any(testMountTarget.Id),
Source: &databasemigration.MigrationDataTransferMediumDetailsSourceArgs{
Kind: pulumi.Any(migrationDataTransferMediumDetailsSourceKind),
OciHome: pulumi.Any(migrationDataTransferMediumDetailsSourceOciHome),
WalletLocation: pulumi.Any(migrationDataTransferMediumDetailsSourceWalletLocation),
},
Target: &databasemigration.MigrationDataTransferMediumDetailsTargetArgs{
Kind: pulumi.Any(migrationDataTransferMediumDetailsTargetKind),
OciHome: pulumi.Any(migrationDataTransferMediumDetailsTargetOciHome),
WalletLocation: pulumi.Any(migrationDataTransferMediumDetailsTargetWalletLocation),
},
},
DefinedTags: pulumi.StringMap{
"foo-namespace.bar-key": pulumi.String("value"),
},
Description: pulumi.Any(migrationDescription),
DisplayName: pulumi.Any(migrationDisplayName),
ExcludeObjects: databasemigration.MigrationExcludeObjectArray{
&databasemigration.MigrationExcludeObjectArgs{
Object: pulumi.Any(migrationExcludeObjectsObject),
IsOmitExcludedTableFromReplication: pulumi.Any(migrationExcludeObjectsIsOmitExcludedTableFromReplication),
Owner: pulumi.Any(migrationExcludeObjectsOwner),
Schema: pulumi.Any(migrationExcludeObjectsSchema),
Type: pulumi.Any(migrationExcludeObjectsType),
},
},
FreeformTags: pulumi.Any(migrationFreeformTags),
GgsDetails: &databasemigration.MigrationGgsDetailsArgs{
AcceptableLag: pulumi.Any(migrationGgsDetailsAcceptableLag),
Extract: &databasemigration.MigrationGgsDetailsExtractArgs{
LongTransDuration: pulumi.Any(migrationGgsDetailsExtractLongTransDuration),
PerformanceProfile: pulumi.Any(migrationGgsDetailsExtractPerformanceProfile),
},
Replicat: &databasemigration.MigrationGgsDetailsReplicatArgs{
PerformanceProfile: pulumi.Any(migrationGgsDetailsReplicatPerformanceProfile),
},
},
HubDetails: &databasemigration.MigrationHubDetailsArgs{
KeyId: pulumi.Any(testKey.Id),
RestAdminCredentials: &databasemigration.MigrationHubDetailsRestAdminCredentialsArgs{
Password: pulumi.Any(migrationHubDetailsRestAdminCredentialsPassword),
Username: pulumi.Any(migrationHubDetailsRestAdminCredentialsUsername),
},
Url: pulumi.Any(migrationHubDetailsUrl),
VaultId: pulumi.Any(testVault.Id),
AcceptableLag: pulumi.Any(migrationHubDetailsAcceptableLag),
ComputeId: pulumi.Any(testCompute.Id),
Extract: &databasemigration.MigrationHubDetailsExtractArgs{
LongTransDuration: pulumi.Any(migrationHubDetailsExtractLongTransDuration),
PerformanceProfile: pulumi.Any(migrationHubDetailsExtractPerformanceProfile),
},
Replicat: &databasemigration.MigrationHubDetailsReplicatArgs{
PerformanceProfile: pulumi.Any(migrationHubDetailsReplicatPerformanceProfile),
},
},
IncludeObjects: databasemigration.MigrationIncludeObjectArray{
&databasemigration.MigrationIncludeObjectArgs{
Object: pulumi.Any(migrationIncludeObjectsObject),
IsOmitExcludedTableFromReplication: pulumi.Any(migrationIncludeObjectsIsOmitExcludedTableFromReplication),
Owner: pulumi.Any(migrationIncludeObjectsOwner),
Schema: pulumi.Any(migrationIncludeObjectsSchema),
Type: pulumi.Any(migrationIncludeObjectsType),
},
},
InitialLoadSettings: &databasemigration.MigrationInitialLoadSettingsArgs{
JobMode: pulumi.Any(migrationInitialLoadSettingsJobMode),
Compatibilities: pulumi.Any(migrationInitialLoadSettingsCompatibility),
DataPumpParameters: &databasemigration.MigrationInitialLoadSettingsDataPumpParametersArgs{
Estimate: pulumi.Any(migrationInitialLoadSettingsDataPumpParametersEstimate),
ExcludeParameters: pulumi.Any(migrationInitialLoadSettingsDataPumpParametersExcludeParameters),
ExportParallelismDegree: pulumi.Any(migrationInitialLoadSettingsDataPumpParametersExportParallelismDegree),
ImportParallelismDegree: pulumi.Any(migrationInitialLoadSettingsDataPumpParametersImportParallelismDegree),
IsCluster: pulumi.Any(migrationInitialLoadSettingsDataPumpParametersIsCluster),
TableExistsAction: pulumi.Any(migrationInitialLoadSettingsDataPumpParametersTableExistsAction),
},
ExportDirectoryObject: &databasemigration.MigrationInitialLoadSettingsExportDirectoryObjectArgs{
Name: pulumi.Any(migrationInitialLoadSettingsExportDirectoryObjectName),
Path: pulumi.Any(migrationInitialLoadSettingsExportDirectoryObjectPath),
},
HandleGrantErrors: pulumi.Any(migrationInitialLoadSettingsHandleGrantErrors),
ImportDirectoryObject: &databasemigration.MigrationInitialLoadSettingsImportDirectoryObjectArgs{
Name: pulumi.Any(migrationInitialLoadSettingsImportDirectoryObjectName),
Path: pulumi.Any(migrationInitialLoadSettingsImportDirectoryObjectPath),
},
IsConsistent: pulumi.Any(migrationInitialLoadSettingsIsConsistent),
IsIgnoreExistingObjects: pulumi.Any(migrationInitialLoadSettingsIsIgnoreExistingObjects),
IsTzUtc: pulumi.Any(migrationInitialLoadSettingsIsTzUtc),
MetadataRemaps: databasemigration.MigrationInitialLoadSettingsMetadataRemapArray{
&databasemigration.MigrationInitialLoadSettingsMetadataRemapArgs{
NewValue: pulumi.Any(migrationInitialLoadSettingsMetadataRemapsNewValue),
OldValue: pulumi.Any(migrationInitialLoadSettingsMetadataRemapsOldValue),
Type: pulumi.Any(migrationInitialLoadSettingsMetadataRemapsType),
},
},
PrimaryKeyCompatibility: pulumi.Any(migrationInitialLoadSettingsPrimaryKeyCompatibility),
TablespaceDetails: &databasemigration.MigrationInitialLoadSettingsTablespaceDetailsArgs{
TargetType: pulumi.Any(migrationInitialLoadSettingsTablespaceDetailsTargetType),
BlockSizeInKbs: pulumi.Any(migrationInitialLoadSettingsTablespaceDetailsBlockSizeInKbs),
ExtendSizeInMbs: pulumi.Any(migrationInitialLoadSettingsTablespaceDetailsExtendSizeInMbs),
IsAutoCreate: pulumi.Any(migrationInitialLoadSettingsTablespaceDetailsIsAutoCreate),
IsBigFile: pulumi.Any(migrationInitialLoadSettingsTablespaceDetailsIsBigFile),
RemapTarget: pulumi.Any(migrationInitialLoadSettingsTablespaceDetailsRemapTarget),
},
},
SourceContainerDatabaseConnectionId: pulumi.Any(testConnection.Id),
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() =>
{
var testMigration = new Oci.DatabaseMigration.Migration("test_migration", new()
{
CompartmentId = compartmentId,
DatabaseCombination = migrationDatabaseCombination,
SourceDatabaseConnectionId = testConnection.Id,
TargetDatabaseConnectionId = testConnection.Id,
Type = migrationType,
AdvancedParameters = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationAdvancedParameterArgs
{
DataType = migrationAdvancedParametersDataType,
Name = migrationAdvancedParametersName,
Value = migrationAdvancedParametersValue,
},
},
AdvisorSettings = new Oci.DatabaseMigration.Inputs.MigrationAdvisorSettingsArgs
{
IsIgnoreErrors = migrationAdvisorSettingsIsIgnoreErrors,
IsSkipAdvisor = migrationAdvisorSettingsIsSkipAdvisor,
},
BulkIncludeExcludeData = migrationBulkIncludeExcludeData,
DataTransferMediumDetails = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsArgs
{
Type = migrationDataTransferMediumDetailsType,
AccessKeyId = testKey.Id,
Name = migrationDataTransferMediumDetailsName,
ObjectStorageBucket = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsObjectStorageBucketArgs
{
Bucket = migrationDataTransferMediumDetailsObjectStorageBucketBucket,
Namespace = migrationDataTransferMediumDetailsObjectStorageBucketNamespace,
},
Region = migrationDataTransferMediumDetailsRegion,
SecretAccessKey = migrationDataTransferMediumDetailsSecretAccessKey,
SharedStorageMountTargetId = testMountTarget.Id,
Source = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsSourceArgs
{
Kind = migrationDataTransferMediumDetailsSourceKind,
OciHome = migrationDataTransferMediumDetailsSourceOciHome,
WalletLocation = migrationDataTransferMediumDetailsSourceWalletLocation,
},
Target = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsTargetArgs
{
Kind = migrationDataTransferMediumDetailsTargetKind,
OciHome = migrationDataTransferMediumDetailsTargetOciHome,
WalletLocation = migrationDataTransferMediumDetailsTargetWalletLocation,
},
},
DefinedTags =
{
{ "foo-namespace.bar-key", "value" },
},
Description = migrationDescription,
DisplayName = migrationDisplayName,
ExcludeObjects = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationExcludeObjectArgs
{
Object = migrationExcludeObjectsObject,
IsOmitExcludedTableFromReplication = migrationExcludeObjectsIsOmitExcludedTableFromReplication,
Owner = migrationExcludeObjectsOwner,
Schema = migrationExcludeObjectsSchema,
Type = migrationExcludeObjectsType,
},
},
FreeformTags = migrationFreeformTags,
GgsDetails = new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsArgs
{
AcceptableLag = migrationGgsDetailsAcceptableLag,
Extract = new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsExtractArgs
{
LongTransDuration = migrationGgsDetailsExtractLongTransDuration,
PerformanceProfile = migrationGgsDetailsExtractPerformanceProfile,
},
Replicat = new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsReplicatArgs
{
PerformanceProfile = migrationGgsDetailsReplicatPerformanceProfile,
},
},
HubDetails = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsArgs
{
KeyId = testKey.Id,
RestAdminCredentials = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsRestAdminCredentialsArgs
{
Password = migrationHubDetailsRestAdminCredentialsPassword,
Username = migrationHubDetailsRestAdminCredentialsUsername,
},
Url = migrationHubDetailsUrl,
VaultId = testVault.Id,
AcceptableLag = migrationHubDetailsAcceptableLag,
ComputeId = testCompute.Id,
Extract = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsExtractArgs
{
LongTransDuration = migrationHubDetailsExtractLongTransDuration,
PerformanceProfile = migrationHubDetailsExtractPerformanceProfile,
},
Replicat = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsReplicatArgs
{
PerformanceProfile = migrationHubDetailsReplicatPerformanceProfile,
},
},
IncludeObjects = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationIncludeObjectArgs
{
Object = migrationIncludeObjectsObject,
IsOmitExcludedTableFromReplication = migrationIncludeObjectsIsOmitExcludedTableFromReplication,
Owner = migrationIncludeObjectsOwner,
Schema = migrationIncludeObjectsSchema,
Type = migrationIncludeObjectsType,
},
},
InitialLoadSettings = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsArgs
{
JobMode = migrationInitialLoadSettingsJobMode,
Compatibilities = migrationInitialLoadSettingsCompatibility,
DataPumpParameters = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsDataPumpParametersArgs
{
Estimate = migrationInitialLoadSettingsDataPumpParametersEstimate,
ExcludeParameters = migrationInitialLoadSettingsDataPumpParametersExcludeParameters,
ExportParallelismDegree = migrationInitialLoadSettingsDataPumpParametersExportParallelismDegree,
ImportParallelismDegree = migrationInitialLoadSettingsDataPumpParametersImportParallelismDegree,
IsCluster = migrationInitialLoadSettingsDataPumpParametersIsCluster,
TableExistsAction = migrationInitialLoadSettingsDataPumpParametersTableExistsAction,
},
ExportDirectoryObject = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsExportDirectoryObjectArgs
{
Name = migrationInitialLoadSettingsExportDirectoryObjectName,
Path = migrationInitialLoadSettingsExportDirectoryObjectPath,
},
HandleGrantErrors = migrationInitialLoadSettingsHandleGrantErrors,
ImportDirectoryObject = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsImportDirectoryObjectArgs
{
Name = migrationInitialLoadSettingsImportDirectoryObjectName,
Path = migrationInitialLoadSettingsImportDirectoryObjectPath,
},
IsConsistent = migrationInitialLoadSettingsIsConsistent,
IsIgnoreExistingObjects = migrationInitialLoadSettingsIsIgnoreExistingObjects,
IsTzUtc = migrationInitialLoadSettingsIsTzUtc,
MetadataRemaps = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsMetadataRemapArgs
{
NewValue = migrationInitialLoadSettingsMetadataRemapsNewValue,
OldValue = migrationInitialLoadSettingsMetadataRemapsOldValue,
Type = migrationInitialLoadSettingsMetadataRemapsType,
},
},
PrimaryKeyCompatibility = migrationInitialLoadSettingsPrimaryKeyCompatibility,
TablespaceDetails = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsTablespaceDetailsArgs
{
TargetType = migrationInitialLoadSettingsTablespaceDetailsTargetType,
BlockSizeInKbs = migrationInitialLoadSettingsTablespaceDetailsBlockSizeInKbs,
ExtendSizeInMbs = migrationInitialLoadSettingsTablespaceDetailsExtendSizeInMbs,
IsAutoCreate = migrationInitialLoadSettingsTablespaceDetailsIsAutoCreate,
IsBigFile = migrationInitialLoadSettingsTablespaceDetailsIsBigFile,
RemapTarget = migrationInitialLoadSettingsTablespaceDetailsRemapTarget,
},
},
SourceContainerDatabaseConnectionId = testConnection.Id,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseMigration.Migration;
import com.pulumi.oci.DatabaseMigration.MigrationArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationAdvancedParameterArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationAdvisorSettingsArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationDataTransferMediumDetailsArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationDataTransferMediumDetailsObjectStorageBucketArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationDataTransferMediumDetailsSourceArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationDataTransferMediumDetailsTargetArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationExcludeObjectArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationGgsDetailsArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationGgsDetailsExtractArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationGgsDetailsReplicatArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationHubDetailsArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationHubDetailsRestAdminCredentialsArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationHubDetailsExtractArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationHubDetailsReplicatArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationIncludeObjectArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationInitialLoadSettingsArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationInitialLoadSettingsDataPumpParametersArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationInitialLoadSettingsExportDirectoryObjectArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationInitialLoadSettingsImportDirectoryObjectArgs;
import com.pulumi.oci.DatabaseMigration.inputs.MigrationInitialLoadSettingsTablespaceDetailsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var testMigration = new Migration("testMigration", MigrationArgs.builder()
.compartmentId(compartmentId)
.databaseCombination(migrationDatabaseCombination)
.sourceDatabaseConnectionId(testConnection.id())
.targetDatabaseConnectionId(testConnection.id())
.type(migrationType)
.advancedParameters(MigrationAdvancedParameterArgs.builder()
.dataType(migrationAdvancedParametersDataType)
.name(migrationAdvancedParametersName)
.value(migrationAdvancedParametersValue)
.build())
.advisorSettings(MigrationAdvisorSettingsArgs.builder()
.isIgnoreErrors(migrationAdvisorSettingsIsIgnoreErrors)
.isSkipAdvisor(migrationAdvisorSettingsIsSkipAdvisor)
.build())
.bulkIncludeExcludeData(migrationBulkIncludeExcludeData)
.dataTransferMediumDetails(MigrationDataTransferMediumDetailsArgs.builder()
.type(migrationDataTransferMediumDetailsType)
.accessKeyId(testKey.id())
.name(migrationDataTransferMediumDetailsName)
.objectStorageBucket(MigrationDataTransferMediumDetailsObjectStorageBucketArgs.builder()
.bucket(migrationDataTransferMediumDetailsObjectStorageBucketBucket)
.namespace(migrationDataTransferMediumDetailsObjectStorageBucketNamespace)
.build())
.region(migrationDataTransferMediumDetailsRegion)
.secretAccessKey(migrationDataTransferMediumDetailsSecretAccessKey)
.sharedStorageMountTargetId(testMountTarget.id())
.source(MigrationDataTransferMediumDetailsSourceArgs.builder()
.kind(migrationDataTransferMediumDetailsSourceKind)
.ociHome(migrationDataTransferMediumDetailsSourceOciHome)
.walletLocation(migrationDataTransferMediumDetailsSourceWalletLocation)
.build())
.target(MigrationDataTransferMediumDetailsTargetArgs.builder()
.kind(migrationDataTransferMediumDetailsTargetKind)
.ociHome(migrationDataTransferMediumDetailsTargetOciHome)
.walletLocation(migrationDataTransferMediumDetailsTargetWalletLocation)
.build())
.build())
.definedTags(Map.of("foo-namespace.bar-key", "value"))
.description(migrationDescription)
.displayName(migrationDisplayName)
.excludeObjects(MigrationExcludeObjectArgs.builder()
.object(migrationExcludeObjectsObject)
.isOmitExcludedTableFromReplication(migrationExcludeObjectsIsOmitExcludedTableFromReplication)
.owner(migrationExcludeObjectsOwner)
.schema(migrationExcludeObjectsSchema)
.type(migrationExcludeObjectsType)
.build())
.freeformTags(migrationFreeformTags)
.ggsDetails(MigrationGgsDetailsArgs.builder()
.acceptableLag(migrationGgsDetailsAcceptableLag)
.extract(MigrationGgsDetailsExtractArgs.builder()
.longTransDuration(migrationGgsDetailsExtractLongTransDuration)
.performanceProfile(migrationGgsDetailsExtractPerformanceProfile)
.build())
.replicat(MigrationGgsDetailsReplicatArgs.builder()
.performanceProfile(migrationGgsDetailsReplicatPerformanceProfile)
.build())
.build())
.hubDetails(MigrationHubDetailsArgs.builder()
.keyId(testKey.id())
.restAdminCredentials(MigrationHubDetailsRestAdminCredentialsArgs.builder()
.password(migrationHubDetailsRestAdminCredentialsPassword)
.username(migrationHubDetailsRestAdminCredentialsUsername)
.build())
.url(migrationHubDetailsUrl)
.vaultId(testVault.id())
.acceptableLag(migrationHubDetailsAcceptableLag)
.computeId(testCompute.id())
.extract(MigrationHubDetailsExtractArgs.builder()
.longTransDuration(migrationHubDetailsExtractLongTransDuration)
.performanceProfile(migrationHubDetailsExtractPerformanceProfile)
.build())
.replicat(MigrationHubDetailsReplicatArgs.builder()
.performanceProfile(migrationHubDetailsReplicatPerformanceProfile)
.build())
.build())
.includeObjects(MigrationIncludeObjectArgs.builder()
.object(migrationIncludeObjectsObject)
.isOmitExcludedTableFromReplication(migrationIncludeObjectsIsOmitExcludedTableFromReplication)
.owner(migrationIncludeObjectsOwner)
.schema(migrationIncludeObjectsSchema)
.type(migrationIncludeObjectsType)
.build())
.initialLoadSettings(MigrationInitialLoadSettingsArgs.builder()
.jobMode(migrationInitialLoadSettingsJobMode)
.compatibilities(migrationInitialLoadSettingsCompatibility)
.dataPumpParameters(MigrationInitialLoadSettingsDataPumpParametersArgs.builder()
.estimate(migrationInitialLoadSettingsDataPumpParametersEstimate)
.excludeParameters(migrationInitialLoadSettingsDataPumpParametersExcludeParameters)
.exportParallelismDegree(migrationInitialLoadSettingsDataPumpParametersExportParallelismDegree)
.importParallelismDegree(migrationInitialLoadSettingsDataPumpParametersImportParallelismDegree)
.isCluster(migrationInitialLoadSettingsDataPumpParametersIsCluster)
.tableExistsAction(migrationInitialLoadSettingsDataPumpParametersTableExistsAction)
.build())
.exportDirectoryObject(MigrationInitialLoadSettingsExportDirectoryObjectArgs.builder()
.name(migrationInitialLoadSettingsExportDirectoryObjectName)
.path(migrationInitialLoadSettingsExportDirectoryObjectPath)
.build())
.handleGrantErrors(migrationInitialLoadSettingsHandleGrantErrors)
.importDirectoryObject(MigrationInitialLoadSettingsImportDirectoryObjectArgs.builder()
.name(migrationInitialLoadSettingsImportDirectoryObjectName)
.path(migrationInitialLoadSettingsImportDirectoryObjectPath)
.build())
.isConsistent(migrationInitialLoadSettingsIsConsistent)
.isIgnoreExistingObjects(migrationInitialLoadSettingsIsIgnoreExistingObjects)
.isTzUtc(migrationInitialLoadSettingsIsTzUtc)
.metadataRemaps(MigrationInitialLoadSettingsMetadataRemapArgs.builder()
.newValue(migrationInitialLoadSettingsMetadataRemapsNewValue)
.oldValue(migrationInitialLoadSettingsMetadataRemapsOldValue)
.type(migrationInitialLoadSettingsMetadataRemapsType)
.build())
.primaryKeyCompatibility(migrationInitialLoadSettingsPrimaryKeyCompatibility)
.tablespaceDetails(MigrationInitialLoadSettingsTablespaceDetailsArgs.builder()
.targetType(migrationInitialLoadSettingsTablespaceDetailsTargetType)
.blockSizeInKbs(migrationInitialLoadSettingsTablespaceDetailsBlockSizeInKbs)
.extendSizeInMbs(migrationInitialLoadSettingsTablespaceDetailsExtendSizeInMbs)
.isAutoCreate(migrationInitialLoadSettingsTablespaceDetailsIsAutoCreate)
.isBigFile(migrationInitialLoadSettingsTablespaceDetailsIsBigFile)
.remapTarget(migrationInitialLoadSettingsTablespaceDetailsRemapTarget)
.build())
.build())
.sourceContainerDatabaseConnectionId(testConnection.id())
.build());
}
}
resources:
testMigration:
type: oci:DatabaseMigration:Migration
name: test_migration
properties:
compartmentId: ${compartmentId}
databaseCombination: ${migrationDatabaseCombination}
sourceDatabaseConnectionId: ${testConnection.id}
targetDatabaseConnectionId: ${testConnection.id}
type: ${migrationType}
advancedParameters:
- dataType: ${migrationAdvancedParametersDataType}
name: ${migrationAdvancedParametersName}
value: ${migrationAdvancedParametersValue}
advisorSettings:
isIgnoreErrors: ${migrationAdvisorSettingsIsIgnoreErrors}
isSkipAdvisor: ${migrationAdvisorSettingsIsSkipAdvisor}
bulkIncludeExcludeData: ${migrationBulkIncludeExcludeData}
dataTransferMediumDetails:
type: ${migrationDataTransferMediumDetailsType}
accessKeyId: ${testKey.id}
name: ${migrationDataTransferMediumDetailsName}
objectStorageBucket:
bucket: ${migrationDataTransferMediumDetailsObjectStorageBucketBucket}
namespace: ${migrationDataTransferMediumDetailsObjectStorageBucketNamespace}
region: ${migrationDataTransferMediumDetailsRegion}
secretAccessKey: ${migrationDataTransferMediumDetailsSecretAccessKey}
sharedStorageMountTargetId: ${testMountTarget.id}
source:
kind: ${migrationDataTransferMediumDetailsSourceKind}
ociHome: ${migrationDataTransferMediumDetailsSourceOciHome}
walletLocation: ${migrationDataTransferMediumDetailsSourceWalletLocation}
target:
kind: ${migrationDataTransferMediumDetailsTargetKind}
ociHome: ${migrationDataTransferMediumDetailsTargetOciHome}
walletLocation: ${migrationDataTransferMediumDetailsTargetWalletLocation}
definedTags:
foo-namespace.bar-key: value
description: ${migrationDescription}
displayName: ${migrationDisplayName}
excludeObjects:
- object: ${migrationExcludeObjectsObject}
isOmitExcludedTableFromReplication: ${migrationExcludeObjectsIsOmitExcludedTableFromReplication}
owner: ${migrationExcludeObjectsOwner}
schema: ${migrationExcludeObjectsSchema}
type: ${migrationExcludeObjectsType}
freeformTags: ${migrationFreeformTags}
ggsDetails:
acceptableLag: ${migrationGgsDetailsAcceptableLag}
extract:
longTransDuration: ${migrationGgsDetailsExtractLongTransDuration}
performanceProfile: ${migrationGgsDetailsExtractPerformanceProfile}
replicat:
performanceProfile: ${migrationGgsDetailsReplicatPerformanceProfile}
hubDetails:
keyId: ${testKey.id}
restAdminCredentials:
password: ${migrationHubDetailsRestAdminCredentialsPassword}
username: ${migrationHubDetailsRestAdminCredentialsUsername}
url: ${migrationHubDetailsUrl}
vaultId: ${testVault.id}
acceptableLag: ${migrationHubDetailsAcceptableLag}
computeId: ${testCompute.id}
extract:
longTransDuration: ${migrationHubDetailsExtractLongTransDuration}
performanceProfile: ${migrationHubDetailsExtractPerformanceProfile}
replicat:
performanceProfile: ${migrationHubDetailsReplicatPerformanceProfile}
includeObjects:
- object: ${migrationIncludeObjectsObject}
isOmitExcludedTableFromReplication: ${migrationIncludeObjectsIsOmitExcludedTableFromReplication}
owner: ${migrationIncludeObjectsOwner}
schema: ${migrationIncludeObjectsSchema}
type: ${migrationIncludeObjectsType}
initialLoadSettings:
jobMode: ${migrationInitialLoadSettingsJobMode}
compatibilities: ${migrationInitialLoadSettingsCompatibility}
dataPumpParameters:
estimate: ${migrationInitialLoadSettingsDataPumpParametersEstimate}
excludeParameters: ${migrationInitialLoadSettingsDataPumpParametersExcludeParameters}
exportParallelismDegree: ${migrationInitialLoadSettingsDataPumpParametersExportParallelismDegree}
importParallelismDegree: ${migrationInitialLoadSettingsDataPumpParametersImportParallelismDegree}
isCluster: ${migrationInitialLoadSettingsDataPumpParametersIsCluster}
tableExistsAction: ${migrationInitialLoadSettingsDataPumpParametersTableExistsAction}
exportDirectoryObject:
name: ${migrationInitialLoadSettingsExportDirectoryObjectName}
path: ${migrationInitialLoadSettingsExportDirectoryObjectPath}
handleGrantErrors: ${migrationInitialLoadSettingsHandleGrantErrors}
importDirectoryObject:
name: ${migrationInitialLoadSettingsImportDirectoryObjectName}
path: ${migrationInitialLoadSettingsImportDirectoryObjectPath}
isConsistent: ${migrationInitialLoadSettingsIsConsistent}
isIgnoreExistingObjects: ${migrationInitialLoadSettingsIsIgnoreExistingObjects}
isTzUtc: ${migrationInitialLoadSettingsIsTzUtc}
metadataRemaps:
- newValue: ${migrationInitialLoadSettingsMetadataRemapsNewValue}
oldValue: ${migrationInitialLoadSettingsMetadataRemapsOldValue}
type: ${migrationInitialLoadSettingsMetadataRemapsType}
primaryKeyCompatibility: ${migrationInitialLoadSettingsPrimaryKeyCompatibility}
tablespaceDetails:
targetType: ${migrationInitialLoadSettingsTablespaceDetailsTargetType}
blockSizeInKbs: ${migrationInitialLoadSettingsTablespaceDetailsBlockSizeInKbs}
extendSizeInMbs: ${migrationInitialLoadSettingsTablespaceDetailsExtendSizeInMbs}
isAutoCreate: ${migrationInitialLoadSettingsTablespaceDetailsIsAutoCreate}
isBigFile: ${migrationInitialLoadSettingsTablespaceDetailsIsBigFile}
remapTarget: ${migrationInitialLoadSettingsTablespaceDetailsRemapTarget}
sourceContainerDatabaseConnectionId: ${testConnection.id}
Create Migration Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new Migration(name: string, args: MigrationArgs, opts?: CustomResourceOptions);@overload
def Migration(resource_name: str,
args: MigrationArgs,
opts: Optional[ResourceOptions] = None)
@overload
def Migration(resource_name: str,
opts: Optional[ResourceOptions] = None,
database_combination: Optional[str] = None,
type: Optional[str] = None,
target_database_connection_id: Optional[str] = None,
compartment_id: Optional[str] = None,
source_database_connection_id: Optional[str] = None,
display_name: Optional[str] = None,
hub_details: Optional[_databasemigration.MigrationHubDetailsArgs] = None,
description: Optional[str] = None,
advanced_parameters: Optional[Sequence[_databasemigration.MigrationAdvancedParameterArgs]] = None,
exclude_objects: Optional[Sequence[_databasemigration.MigrationExcludeObjectArgs]] = None,
freeform_tags: Optional[Mapping[str, str]] = None,
ggs_details: Optional[_databasemigration.MigrationGgsDetailsArgs] = None,
defined_tags: Optional[Mapping[str, str]] = None,
include_objects: Optional[Sequence[_databasemigration.MigrationIncludeObjectArgs]] = None,
initial_load_settings: Optional[_databasemigration.MigrationInitialLoadSettingsArgs] = None,
source_container_database_connection_id: Optional[str] = None,
data_transfer_medium_details: Optional[_databasemigration.MigrationDataTransferMediumDetailsArgs] = None,
bulk_include_exclude_data: Optional[str] = None,
advisor_settings: Optional[_databasemigration.MigrationAdvisorSettingsArgs] = None)func NewMigration(ctx *Context, name string, args MigrationArgs, opts ...ResourceOption) (*Migration, error)public Migration(string name, MigrationArgs args, CustomResourceOptions? opts = null)
public Migration(String name, MigrationArgs args)
public Migration(String name, MigrationArgs args, CustomResourceOptions options)
type: oci:DatabaseMigration:Migration
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args MigrationArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args MigrationArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args MigrationArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MigrationArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MigrationArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var ociMigrationResource = new Oci.DatabaseMigration.Migration("ociMigrationResource", new()
{
DatabaseCombination = "string",
Type = "string",
TargetDatabaseConnectionId = "string",
CompartmentId = "string",
SourceDatabaseConnectionId = "string",
DisplayName = "string",
HubDetails = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsArgs
{
KeyId = "string",
RestAdminCredentials = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsRestAdminCredentialsArgs
{
Password = "string",
Username = "string",
},
Url = "string",
VaultId = "string",
AcceptableLag = 0,
ComputeId = "string",
Extract = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsExtractArgs
{
LongTransDuration = 0,
PerformanceProfile = "string",
},
Replicat = new Oci.DatabaseMigration.Inputs.MigrationHubDetailsReplicatArgs
{
PerformanceProfile = "string",
},
},
Description = "string",
AdvancedParameters = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationAdvancedParameterArgs
{
DataType = "string",
Name = "string",
Value = "string",
},
},
ExcludeObjects = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationExcludeObjectArgs
{
Object = "string",
IsOmitExcludedTableFromReplication = false,
Owner = "string",
Schema = "string",
Type = "string",
},
},
FreeformTags =
{
{ "string", "string" },
},
GgsDetails = new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsArgs
{
AcceptableLag = 0,
Extract = new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsExtractArgs
{
LongTransDuration = 0,
PerformanceProfile = "string",
},
GgsDeployments = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsGgsDeploymentArgs
{
DeploymentId = "string",
GgsAdminCredentialsSecretId = "string",
},
},
Replicat = new Oci.DatabaseMigration.Inputs.MigrationGgsDetailsReplicatArgs
{
PerformanceProfile = "string",
},
},
DefinedTags =
{
{ "string", "string" },
},
IncludeObjects = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationIncludeObjectArgs
{
Object = "string",
IsOmitExcludedTableFromReplication = false,
Owner = "string",
Schema = "string",
Type = "string",
},
},
InitialLoadSettings = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsArgs
{
JobMode = "string",
Compatibilities = new[]
{
"string",
},
DataPumpParameters = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsDataPumpParametersArgs
{
Estimate = "string",
ExcludeParameters = new[]
{
"string",
},
ExportParallelismDegree = 0,
ImportParallelismDegree = 0,
IsCluster = false,
TableExistsAction = "string",
},
ExportDirectoryObject = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsExportDirectoryObjectArgs
{
Name = "string",
Path = "string",
},
HandleGrantErrors = "string",
ImportDirectoryObject = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsImportDirectoryObjectArgs
{
Name = "string",
Path = "string",
},
IsConsistent = false,
IsIgnoreExistingObjects = false,
IsTzUtc = false,
MetadataRemaps = new[]
{
new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsMetadataRemapArgs
{
NewValue = "string",
OldValue = "string",
Type = "string",
},
},
PrimaryKeyCompatibility = "string",
TablespaceDetails = new Oci.DatabaseMigration.Inputs.MigrationInitialLoadSettingsTablespaceDetailsArgs
{
TargetType = "string",
BlockSizeInKbs = "string",
ExtendSizeInMbs = 0,
IsAutoCreate = false,
IsBigFile = false,
RemapTarget = "string",
},
},
SourceContainerDatabaseConnectionId = "string",
DataTransferMediumDetails = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsArgs
{
Type = "string",
AccessKeyId = "string",
Name = "string",
ObjectStorageBucket = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsObjectStorageBucketArgs
{
Bucket = "string",
Namespace = "string",
},
Region = "string",
SecretAccessKey = "string",
SharedStorageMountTargetId = "string",
Source = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsSourceArgs
{
Kind = "string",
OciHome = "string",
WalletLocation = "string",
},
Target = new Oci.DatabaseMigration.Inputs.MigrationDataTransferMediumDetailsTargetArgs
{
Kind = "string",
OciHome = "string",
WalletLocation = "string",
},
},
BulkIncludeExcludeData = "string",
AdvisorSettings = new Oci.DatabaseMigration.Inputs.MigrationAdvisorSettingsArgs
{
IsIgnoreErrors = false,
IsSkipAdvisor = false,
},
});
example, err := DatabaseMigration.NewMigration(ctx, "ociMigrationResource", &DatabaseMigration.MigrationArgs{
DatabaseCombination: pulumi.String("string"),
Type: pulumi.String("string"),
TargetDatabaseConnectionId: pulumi.String("string"),
CompartmentId: pulumi.String("string"),
SourceDatabaseConnectionId: pulumi.String("string"),
DisplayName: pulumi.String("string"),
HubDetails: &databasemigration.MigrationHubDetailsArgs{
KeyId: pulumi.String("string"),
RestAdminCredentials: &databasemigration.MigrationHubDetailsRestAdminCredentialsArgs{
Password: pulumi.String("string"),
Username: pulumi.String("string"),
},
Url: pulumi.String("string"),
VaultId: pulumi.String("string"),
AcceptableLag: pulumi.Int(0),
ComputeId: pulumi.String("string"),
Extract: &databasemigration.MigrationHubDetailsExtractArgs{
LongTransDuration: pulumi.Int(0),
PerformanceProfile: pulumi.String("string"),
},
Replicat: &databasemigration.MigrationHubDetailsReplicatArgs{
PerformanceProfile: pulumi.String("string"),
},
},
Description: pulumi.String("string"),
AdvancedParameters: databasemigration.MigrationAdvancedParameterArray{
&databasemigration.MigrationAdvancedParameterArgs{
DataType: pulumi.String("string"),
Name: pulumi.String("string"),
Value: pulumi.String("string"),
},
},
ExcludeObjects: databasemigration.MigrationExcludeObjectArray{
&databasemigration.MigrationExcludeObjectArgs{
Object: pulumi.String("string"),
IsOmitExcludedTableFromReplication: pulumi.Bool(false),
Owner: pulumi.String("string"),
Schema: pulumi.String("string"),
Type: pulumi.String("string"),
},
},
FreeformTags: pulumi.StringMap{
"string": pulumi.String("string"),
},
GgsDetails: &databasemigration.MigrationGgsDetailsArgs{
AcceptableLag: pulumi.Int(0),
Extract: &databasemigration.MigrationGgsDetailsExtractArgs{
LongTransDuration: pulumi.Int(0),
PerformanceProfile: pulumi.String("string"),
},
GgsDeployments: databasemigration.MigrationGgsDetailsGgsDeploymentArray{
&databasemigration.MigrationGgsDetailsGgsDeploymentArgs{
DeploymentId: pulumi.String("string"),
GgsAdminCredentialsSecretId: pulumi.String("string"),
},
},
Replicat: &databasemigration.MigrationGgsDetailsReplicatArgs{
PerformanceProfile: pulumi.String("string"),
},
},
DefinedTags: pulumi.StringMap{
"string": pulumi.String("string"),
},
IncludeObjects: databasemigration.MigrationIncludeObjectArray{
&databasemigration.MigrationIncludeObjectArgs{
Object: pulumi.String("string"),
IsOmitExcludedTableFromReplication: pulumi.Bool(false),
Owner: pulumi.String("string"),
Schema: pulumi.String("string"),
Type: pulumi.String("string"),
},
},
InitialLoadSettings: &databasemigration.MigrationInitialLoadSettingsArgs{
JobMode: pulumi.String("string"),
Compatibilities: pulumi.StringArray{
pulumi.String("string"),
},
DataPumpParameters: &databasemigration.MigrationInitialLoadSettingsDataPumpParametersArgs{
Estimate: pulumi.String("string"),
ExcludeParameters: pulumi.StringArray{
pulumi.String("string"),
},
ExportParallelismDegree: pulumi.Int(0),
ImportParallelismDegree: pulumi.Int(0),
IsCluster: pulumi.Bool(false),
TableExistsAction: pulumi.String("string"),
},
ExportDirectoryObject: &databasemigration.MigrationInitialLoadSettingsExportDirectoryObjectArgs{
Name: pulumi.String("string"),
Path: pulumi.String("string"),
},
HandleGrantErrors: pulumi.String("string"),
ImportDirectoryObject: &databasemigration.MigrationInitialLoadSettingsImportDirectoryObjectArgs{
Name: pulumi.String("string"),
Path: pulumi.String("string"),
},
IsConsistent: pulumi.Bool(false),
IsIgnoreExistingObjects: pulumi.Bool(false),
IsTzUtc: pulumi.Bool(false),
MetadataRemaps: databasemigration.MigrationInitialLoadSettingsMetadataRemapArray{
&databasemigration.MigrationInitialLoadSettingsMetadataRemapArgs{
NewValue: pulumi.String("string"),
OldValue: pulumi.String("string"),
Type: pulumi.String("string"),
},
},
PrimaryKeyCompatibility: pulumi.String("string"),
TablespaceDetails: &databasemigration.MigrationInitialLoadSettingsTablespaceDetailsArgs{
TargetType: pulumi.String("string"),
BlockSizeInKbs: pulumi.String("string"),
ExtendSizeInMbs: pulumi.Int(0),
IsAutoCreate: pulumi.Bool(false),
IsBigFile: pulumi.Bool(false),
RemapTarget: pulumi.String("string"),
},
},
SourceContainerDatabaseConnectionId: pulumi.String("string"),
DataTransferMediumDetails: &databasemigration.MigrationDataTransferMediumDetailsArgs{
Type: pulumi.String("string"),
AccessKeyId: pulumi.String("string"),
Name: pulumi.String("string"),
ObjectStorageBucket: &databasemigration.MigrationDataTransferMediumDetailsObjectStorageBucketArgs{
Bucket: pulumi.String("string"),
Namespace: pulumi.String("string"),
},
Region: pulumi.String("string"),
SecretAccessKey: pulumi.String("string"),
SharedStorageMountTargetId: pulumi.String("string"),
Source: &databasemigration.MigrationDataTransferMediumDetailsSourceArgs{
Kind: pulumi.String("string"),
OciHome: pulumi.String("string"),
WalletLocation: pulumi.String("string"),
},
Target: &databasemigration.MigrationDataTransferMediumDetailsTargetArgs{
Kind: pulumi.String("string"),
OciHome: pulumi.String("string"),
WalletLocation: pulumi.String("string"),
},
},
BulkIncludeExcludeData: pulumi.String("string"),
AdvisorSettings: &databasemigration.MigrationAdvisorSettingsArgs{
IsIgnoreErrors: pulumi.Bool(false),
IsSkipAdvisor: pulumi.Bool(false),
},
})
var ociMigrationResource = new Migration("ociMigrationResource", MigrationArgs.builder()
.databaseCombination("string")
.type("string")
.targetDatabaseConnectionId("string")
.compartmentId("string")
.sourceDatabaseConnectionId("string")
.displayName("string")
.hubDetails(MigrationHubDetailsArgs.builder()
.keyId("string")
.restAdminCredentials(MigrationHubDetailsRestAdminCredentialsArgs.builder()
.password("string")
.username("string")
.build())
.url("string")
.vaultId("string")
.acceptableLag(0)
.computeId("string")
.extract(MigrationHubDetailsExtractArgs.builder()
.longTransDuration(0)
.performanceProfile("string")
.build())
.replicat(MigrationHubDetailsReplicatArgs.builder()
.performanceProfile("string")
.build())
.build())
.description("string")
.advancedParameters(MigrationAdvancedParameterArgs.builder()
.dataType("string")
.name("string")
.value("string")
.build())
.excludeObjects(MigrationExcludeObjectArgs.builder()
.object("string")
.isOmitExcludedTableFromReplication(false)
.owner("string")
.schema("string")
.type("string")
.build())
.freeformTags(Map.of("string", "string"))
.ggsDetails(MigrationGgsDetailsArgs.builder()
.acceptableLag(0)
.extract(MigrationGgsDetailsExtractArgs.builder()
.longTransDuration(0)
.performanceProfile("string")
.build())
.ggsDeployments(MigrationGgsDetailsGgsDeploymentArgs.builder()
.deploymentId("string")
.ggsAdminCredentialsSecretId("string")
.build())
.replicat(MigrationGgsDetailsReplicatArgs.builder()
.performanceProfile("string")
.build())
.build())
.definedTags(Map.of("string", "string"))
.includeObjects(MigrationIncludeObjectArgs.builder()
.object("string")
.isOmitExcludedTableFromReplication(false)
.owner("string")
.schema("string")
.type("string")
.build())
.initialLoadSettings(MigrationInitialLoadSettingsArgs.builder()
.jobMode("string")
.compatibilities("string")
.dataPumpParameters(MigrationInitialLoadSettingsDataPumpParametersArgs.builder()
.estimate("string")
.excludeParameters("string")
.exportParallelismDegree(0)
.importParallelismDegree(0)
.isCluster(false)
.tableExistsAction("string")
.build())
.exportDirectoryObject(MigrationInitialLoadSettingsExportDirectoryObjectArgs.builder()
.name("string")
.path("string")
.build())
.handleGrantErrors("string")
.importDirectoryObject(MigrationInitialLoadSettingsImportDirectoryObjectArgs.builder()
.name("string")
.path("string")
.build())
.isConsistent(false)
.isIgnoreExistingObjects(false)
.isTzUtc(false)
.metadataRemaps(MigrationInitialLoadSettingsMetadataRemapArgs.builder()
.newValue("string")
.oldValue("string")
.type("string")
.build())
.primaryKeyCompatibility("string")
.tablespaceDetails(MigrationInitialLoadSettingsTablespaceDetailsArgs.builder()
.targetType("string")
.blockSizeInKbs("string")
.extendSizeInMbs(0)
.isAutoCreate(false)
.isBigFile(false)
.remapTarget("string")
.build())
.build())
.sourceContainerDatabaseConnectionId("string")
.dataTransferMediumDetails(MigrationDataTransferMediumDetailsArgs.builder()
.type("string")
.accessKeyId("string")
.name("string")
.objectStorageBucket(MigrationDataTransferMediumDetailsObjectStorageBucketArgs.builder()
.bucket("string")
.namespace("string")
.build())
.region("string")
.secretAccessKey("string")
.sharedStorageMountTargetId("string")
.source(MigrationDataTransferMediumDetailsSourceArgs.builder()
.kind("string")
.ociHome("string")
.walletLocation("string")
.build())
.target(MigrationDataTransferMediumDetailsTargetArgs.builder()
.kind("string")
.ociHome("string")
.walletLocation("string")
.build())
.build())
.bulkIncludeExcludeData("string")
.advisorSettings(MigrationAdvisorSettingsArgs.builder()
.isIgnoreErrors(false)
.isSkipAdvisor(false)
.build())
.build());
oci_migration_resource = oci.database_migration.Migration("ociMigrationResource",
database_combination="string",
type="string",
target_database_connection_id="string",
compartment_id="string",
source_database_connection_id="string",
display_name="string",
hub_details={
"key_id": "string",
"rest_admin_credentials": {
"password": "string",
"username": "string",
},
"url": "string",
"vault_id": "string",
"acceptable_lag": 0,
"compute_id": "string",
"extract": {
"long_trans_duration": 0,
"performance_profile": "string",
},
"replicat": {
"performance_profile": "string",
},
},
description="string",
advanced_parameters=[{
"data_type": "string",
"name": "string",
"value": "string",
}],
exclude_objects=[{
"object": "string",
"is_omit_excluded_table_from_replication": False,
"owner": "string",
"schema": "string",
"type": "string",
}],
freeform_tags={
"string": "string",
},
ggs_details={
"acceptable_lag": 0,
"extract": {
"long_trans_duration": 0,
"performance_profile": "string",
},
"ggs_deployments": [{
"deployment_id": "string",
"ggs_admin_credentials_secret_id": "string",
}],
"replicat": {
"performance_profile": "string",
},
},
defined_tags={
"string": "string",
},
include_objects=[{
"object": "string",
"is_omit_excluded_table_from_replication": False,
"owner": "string",
"schema": "string",
"type": "string",
}],
initial_load_settings={
"job_mode": "string",
"compatibilities": ["string"],
"data_pump_parameters": {
"estimate": "string",
"exclude_parameters": ["string"],
"export_parallelism_degree": 0,
"import_parallelism_degree": 0,
"is_cluster": False,
"table_exists_action": "string",
},
"export_directory_object": {
"name": "string",
"path": "string",
},
"handle_grant_errors": "string",
"import_directory_object": {
"name": "string",
"path": "string",
},
"is_consistent": False,
"is_ignore_existing_objects": False,
"is_tz_utc": False,
"metadata_remaps": [{
"new_value": "string",
"old_value": "string",
"type": "string",
}],
"primary_key_compatibility": "string",
"tablespace_details": {
"target_type": "string",
"block_size_in_kbs": "string",
"extend_size_in_mbs": 0,
"is_auto_create": False,
"is_big_file": False,
"remap_target": "string",
},
},
source_container_database_connection_id="string",
data_transfer_medium_details={
"type": "string",
"access_key_id": "string",
"name": "string",
"object_storage_bucket": {
"bucket": "string",
"namespace": "string",
},
"region": "string",
"secret_access_key": "string",
"shared_storage_mount_target_id": "string",
"source": {
"kind": "string",
"oci_home": "string",
"wallet_location": "string",
},
"target": {
"kind": "string",
"oci_home": "string",
"wallet_location": "string",
},
},
bulk_include_exclude_data="string",
advisor_settings={
"is_ignore_errors": False,
"is_skip_advisor": False,
})
const ociMigrationResource = new oci.databasemigration.Migration("ociMigrationResource", {
databaseCombination: "string",
type: "string",
targetDatabaseConnectionId: "string",
compartmentId: "string",
sourceDatabaseConnectionId: "string",
displayName: "string",
hubDetails: {
keyId: "string",
restAdminCredentials: {
password: "string",
username: "string",
},
url: "string",
vaultId: "string",
acceptableLag: 0,
computeId: "string",
extract: {
longTransDuration: 0,
performanceProfile: "string",
},
replicat: {
performanceProfile: "string",
},
},
description: "string",
advancedParameters: [{
dataType: "string",
name: "string",
value: "string",
}],
excludeObjects: [{
object: "string",
isOmitExcludedTableFromReplication: false,
owner: "string",
schema: "string",
type: "string",
}],
freeformTags: {
string: "string",
},
ggsDetails: {
acceptableLag: 0,
extract: {
longTransDuration: 0,
performanceProfile: "string",
},
ggsDeployments: [{
deploymentId: "string",
ggsAdminCredentialsSecretId: "string",
}],
replicat: {
performanceProfile: "string",
},
},
definedTags: {
string: "string",
},
includeObjects: [{
object: "string",
isOmitExcludedTableFromReplication: false,
owner: "string",
schema: "string",
type: "string",
}],
initialLoadSettings: {
jobMode: "string",
compatibilities: ["string"],
dataPumpParameters: {
estimate: "string",
excludeParameters: ["string"],
exportParallelismDegree: 0,
importParallelismDegree: 0,
isCluster: false,
tableExistsAction: "string",
},
exportDirectoryObject: {
name: "string",
path: "string",
},
handleGrantErrors: "string",
importDirectoryObject: {
name: "string",
path: "string",
},
isConsistent: false,
isIgnoreExistingObjects: false,
isTzUtc: false,
metadataRemaps: [{
newValue: "string",
oldValue: "string",
type: "string",
}],
primaryKeyCompatibility: "string",
tablespaceDetails: {
targetType: "string",
blockSizeInKbs: "string",
extendSizeInMbs: 0,
isAutoCreate: false,
isBigFile: false,
remapTarget: "string",
},
},
sourceContainerDatabaseConnectionId: "string",
dataTransferMediumDetails: {
type: "string",
accessKeyId: "string",
name: "string",
objectStorageBucket: {
bucket: "string",
namespace: "string",
},
region: "string",
secretAccessKey: "string",
sharedStorageMountTargetId: "string",
source: {
kind: "string",
ociHome: "string",
walletLocation: "string",
},
target: {
kind: "string",
ociHome: "string",
walletLocation: "string",
},
},
bulkIncludeExcludeData: "string",
advisorSettings: {
isIgnoreErrors: false,
isSkipAdvisor: false,
},
});
type: oci:DatabaseMigration:Migration
properties:
advancedParameters:
- dataType: string
name: string
value: string
advisorSettings:
isIgnoreErrors: false
isSkipAdvisor: false
bulkIncludeExcludeData: string
compartmentId: string
dataTransferMediumDetails:
accessKeyId: string
name: string
objectStorageBucket:
bucket: string
namespace: string
region: string
secretAccessKey: string
sharedStorageMountTargetId: string
source:
kind: string
ociHome: string
walletLocation: string
target:
kind: string
ociHome: string
walletLocation: string
type: string
databaseCombination: string
definedTags:
string: string
description: string
displayName: string
excludeObjects:
- isOmitExcludedTableFromReplication: false
object: string
owner: string
schema: string
type: string
freeformTags:
string: string
ggsDetails:
acceptableLag: 0
extract:
longTransDuration: 0
performanceProfile: string
ggsDeployments:
- deploymentId: string
ggsAdminCredentialsSecretId: string
replicat:
performanceProfile: string
hubDetails:
acceptableLag: 0
computeId: string
extract:
longTransDuration: 0
performanceProfile: string
keyId: string
replicat:
performanceProfile: string
restAdminCredentials:
password: string
username: string
url: string
vaultId: string
includeObjects:
- isOmitExcludedTableFromReplication: false
object: string
owner: string
schema: string
type: string
initialLoadSettings:
compatibilities:
- string
dataPumpParameters:
estimate: string
excludeParameters:
- string
exportParallelismDegree: 0
importParallelismDegree: 0
isCluster: false
tableExistsAction: string
exportDirectoryObject:
name: string
path: string
handleGrantErrors: string
importDirectoryObject:
name: string
path: string
isConsistent: false
isIgnoreExistingObjects: false
isTzUtc: false
jobMode: string
metadataRemaps:
- newValue: string
oldValue: string
type: string
primaryKeyCompatibility: string
tablespaceDetails:
blockSizeInKbs: string
extendSizeInMbs: 0
isAutoCreate: false
isBigFile: false
remapTarget: string
targetType: string
sourceContainerDatabaseConnectionId: string
sourceDatabaseConnectionId: string
targetDatabaseConnectionId: string
type: string
Migration Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The Migration resource accepts the following input properties:
- Compartment
Id string - (Updatable) The OCID of the resource being referenced.
- Database
Combination string - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Source
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- Target
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- Type string
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- Advanced
Parameters List<MigrationAdvanced Parameter> - (Updatable) List of Migration Parameter objects.
- Advisor
Settings MigrationAdvisor Settings - (Updatable) Optional Pre-Migration advisor settings.
- Bulk
Include stringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- Data
Transfer MigrationMedium Details Data Transfer Medium Details - (Updatable) Optional additional properties for data transfer.
- Dictionary<string, string>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Display
Name string - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Exclude
Objects List<MigrationExclude Object> - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- Dictionary<string, string>
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- Ggs
Details MigrationGgs Details - (Updatable) Optional settings for Oracle GoldenGate processes
- Hub
Details MigrationHub Details - (Updatable) Details about Oracle GoldenGate Microservices.
- Include
Objects List<MigrationInclude Object> - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- Initial
Load MigrationSettings Initial Load Settings - (Updatable) Optional settings for Data Pump Export and Import jobs
- Source
Container stringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- Compartment
Id string - (Updatable) The OCID of the resource being referenced.
- Database
Combination string - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Source
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- Target
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- Type string
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- Advanced
Parameters []MigrationAdvanced Parameter Args - (Updatable) List of Migration Parameter objects.
- Advisor
Settings MigrationAdvisor Settings Args - (Updatable) Optional Pre-Migration advisor settings.
- Bulk
Include stringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- Data
Transfer MigrationMedium Details Data Transfer Medium Details Args - (Updatable) Optional additional properties for data transfer.
- map[string]string
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Display
Name string - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Exclude
Objects []MigrationExclude Object Args - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- map[string]string
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- Ggs
Details MigrationGgs Details Args - (Updatable) Optional settings for Oracle GoldenGate processes
- Hub
Details MigrationHub Details Args - (Updatable) Details about Oracle GoldenGate Microservices.
- Include
Objects []MigrationInclude Object Args - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- Initial
Load MigrationSettings Initial Load Settings Args - (Updatable) Optional settings for Data Pump Export and Import jobs
- Source
Container stringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- compartment
Id String - (Updatable) The OCID of the resource being referenced.
- database
Combination String - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- source
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- target
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- type String
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- advanced
Parameters List<MigrationAdvanced Parameter> - (Updatable) List of Migration Parameter objects.
- advisor
Settings MigrationAdvisor Settings - (Updatable) Optional Pre-Migration advisor settings.
- bulk
Include StringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- data
Transfer MigrationMedium Details Data Transfer Medium Details - (Updatable) Optional additional properties for data transfer.
- Map<String,String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name String - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects List<MigrationExclude Object> - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- Map<String,String>
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details MigrationGgs Details - (Updatable) Optional settings for Oracle GoldenGate processes
- hub
Details MigrationHub Details - (Updatable) Details about Oracle GoldenGate Microservices.
- include
Objects List<MigrationInclude Object> - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial
Load MigrationSettings Initial Load Settings - (Updatable) Optional settings for Data Pump Export and Import jobs
- source
Container StringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- compartment
Id string - (Updatable) The OCID of the resource being referenced.
- database
Combination string - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- source
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- target
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- type string
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- advanced
Parameters MigrationAdvanced Parameter[] - (Updatable) List of Migration Parameter objects.
- advisor
Settings MigrationAdvisor Settings - (Updatable) Optional Pre-Migration advisor settings.
- bulk
Include stringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- data
Transfer MigrationMedium Details Data Transfer Medium Details - (Updatable) Optional additional properties for data transfer.
- {[key: string]: string}
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description string
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name string - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects MigrationExclude Object[] - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- {[key: string]: string}
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details MigrationGgs Details - (Updatable) Optional settings for Oracle GoldenGate processes
- hub
Details MigrationHub Details - (Updatable) Details about Oracle GoldenGate Microservices.
- include
Objects MigrationInclude Object[] - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial
Load MigrationSettings Initial Load Settings - (Updatable) Optional settings for Data Pump Export and Import jobs
- source
Container stringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- compartment_
id str - (Updatable) The OCID of the resource being referenced.
- database_
combination str - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- source_
database_ strconnection_ id - (Updatable) The OCID of the resource being referenced.
- target_
database_ strconnection_ id - (Updatable) The OCID of the resource being referenced.
- type str
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- advanced_
parameters Sequence[databasemigration.Migration Advanced Parameter Args] - (Updatable) List of Migration Parameter objects.
- advisor_
settings databasemigration.Migration Advisor Settings Args - (Updatable) Optional Pre-Migration advisor settings.
- bulk_
include_ strexclude_ data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- data_
transfer_ databasemigration.medium_ details Migration Data Transfer Medium Details Args - (Updatable) Optional additional properties for data transfer.
- Mapping[str, str]
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description str
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display_
name str - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude_
objects Sequence[databasemigration.Migration Exclude Object Args] - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- Mapping[str, str]
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs_
details databasemigration.Migration Ggs Details Args - (Updatable) Optional settings for Oracle GoldenGate processes
- hub_
details databasemigration.Migration Hub Details Args - (Updatable) Details about Oracle GoldenGate Microservices.
- include_
objects Sequence[databasemigration.Migration Include Object Args] - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial_
load_ databasemigration.settings Migration Initial Load Settings Args - (Updatable) Optional settings for Data Pump Export and Import jobs
- source_
container_ strdatabase_ connection_ id - (Updatable) The OCID of the resource being referenced.
- compartment
Id String - (Updatable) The OCID of the resource being referenced.
- database
Combination String - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- source
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- target
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- type String
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- advanced
Parameters List<Property Map> - (Updatable) List of Migration Parameter objects.
- advisor
Settings Property Map - (Updatable) Optional Pre-Migration advisor settings.
- bulk
Include StringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- data
Transfer Property MapMedium Details - (Updatable) Optional additional properties for data transfer.
- Map<String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name String - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects List<Property Map> - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- Map<String>
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details Property Map - (Updatable) Optional settings for Oracle GoldenGate processes
- hub
Details Property Map - (Updatable) Details about Oracle GoldenGate Microservices.
- include
Objects List<Property Map> - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial
Load Property MapSettings - (Updatable) Optional settings for Data Pump Export and Import jobs
- source
Container StringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
Outputs
All input properties are implicitly available as output properties. Additionally, the Migration resource produces the following output properties:
- Executing
Job stringId - The OCID of the resource being referenced.
- Id string
- The provider-assigned unique ID for this managed resource.
- Lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- State string
- The current state of the Migration resource.
- Dictionary<string, string>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - Time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- Executing
Job stringId - The OCID of the resource being referenced.
- Id string
- The provider-assigned unique ID for this managed resource.
- Lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- State string
- The current state of the Migration resource.
- map[string]string
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - Time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- executing
Job StringId - The OCID of the resource being referenced.
- id String
- The provider-assigned unique ID for this managed resource.
- lifecycle
Details String - Additional status related to the execution and current state of the Migration.
- state String
- The current state of the Migration resource.
- Map<String,String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - time
Created String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Last StringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Updated String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - wait
After String - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- executing
Job stringId - The OCID of the resource being referenced.
- id string
- The provider-assigned unique ID for this managed resource.
- lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- state string
- The current state of the Migration resource.
- {[key: string]: string}
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- executing_
job_ strid - The OCID of the resource being referenced.
- id str
- The provider-assigned unique ID for this managed resource.
- lifecycle_
details str - Additional status related to the execution and current state of the Migration.
- state str
- The current state of the Migration resource.
- Mapping[str, str]
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - time_
created str - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time_
last_ strmigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time_
updated str - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - wait_
after str - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- executing
Job StringId - The OCID of the resource being referenced.
- id String
- The provider-assigned unique ID for this managed resource.
- lifecycle
Details String - Additional status related to the execution and current state of the Migration.
- state String
- The current state of the Migration resource.
- Map<String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - time
Created String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Last StringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Updated String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - wait
After String - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
Look up Existing Migration Resource
Get an existing Migration resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: MigrationState, opts?: CustomResourceOptions): Migration@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
advanced_parameters: Optional[Sequence[_databasemigration.MigrationAdvancedParameterArgs]] = None,
advisor_settings: Optional[_databasemigration.MigrationAdvisorSettingsArgs] = None,
bulk_include_exclude_data: Optional[str] = None,
compartment_id: Optional[str] = None,
data_transfer_medium_details: Optional[_databasemigration.MigrationDataTransferMediumDetailsArgs] = None,
database_combination: Optional[str] = None,
defined_tags: Optional[Mapping[str, str]] = None,
description: Optional[str] = None,
display_name: Optional[str] = None,
exclude_objects: Optional[Sequence[_databasemigration.MigrationExcludeObjectArgs]] = None,
executing_job_id: Optional[str] = None,
freeform_tags: Optional[Mapping[str, str]] = None,
ggs_details: Optional[_databasemigration.MigrationGgsDetailsArgs] = None,
hub_details: Optional[_databasemigration.MigrationHubDetailsArgs] = None,
include_objects: Optional[Sequence[_databasemigration.MigrationIncludeObjectArgs]] = None,
initial_load_settings: Optional[_databasemigration.MigrationInitialLoadSettingsArgs] = None,
lifecycle_details: Optional[str] = None,
source_container_database_connection_id: Optional[str] = None,
source_database_connection_id: Optional[str] = None,
state: Optional[str] = None,
system_tags: Optional[Mapping[str, str]] = None,
target_database_connection_id: Optional[str] = None,
time_created: Optional[str] = None,
time_last_migration: Optional[str] = None,
time_updated: Optional[str] = None,
type: Optional[str] = None,
wait_after: Optional[str] = None) -> Migrationfunc GetMigration(ctx *Context, name string, id IDInput, state *MigrationState, opts ...ResourceOption) (*Migration, error)public static Migration Get(string name, Input<string> id, MigrationState? state, CustomResourceOptions? opts = null)public static Migration get(String name, Output<String> id, MigrationState state, CustomResourceOptions options)Resource lookup is not supported in YAML- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Advanced
Parameters List<MigrationAdvanced Parameter> - (Updatable) List of Migration Parameter objects.
- Advisor
Settings MigrationAdvisor Settings - (Updatable) Optional Pre-Migration advisor settings.
- Bulk
Include stringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- Compartment
Id string - (Updatable) The OCID of the resource being referenced.
- Data
Transfer MigrationMedium Details Data Transfer Medium Details - (Updatable) Optional additional properties for data transfer.
- Database
Combination string - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Dictionary<string, string>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Display
Name string - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Exclude
Objects List<MigrationExclude Object> - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- Executing
Job stringId - The OCID of the resource being referenced.
- Dictionary<string, string>
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- Ggs
Details MigrationGgs Details - (Updatable) Optional settings for Oracle GoldenGate processes
- Hub
Details MigrationHub Details - (Updatable) Details about Oracle GoldenGate Microservices.
- Include
Objects List<MigrationInclude Object> - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- Initial
Load MigrationSettings Initial Load Settings - (Updatable) Optional settings for Data Pump Export and Import jobs
- Lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- Source
Container stringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- Source
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- State string
- The current state of the Migration resource.
- Dictionary<string, string>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - Target
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- Time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Type string
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- Wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- Advanced
Parameters []MigrationAdvanced Parameter Args - (Updatable) List of Migration Parameter objects.
- Advisor
Settings MigrationAdvisor Settings Args - (Updatable) Optional Pre-Migration advisor settings.
- Bulk
Include stringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- Compartment
Id string - (Updatable) The OCID of the resource being referenced.
- Data
Transfer MigrationMedium Details Data Transfer Medium Details Args - (Updatable) Optional additional properties for data transfer.
- Database
Combination string - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- map[string]string
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - Description string
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Display
Name string - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Exclude
Objects []MigrationExclude Object Args - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- Executing
Job stringId - The OCID of the resource being referenced.
- map[string]string
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- Ggs
Details MigrationGgs Details Args - (Updatable) Optional settings for Oracle GoldenGate processes
- Hub
Details MigrationHub Details Args - (Updatable) Details about Oracle GoldenGate Microservices.
- Include
Objects []MigrationInclude Object Args - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- Initial
Load MigrationSettings Initial Load Settings Args - (Updatable) Optional settings for Data Pump Export and Import jobs
- Lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- Source
Container stringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- Source
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- State string
- The current state of the Migration resource.
- map[string]string
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - Target
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- Time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - Type string
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- Wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced
Parameters List<MigrationAdvanced Parameter> - (Updatable) List of Migration Parameter objects.
- advisor
Settings MigrationAdvisor Settings - (Updatable) Optional Pre-Migration advisor settings.
- bulk
Include StringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- compartment
Id String - (Updatable) The OCID of the resource being referenced.
- data
Transfer MigrationMedium Details Data Transfer Medium Details - (Updatable) Optional additional properties for data transfer.
- database
Combination String - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Map<String,String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name String - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects List<MigrationExclude Object> - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- executing
Job StringId - The OCID of the resource being referenced.
- Map<String,String>
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details MigrationGgs Details - (Updatable) Optional settings for Oracle GoldenGate processes
- hub
Details MigrationHub Details - (Updatable) Details about Oracle GoldenGate Microservices.
- include
Objects List<MigrationInclude Object> - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial
Load MigrationSettings Initial Load Settings - (Updatable) Optional settings for Data Pump Export and Import jobs
- lifecycle
Details String - Additional status related to the execution and current state of the Migration.
- source
Container StringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- source
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- state String
- The current state of the Migration resource.
- Map<String,String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - target
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- time
Created String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Last StringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Updated String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - type String
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- wait
After String - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced
Parameters MigrationAdvanced Parameter[] - (Updatable) List of Migration Parameter objects.
- advisor
Settings MigrationAdvisor Settings - (Updatable) Optional Pre-Migration advisor settings.
- bulk
Include stringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- compartment
Id string - (Updatable) The OCID of the resource being referenced.
- data
Transfer MigrationMedium Details Data Transfer Medium Details - (Updatable) Optional additional properties for data transfer.
- database
Combination string - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- {[key: string]: string}
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description string
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name string - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects MigrationExclude Object[] - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- executing
Job stringId - The OCID of the resource being referenced.
- {[key: string]: string}
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details MigrationGgs Details - (Updatable) Optional settings for Oracle GoldenGate processes
- hub
Details MigrationHub Details - (Updatable) Details about Oracle GoldenGate Microservices.
- include
Objects MigrationInclude Object[] - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial
Load MigrationSettings Initial Load Settings - (Updatable) Optional settings for Data Pump Export and Import jobs
- lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- source
Container stringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- source
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- state string
- The current state of the Migration resource.
- {[key: string]: string}
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - target
Database stringConnection Id - (Updatable) The OCID of the resource being referenced.
- time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - type string
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced_
parameters Sequence[databasemigration.Migration Advanced Parameter Args] - (Updatable) List of Migration Parameter objects.
- advisor_
settings databasemigration.Migration Advisor Settings Args - (Updatable) Optional Pre-Migration advisor settings.
- bulk_
include_ strexclude_ data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- compartment_
id str - (Updatable) The OCID of the resource being referenced.
- data_
transfer_ databasemigration.medium_ details Migration Data Transfer Medium Details Args - (Updatable) Optional additional properties for data transfer.
- database_
combination str - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Mapping[str, str]
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description str
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display_
name str - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude_
objects Sequence[databasemigration.Migration Exclude Object Args] - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- executing_
job_ strid - The OCID of the resource being referenced.
- Mapping[str, str]
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs_
details databasemigration.Migration Ggs Details Args - (Updatable) Optional settings for Oracle GoldenGate processes
- hub_
details databasemigration.Migration Hub Details Args - (Updatable) Details about Oracle GoldenGate Microservices.
- include_
objects Sequence[databasemigration.Migration Include Object Args] - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial_
load_ databasemigration.settings Migration Initial Load Settings Args - (Updatable) Optional settings for Data Pump Export and Import jobs
- lifecycle_
details str - Additional status related to the execution and current state of the Migration.
- source_
container_ strdatabase_ connection_ id - (Updatable) The OCID of the resource being referenced.
- source_
database_ strconnection_ id - (Updatable) The OCID of the resource being referenced.
- state str
- The current state of the Migration resource.
- Mapping[str, str]
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - target_
database_ strconnection_ id - (Updatable) The OCID of the resource being referenced.
- time_
created str - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time_
last_ strmigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time_
updated str - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - type str
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- wait_
after str - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced
Parameters List<Property Map> - (Updatable) List of Migration Parameter objects.
- advisor
Settings Property Map - (Updatable) Optional Pre-Migration advisor settings.
- bulk
Include StringExclude Data - Specifies the database objects to be excluded from the migration in bulk. The definition accepts input in a CSV format, newline separated for each entry. More details can be found in the documentation.
- compartment
Id String - (Updatable) The OCID of the resource being referenced.
- data
Transfer Property MapMedium Details - (Updatable) Optional additional properties for data transfer.
- database
Combination String - (Updatable) The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Map<String>
- (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"} - description String
- (Updatable) A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name String - (Updatable) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects List<Property Map> - Database objects to exclude from migration, cannot be specified alongside 'includeObjects'
- executing
Job StringId - The OCID of the resource being referenced.
- Map<String>
- (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details Property Map - (Updatable) Optional settings for Oracle GoldenGate processes
- hub
Details Property Map - (Updatable) Details about Oracle GoldenGate Microservices.
- include
Objects List<Property Map> - Database objects to include from migration, cannot be specified alongside 'excludeObjects'
- initial
Load Property MapSettings - (Updatable) Optional settings for Data Pump Export and Import jobs
- lifecycle
Details String - Additional status related to the execution and current state of the Migration.
- source
Container StringDatabase Connection Id - (Updatable) The OCID of the resource being referenced.
- source
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- state String
- The current state of the Migration resource.
- Map<String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"} - target
Database StringConnection Id - (Updatable) The OCID of the resource being referenced.
- time
Created String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Last StringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - time
Updated String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z. - type String
(Updatable) The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
** 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
- wait
After String - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
Supporting Types
MigrationAdvancedParameter, MigrationAdvancedParameterArgs
- Data
Type string - (Updatable) Parameter data type.
- Name string
- (Updatable) Parameter name.
- Value string
- (Updatable) If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- Data
Type string - (Updatable) Parameter data type.
- Name string
- (Updatable) Parameter name.
- Value string
- (Updatable) If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data
Type String - (Updatable) Parameter data type.
- name String
- (Updatable) Parameter name.
- value String
- (Updatable) If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data
Type string - (Updatable) Parameter data type.
- name string
- (Updatable) Parameter name.
- value string
- (Updatable) If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data_
type str - (Updatable) Parameter data type.
- name str
- (Updatable) Parameter name.
- value str
- (Updatable) If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data
Type String - (Updatable) Parameter data type.
- name String
- (Updatable) Parameter name.
- value String
- (Updatable) If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
MigrationAdvisorSettings, MigrationAdvisorSettingsArgs
- Is
Ignore boolErrors - (Updatable) True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- Is
Skip boolAdvisor - (Updatable) True to skip the Pre-Migration Advisor execution. Default is false.
- Is
Ignore boolErrors - (Updatable) True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- Is
Skip boolAdvisor - (Updatable) True to skip the Pre-Migration Advisor execution. Default is false.
- is
Ignore BooleanErrors - (Updatable) True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is
Skip BooleanAdvisor - (Updatable) True to skip the Pre-Migration Advisor execution. Default is false.
- is
Ignore booleanErrors - (Updatable) True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is
Skip booleanAdvisor - (Updatable) True to skip the Pre-Migration Advisor execution. Default is false.
- is_
ignore_ boolerrors - (Updatable) True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is_
skip_ booladvisor - (Updatable) True to skip the Pre-Migration Advisor execution. Default is false.
- is
Ignore BooleanErrors - (Updatable) True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is
Skip BooleanAdvisor - (Updatable) True to skip the Pre-Migration Advisor execution. Default is false.
MigrationDataTransferMediumDetails, MigrationDataTransferMediumDetailsArgs
- Type string
- (Updatable) Type of the data transfer medium to use.
- Access
Key stringId - (Updatable) AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- Name string
- (Updatable) Name of database link from Oracle Cloud Infrastructure database to on-premise database. ODMS will create link, if the link does not already exist.
- Object
Storage MigrationBucket Data Transfer Medium Details Object Storage Bucket - (Updatable) In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- Region string
- (Updatable) AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- Secret
Access stringKey - (Updatable) AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- string
- (Updatable) OCID of the shared storage mount target
- Source
Migration
Data Transfer Medium Details Source - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Target
Migration
Data Transfer Medium Details Target - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Type string
- (Updatable) Type of the data transfer medium to use.
- Access
Key stringId - (Updatable) AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- Name string
- (Updatable) Name of database link from Oracle Cloud Infrastructure database to on-premise database. ODMS will create link, if the link does not already exist.
- Object
Storage MigrationBucket Data Transfer Medium Details Object Storage Bucket - (Updatable) In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- Region string
- (Updatable) AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- Secret
Access stringKey - (Updatable) AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- string
- (Updatable) OCID of the shared storage mount target
- Source
Migration
Data Transfer Medium Details Source - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Target
Migration
Data Transfer Medium Details Target - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type String
- (Updatable) Type of the data transfer medium to use.
- access
Key StringId - (Updatable) AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name String
- (Updatable) Name of database link from Oracle Cloud Infrastructure database to on-premise database. ODMS will create link, if the link does not already exist.
- object
Storage MigrationBucket Data Transfer Medium Details Object Storage Bucket - (Updatable) In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region String
- (Updatable) AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret
Access StringKey - (Updatable) AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- String
- (Updatable) OCID of the shared storage mount target
- source
Migration
Data Transfer Medium Details Source - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- target
Migration
Data Transfer Medium Details Target - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type string
- (Updatable) Type of the data transfer medium to use.
- access
Key stringId - (Updatable) AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name string
- (Updatable) Name of database link from Oracle Cloud Infrastructure database to on-premise database. ODMS will create link, if the link does not already exist.
- object
Storage MigrationBucket Data Transfer Medium Details Object Storage Bucket - (Updatable) In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region string
- (Updatable) AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret
Access stringKey - (Updatable) AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- string
- (Updatable) OCID of the shared storage mount target
- source
Migration
Data Transfer Medium Details Source - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- target
Migration
Data Transfer Medium Details Target - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type str
- (Updatable) Type of the data transfer medium to use.
- access_
key_ strid - (Updatable) AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name str
- (Updatable) Name of database link from Oracle Cloud Infrastructure database to on-premise database. ODMS will create link, if the link does not already exist.
- object_
storage_ databasemigration.bucket Migration Data Transfer Medium Details Object Storage Bucket - (Updatable) In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region str
- (Updatable) AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret_
access_ strkey - (Updatable) AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- str
- (Updatable) OCID of the shared storage mount target
- source
databasemigration.
Migration Data Transfer Medium Details Source - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- target
databasemigration.
Migration Data Transfer Medium Details Target - (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type String
- (Updatable) Type of the data transfer medium to use.
- access
Key StringId - (Updatable) AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name String
- (Updatable) Name of database link from Oracle Cloud Infrastructure database to on-premise database. ODMS will create link, if the link does not already exist.
- object
Storage Property MapBucket - (Updatable) In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region String
- (Updatable) AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret
Access StringKey - (Updatable) AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- String
- (Updatable) OCID of the shared storage mount target
- source Property Map
- (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- target Property Map
- (Updatable) Optional additional properties for dump transfer in source or target host. Default kind is CURL.
MigrationDataTransferMediumDetailsObjectStorageBucket, MigrationDataTransferMediumDetailsObjectStorageBucketArgs
MigrationDataTransferMediumDetailsSource, MigrationDataTransferMediumDetailsSourceArgs
- Kind string
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- Kind string
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind string
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home string - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location string - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind str
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci_
home str - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet_
location str - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
MigrationDataTransferMediumDetailsTarget, MigrationDataTransferMediumDetailsTargetArgs
- Kind string
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- Kind string
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind string
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home string - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location string - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind str
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci_
home str - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet_
location str - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- (Updatable) Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - (Updatable) Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - (Updatable) Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
MigrationExcludeObject, MigrationExcludeObjectArgs
- Object string
- Name of the object (regular expression is allowed)
- Is
Omit boolExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- Owner string
- Owner of the object (regular expression is allowed)
- Schema string
- Schema of the object (regular expression is allowed)
- Type string
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- Object string
- Name of the object (regular expression is allowed)
- Is
Omit boolExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- Owner string
- Owner of the object (regular expression is allowed)
- Schema string
- Schema of the object (regular expression is allowed)
- Type string
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object String
- Name of the object (regular expression is allowed)
- is
Omit BooleanExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner String
- Owner of the object (regular expression is allowed)
- schema String
- Schema of the object (regular expression is allowed)
- type String
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object string
- Name of the object (regular expression is allowed)
- is
Omit booleanExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner string
- Owner of the object (regular expression is allowed)
- schema string
- Schema of the object (regular expression is allowed)
- type string
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object str
- Name of the object (regular expression is allowed)
- is_
omit_ boolexcluded_ table_ from_ replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner str
- Owner of the object (regular expression is allowed)
- schema str
- Schema of the object (regular expression is allowed)
- type str
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object String
- Name of the object (regular expression is allowed)
- is
Omit BooleanExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner String
- Owner of the object (regular expression is allowed)
- schema String
- Schema of the object (regular expression is allowed)
- type String
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
MigrationGgsDetails, MigrationGgsDetailsArgs
- Acceptable
Lag int - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Extract
Migration
Ggs Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- Ggs
Deployments List<MigrationGgs Details Ggs Deployment> - Details about Oracle GoldenGate GGS Deployment.
- Replicat
Migration
Ggs Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- Acceptable
Lag int - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Extract
Migration
Ggs Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- Ggs
Deployments []MigrationGgs Details Ggs Deployment - Details about Oracle GoldenGate GGS Deployment.
- Replicat
Migration
Ggs Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- acceptable
Lag Integer - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extract
Migration
Ggs Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- ggs
Deployments List<MigrationGgs Details Ggs Deployment> - Details about Oracle GoldenGate GGS Deployment.
- replicat
Migration
Ggs Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- acceptable
Lag number - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extract
Migration
Ggs Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- ggs
Deployments MigrationGgs Details Ggs Deployment[] - Details about Oracle GoldenGate GGS Deployment.
- replicat
Migration
Ggs Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- acceptable_
lag int - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extract
databasemigration.
Migration Ggs Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- ggs_
deployments Sequence[databasemigration.Migration Ggs Details Ggs Deployment] - Details about Oracle GoldenGate GGS Deployment.
- replicat
databasemigration.
Migration Ggs Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- acceptable
Lag Number - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extract Property Map
- (Updatable) Parameters for GoldenGate Extract processes.
- ggs
Deployments List<Property Map> - Details about Oracle GoldenGate GGS Deployment.
- replicat Property Map
- (Updatable) Parameters for GoldenGate Replicat processes.
MigrationGgsDetailsExtract, MigrationGgsDetailsExtractArgs
- Long
Trans intDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - (Updatable) Extract performance.
- Long
Trans intDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - (Updatable) Extract performance.
- long
Trans IntegerDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - (Updatable) Extract performance.
- long
Trans numberDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile string - (Updatable) Extract performance.
- long_
trans_ intduration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance_
profile str - (Updatable) Extract performance.
- long
Trans NumberDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - (Updatable) Extract performance.
MigrationGgsDetailsGgsDeployment, MigrationGgsDetailsGgsDeploymentArgs
- Deployment
Id string - The OCID of the resource being referenced.
- Ggs
Admin stringCredentials Secret Id - The OCID of the resource being referenced.
- Deployment
Id string - The OCID of the resource being referenced.
- Ggs
Admin stringCredentials Secret Id - The OCID of the resource being referenced.
- deployment
Id String - The OCID of the resource being referenced.
- ggs
Admin StringCredentials Secret Id - The OCID of the resource being referenced.
- deployment
Id string - The OCID of the resource being referenced.
- ggs
Admin stringCredentials Secret Id - The OCID of the resource being referenced.
- deployment_
id str - The OCID of the resource being referenced.
- ggs_
admin_ strcredentials_ secret_ id - The OCID of the resource being referenced.
- deployment
Id String - The OCID of the resource being referenced.
- ggs
Admin StringCredentials Secret Id - The OCID of the resource being referenced.
MigrationGgsDetailsReplicat, MigrationGgsDetailsReplicatArgs
- Performance
Profile string - (Updatable) Replicat performance.
- Performance
Profile string - (Updatable) Replicat performance.
- performance
Profile String - (Updatable) Replicat performance.
- performance
Profile string - (Updatable) Replicat performance.
- performance_
profile str - (Updatable) Replicat performance.
- performance
Profile String - (Updatable) Replicat performance.
MigrationHubDetails, MigrationHubDetailsArgs
- Key
Id string - (Updatable) The OCID of the resource being referenced.
- Rest
Admin MigrationCredentials Hub Details Rest Admin Credentials - (Updatable) Database Administrator Credentials details.
- Url string
- (Updatable) Endpoint URL.
- Vault
Id string - (Updatable) The OCID of the resource being referenced.
- Acceptable
Lag int - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Compute
Id string - (Updatable) The OCID of the resource being referenced.
- Extract
Migration
Hub Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- Replicat
Migration
Hub Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- Key
Id string - (Updatable) The OCID of the resource being referenced.
- Rest
Admin MigrationCredentials Hub Details Rest Admin Credentials - (Updatable) Database Administrator Credentials details.
- Url string
- (Updatable) Endpoint URL.
- Vault
Id string - (Updatable) The OCID of the resource being referenced.
- Acceptable
Lag int - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Compute
Id string - (Updatable) The OCID of the resource being referenced.
- Extract
Migration
Hub Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- Replicat
Migration
Hub Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- key
Id String - (Updatable) The OCID of the resource being referenced.
- rest
Admin MigrationCredentials Hub Details Rest Admin Credentials - (Updatable) Database Administrator Credentials details.
- url String
- (Updatable) Endpoint URL.
- vault
Id String - (Updatable) The OCID of the resource being referenced.
- acceptable
Lag Integer - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute
Id String - (Updatable) The OCID of the resource being referenced.
- extract
Migration
Hub Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- replicat
Migration
Hub Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- key
Id string - (Updatable) The OCID of the resource being referenced.
- rest
Admin MigrationCredentials Hub Details Rest Admin Credentials - (Updatable) Database Administrator Credentials details.
- url string
- (Updatable) Endpoint URL.
- vault
Id string - (Updatable) The OCID of the resource being referenced.
- acceptable
Lag number - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute
Id string - (Updatable) The OCID of the resource being referenced.
- extract
Migration
Hub Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- replicat
Migration
Hub Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- key_
id str - (Updatable) The OCID of the resource being referenced.
- rest_
admin_ databasemigration.credentials Migration Hub Details Rest Admin Credentials - (Updatable) Database Administrator Credentials details.
- url str
- (Updatable) Endpoint URL.
- vault_
id str - (Updatable) The OCID of the resource being referenced.
- acceptable_
lag int - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute_
id str - (Updatable) The OCID of the resource being referenced.
- extract
databasemigration.
Migration Hub Details Extract - (Updatable) Parameters for GoldenGate Extract processes.
- replicat
databasemigration.
Migration Hub Details Replicat - (Updatable) Parameters for GoldenGate Replicat processes.
- key
Id String - (Updatable) The OCID of the resource being referenced.
- rest
Admin Property MapCredentials - (Updatable) Database Administrator Credentials details.
- url String
- (Updatable) Endpoint URL.
- vault
Id String - (Updatable) The OCID of the resource being referenced.
- acceptable
Lag Number - (Updatable) ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute
Id String - (Updatable) The OCID of the resource being referenced.
- extract Property Map
- (Updatable) Parameters for GoldenGate Extract processes.
- replicat Property Map
- (Updatable) Parameters for GoldenGate Replicat processes.
MigrationHubDetailsExtract, MigrationHubDetailsExtractArgs
- Long
Trans intDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - (Updatable) Extract performance.
- Long
Trans intDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - (Updatable) Extract performance.
- long
Trans IntegerDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - (Updatable) Extract performance.
- long
Trans numberDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile string - (Updatable) Extract performance.
- long_
trans_ intduration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance_
profile str - (Updatable) Extract performance.
- long
Trans NumberDuration - (Updatable) Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - (Updatable) Extract performance.
MigrationHubDetailsReplicat, MigrationHubDetailsReplicatArgs
- Performance
Profile string - (Updatable) Replicat performance.
- Performance
Profile string - (Updatable) Replicat performance.
- performance
Profile String - (Updatable) Replicat performance.
- performance
Profile string - (Updatable) Replicat performance.
- performance_
profile str - (Updatable) Replicat performance.
- performance
Profile String - (Updatable) Replicat performance.
MigrationHubDetailsRestAdminCredentials, MigrationHubDetailsRestAdminCredentialsArgs
MigrationIncludeObject, MigrationIncludeObjectArgs
- Object string
- Name of the object (regular expression is allowed)
- Is
Omit boolExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- Owner string
- Owner of the object (regular expression is allowed)
- Schema string
- Schema of the object (regular expression is allowed)
- Type string
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- Object string
- Name of the object (regular expression is allowed)
- Is
Omit boolExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- Owner string
- Owner of the object (regular expression is allowed)
- Schema string
- Schema of the object (regular expression is allowed)
- Type string
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object String
- Name of the object (regular expression is allowed)
- is
Omit BooleanExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner String
- Owner of the object (regular expression is allowed)
- schema String
- Schema of the object (regular expression is allowed)
- type String
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object string
- Name of the object (regular expression is allowed)
- is
Omit booleanExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner string
- Owner of the object (regular expression is allowed)
- schema string
- Schema of the object (regular expression is allowed)
- type string
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object str
- Name of the object (regular expression is allowed)
- is_
omit_ boolexcluded_ table_ from_ replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner str
- Owner of the object (regular expression is allowed)
- schema str
- Schema of the object (regular expression is allowed)
- type str
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
- object String
- Name of the object (regular expression is allowed)
- is
Omit BooleanExcluded Table From Replication - Whether an excluded table should be omitted from replication. Only valid for database objects that have are of type TABLE and object status EXCLUDE.
- owner String
- Owner of the object (regular expression is allowed)
- schema String
- Schema of the object (regular expression is allowed)
- type String
- Type of object to exclude. If not specified, matching owners and object names of type TABLE would be excluded.
MigrationInitialLoadSettings, MigrationInitialLoadSettingsArgs
- Job
Mode string - (Updatable) Oracle Job Mode
- Compatibilities List<string>
- (Updatable) Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- Data
Pump MigrationParameters Initial Load Settings Data Pump Parameters - (Updatable) Optional parameters for Data Pump Export and Import.
- Export
Directory MigrationObject Initial Load Settings Export Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- Handle
Grant stringErrors - (Updatable) The action taken in the event of errors related to GRANT or REVOKE errors.
- Import
Directory MigrationObject Initial Load Settings Import Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- Is
Consistent bool - (Updatable) Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- Is
Ignore boolExisting Objects - (Updatable) Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- Is
Tz boolUtc - (Updatable) Include a statement at the start of the dump to set the time zone to UTC.
- Metadata
Remaps List<MigrationInitial Load Settings Metadata Remap> - (Updatable) Defines remapping to be applied to objects as they are processed.
- Primary
Key stringCompatibility - (Updatable) Primary key compatibility option
- Tablespace
Details MigrationInitial Load Settings Tablespace Details - (Updatable) Migration tablespace settings.
- Job
Mode string - (Updatable) Oracle Job Mode
- Compatibilities []string
- (Updatable) Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- Data
Pump MigrationParameters Initial Load Settings Data Pump Parameters - (Updatable) Optional parameters for Data Pump Export and Import.
- Export
Directory MigrationObject Initial Load Settings Export Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- Handle
Grant stringErrors - (Updatable) The action taken in the event of errors related to GRANT or REVOKE errors.
- Import
Directory MigrationObject Initial Load Settings Import Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- Is
Consistent bool - (Updatable) Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- Is
Ignore boolExisting Objects - (Updatable) Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- Is
Tz boolUtc - (Updatable) Include a statement at the start of the dump to set the time zone to UTC.
- Metadata
Remaps []MigrationInitial Load Settings Metadata Remap - (Updatable) Defines remapping to be applied to objects as they are processed.
- Primary
Key stringCompatibility - (Updatable) Primary key compatibility option
- Tablespace
Details MigrationInitial Load Settings Tablespace Details - (Updatable) Migration tablespace settings.
- job
Mode String - (Updatable) Oracle Job Mode
- compatibilities List<String>
- (Updatable) Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data
Pump MigrationParameters Initial Load Settings Data Pump Parameters - (Updatable) Optional parameters for Data Pump Export and Import.
- export
Directory MigrationObject Initial Load Settings Export Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- handle
Grant StringErrors - (Updatable) The action taken in the event of errors related to GRANT or REVOKE errors.
- import
Directory MigrationObject Initial Load Settings Import Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- is
Consistent Boolean - (Updatable) Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is
Ignore BooleanExisting Objects - (Updatable) Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is
Tz BooleanUtc - (Updatable) Include a statement at the start of the dump to set the time zone to UTC.
- metadata
Remaps List<MigrationInitial Load Settings Metadata Remap> - (Updatable) Defines remapping to be applied to objects as they are processed.
- primary
Key StringCompatibility - (Updatable) Primary key compatibility option
- tablespace
Details MigrationInitial Load Settings Tablespace Details - (Updatable) Migration tablespace settings.
- job
Mode string - (Updatable) Oracle Job Mode
- compatibilities string[]
- (Updatable) Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data
Pump MigrationParameters Initial Load Settings Data Pump Parameters - (Updatable) Optional parameters for Data Pump Export and Import.
- export
Directory MigrationObject Initial Load Settings Export Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- handle
Grant stringErrors - (Updatable) The action taken in the event of errors related to GRANT or REVOKE errors.
- import
Directory MigrationObject Initial Load Settings Import Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- is
Consistent boolean - (Updatable) Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is
Ignore booleanExisting Objects - (Updatable) Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is
Tz booleanUtc - (Updatable) Include a statement at the start of the dump to set the time zone to UTC.
- metadata
Remaps MigrationInitial Load Settings Metadata Remap[] - (Updatable) Defines remapping to be applied to objects as they are processed.
- primary
Key stringCompatibility - (Updatable) Primary key compatibility option
- tablespace
Details MigrationInitial Load Settings Tablespace Details - (Updatable) Migration tablespace settings.
- job_
mode str - (Updatable) Oracle Job Mode
- compatibilities Sequence[str]
- (Updatable) Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data_
pump_ databasemigration.parameters Migration Initial Load Settings Data Pump Parameters - (Updatable) Optional parameters for Data Pump Export and Import.
- export_
directory_ databasemigration.object Migration Initial Load Settings Export Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- handle_
grant_ strerrors - (Updatable) The action taken in the event of errors related to GRANT or REVOKE errors.
- import_
directory_ databasemigration.object Migration Initial Load Settings Import Directory Object - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- is_
consistent bool - (Updatable) Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is_
ignore_ boolexisting_ objects - (Updatable) Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is_
tz_ boolutc - (Updatable) Include a statement at the start of the dump to set the time zone to UTC.
- metadata_
remaps Sequence[databasemigration.Migration Initial Load Settings Metadata Remap] - (Updatable) Defines remapping to be applied to objects as they are processed.
- primary_
key_ strcompatibility - (Updatable) Primary key compatibility option
- tablespace_
details databasemigration.Migration Initial Load Settings Tablespace Details - (Updatable) Migration tablespace settings.
- job
Mode String - (Updatable) Oracle Job Mode
- compatibilities List<String>
- (Updatable) Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data
Pump Property MapParameters - (Updatable) Optional parameters for Data Pump Export and Import.
- export
Directory Property MapObject - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- handle
Grant StringErrors - (Updatable) The action taken in the event of errors related to GRANT or REVOKE errors.
- import
Directory Property MapObject - (Updatable) Directory object details, used to define either import or export directory objects in Data Pump Settings. Import directory is required for Non-Autonomous target connections. If specified for an autonomous target, it will show an error. Export directory will error if there are database link details specified.
- is
Consistent Boolean - (Updatable) Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is
Ignore BooleanExisting Objects - (Updatable) Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is
Tz BooleanUtc - (Updatable) Include a statement at the start of the dump to set the time zone to UTC.
- metadata
Remaps List<Property Map> - (Updatable) Defines remapping to be applied to objects as they are processed.
- primary
Key StringCompatibility - (Updatable) Primary key compatibility option
- tablespace
Details Property Map - (Updatable) Migration tablespace settings.
MigrationInitialLoadSettingsDataPumpParameters, MigrationInitialLoadSettingsDataPumpParametersArgs
- Estimate string
- (Updatable) Estimate size of dumps that will be generated.
- Exclude
Parameters List<string> - (Updatable) Exclude paratemers for Export and Import.
- Export
Parallelism intDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Export job.
- Import
Parallelism intDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- Is
Cluster bool - (Updatable) Set to false to force Data Pump worker process to run on one instance.
- Table
Exists stringAction - (Updatable) IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- Estimate string
- (Updatable) Estimate size of dumps that will be generated.
- Exclude
Parameters []string - (Updatable) Exclude paratemers for Export and Import.
- Export
Parallelism intDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Export job.
- Import
Parallelism intDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- Is
Cluster bool - (Updatable) Set to false to force Data Pump worker process to run on one instance.
- Table
Exists stringAction - (Updatable) IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate String
- (Updatable) Estimate size of dumps that will be generated.
- exclude
Parameters List<String> - (Updatable) Exclude paratemers for Export and Import.
- export
Parallelism IntegerDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Export job.
- import
Parallelism IntegerDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is
Cluster Boolean - (Updatable) Set to false to force Data Pump worker process to run on one instance.
- table
Exists StringAction - (Updatable) IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate string
- (Updatable) Estimate size of dumps that will be generated.
- exclude
Parameters string[] - (Updatable) Exclude paratemers for Export and Import.
- export
Parallelism numberDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Export job.
- import
Parallelism numberDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is
Cluster boolean - (Updatable) Set to false to force Data Pump worker process to run on one instance.
- table
Exists stringAction - (Updatable) IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate str
- (Updatable) Estimate size of dumps that will be generated.
- exclude_
parameters Sequence[str] - (Updatable) Exclude paratemers for Export and Import.
- export_
parallelism_ intdegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Export job.
- import_
parallelism_ intdegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is_
cluster bool - (Updatable) Set to false to force Data Pump worker process to run on one instance.
- table_
exists_ straction - (Updatable) IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate String
- (Updatable) Estimate size of dumps that will be generated.
- exclude
Parameters List<String> - (Updatable) Exclude paratemers for Export and Import.
- export
Parallelism NumberDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Export job.
- import
Parallelism NumberDegree - (Updatable) Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is
Cluster Boolean - (Updatable) Set to false to force Data Pump worker process to run on one instance.
- table
Exists StringAction - (Updatable) IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
MigrationInitialLoadSettingsExportDirectoryObject, MigrationInitialLoadSettingsExportDirectoryObjectArgs
MigrationInitialLoadSettingsImportDirectoryObject, MigrationInitialLoadSettingsImportDirectoryObjectArgs
MigrationInitialLoadSettingsMetadataRemap, MigrationInitialLoadSettingsMetadataRemapArgs
- New
Value string - (Updatable) Specifies the new value that oldValue should be translated into.
- Old
Value string - (Updatable) Specifies the value which needs to be reset.
- Type string
- (Updatable) Type of remap. Refer to METADATA_REMAP Procedure
- New
Value string - (Updatable) Specifies the new value that oldValue should be translated into.
- Old
Value string - (Updatable) Specifies the value which needs to be reset.
- Type string
- (Updatable) Type of remap. Refer to METADATA_REMAP Procedure
- new
Value String - (Updatable) Specifies the new value that oldValue should be translated into.
- old
Value String - (Updatable) Specifies the value which needs to be reset.
- type String
- (Updatable) Type of remap. Refer to METADATA_REMAP Procedure
- new
Value string - (Updatable) Specifies the new value that oldValue should be translated into.
- old
Value string - (Updatable) Specifies the value which needs to be reset.
- type string
- (Updatable) Type of remap. Refer to METADATA_REMAP Procedure
- new_
value str - (Updatable) Specifies the new value that oldValue should be translated into.
- old_
value str - (Updatable) Specifies the value which needs to be reset.
- type str
- (Updatable) Type of remap. Refer to METADATA_REMAP Procedure
- new
Value String - (Updatable) Specifies the new value that oldValue should be translated into.
- old
Value String - (Updatable) Specifies the value which needs to be reset.
- type String
- (Updatable) Type of remap. Refer to METADATA_REMAP Procedure
MigrationInitialLoadSettingsTablespaceDetails, MigrationInitialLoadSettingsTablespaceDetailsArgs
- Target
Type string - (Updatable) Type of Database Base Migration Target.
- Block
Size stringIn Kbs - (Updatable) Size of Oracle database blocks in KB.
- Extend
Size intIn Mbs - (Updatable) Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- Is
Auto boolCreate - (Updatable) Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- Is
Big boolFile - (Updatable) Set this property to true to enable tablespace of the type big file.
- Remap
Target string - (Updatable) Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- Target
Type string - (Updatable) Type of Database Base Migration Target.
- Block
Size stringIn Kbs - (Updatable) Size of Oracle database blocks in KB.
- Extend
Size intIn Mbs - (Updatable) Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- Is
Auto boolCreate - (Updatable) Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- Is
Big boolFile - (Updatable) Set this property to true to enable tablespace of the type big file.
- Remap
Target string - (Updatable) Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target
Type String - (Updatable) Type of Database Base Migration Target.
- block
Size StringIn Kbs - (Updatable) Size of Oracle database blocks in KB.
- extend
Size IntegerIn Mbs - (Updatable) Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is
Auto BooleanCreate - (Updatable) Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is
Big BooleanFile - (Updatable) Set this property to true to enable tablespace of the type big file.
- remap
Target String - (Updatable) Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target
Type string - (Updatable) Type of Database Base Migration Target.
- block
Size stringIn Kbs - (Updatable) Size of Oracle database blocks in KB.
- extend
Size numberIn Mbs - (Updatable) Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is
Auto booleanCreate - (Updatable) Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is
Big booleanFile - (Updatable) Set this property to true to enable tablespace of the type big file.
- remap
Target string - (Updatable) Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target_
type str - (Updatable) Type of Database Base Migration Target.
- block_
size_ strin_ kbs - (Updatable) Size of Oracle database blocks in KB.
- extend_
size_ intin_ mbs - (Updatable) Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is_
auto_ boolcreate - (Updatable) Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is_
big_ boolfile - (Updatable) Set this property to true to enable tablespace of the type big file.
- remap_
target str - (Updatable) Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target
Type String - (Updatable) Type of Database Base Migration Target.
- block
Size StringIn Kbs - (Updatable) Size of Oracle database blocks in KB.
- extend
Size NumberIn Mbs - (Updatable) Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is
Auto BooleanCreate - (Updatable) Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is
Big BooleanFile - (Updatable) Set this property to true to enable tablespace of the type big file.
- remap
Target String - (Updatable) Name of the tablespace on the target database to which the source database tablespace is to be remapped.
Import
Migrations can be imported using the id, e.g.
$ pulumi import oci:DatabaseMigration/migration:Migration test_migration "id"
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
ociTerraform Provider.