Skip to main content

replication_configs

Creates, updates, deletes, gets or lists a replication_configs resource.

Overview

Namereplication_configs
TypeResource
Idaws.dms.replication_configs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
markerstringAn optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.
replication_configsarrayReturned configuration parameters that describe each provisioned DMS Serverless replication.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_replication_configsselectregionReturns one or more existing DMS Serverless replication configurations as a list of structures.
create_replication_configinsertregion, ReplicationConfigIdentifier, SourceEndpointArn, TargetEndpointArn, ComputeConfig, ReplicationType, TableMappingsCreates a configuration that you can later provide to configure and start an DMS Serverless replication. You can also provide options to validate the configuration inputs before you start the replication.
modify_replication_configupdateregion, ReplicationConfigArnModifies an existing DMS Serverless replication configuration that you can use to start a replication. This command includes input validation and logic to check the state of any replication that uses this configuration. You can only modify a replication configuration before any replication that uses it has started. As soon as you have initially started a replication with a given configuiration, you can't modify that configuration, even if you stop it. Other run statuses that allow you to run this command include FAILED and CREATED. A provisioning state that allows you to run this command is FAILED_PROVISION.
delete_replication_configdeleteregionDeletes an DMS Serverless replication configuration. This effectively deprovisions any and all replications that use this configuration. You can't delete the configuration for an DMS Serverless replication that is ongoing. You can delete the configuration when the replication is in a non-RUNNING and non-STARTING state.
reload_replication_tablesexecregion, ReplicationConfigArn, TablesToReloadReloads the target database table with the source data for a given DMS Serverless replication configuration. You can only use this operation with a task in the RUNNING state, otherwise the service will throw an InvalidResourceStateFault exception.
start_replicationexecregion, ReplicationConfigArn, StartReplicationTypeFor a given DMS Serverless replication configuration, DMS connects to the source endpoint and collects the metadata to analyze the replication workload. Using this metadata, DMS then computes and provisions the required capacity and starts replicating to the target endpoint using the server resources that DMS has provisioned for the DMS Serverless replication.
stop_replicationexecregion, ReplicationConfigArnFor a given DMS Serverless replication configuration, DMS stops any and all ongoing DMS Serverless replications. This command doesn't deprovision the stopped replications.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

SELECT examples

Returns one or more existing DMS Serverless replication configurations as a list of structures.

SELECT
marker,
replication_configs
FROM aws.dms.replication_configs
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a configuration that you can later provide to configure and start an DMS Serverless replication. You can also provide options to validate the configuration inputs before you start the replication.

INSERT INTO aws.dms.replication_configs (
ReplicationConfigIdentifier,
SourceEndpointArn,
TargetEndpointArn,
ComputeConfig,
ReplicationType,
TableMappings,
ReplicationSettings,
SupplementalSettings,
ResourceIdentifier,
Tags,
region
)
SELECT
'{{ ReplicationConfigIdentifier }}' /* required */,
'{{ SourceEndpointArn }}' /* required */,
'{{ TargetEndpointArn }}' /* required */,
'{{ ComputeConfig }}' /* required */,
'{{ ReplicationType }}' /* required */,
'{{ TableMappings }}' /* required */,
'{{ ReplicationSettings }}',
'{{ SupplementalSettings }}',
'{{ ResourceIdentifier }}',
'{{ Tags }}',
'{{ region }}'
RETURNING
replication_config
;

UPDATE examples

Modifies an existing DMS Serverless replication configuration that you can use to start a replication. This command includes input validation and logic to check the state of any replication that uses this configuration. You can only modify a replication configuration before any replication that uses it has started. As soon as you have initially started a replication with a given configuiration, you can't modify that configuration, even if you stop it. Other run statuses that allow you to run this command include FAILED and CREATED. A provisioning state that allows you to run this command is FAILED_PROVISION.

UPDATE aws.dms.replication_configs
SET
ReplicationConfigArn = '{{ ReplicationConfigArn }}',
ReplicationConfigIdentifier = '{{ ReplicationConfigIdentifier }}',
ReplicationType = '{{ ReplicationType }}',
TableMappings = '{{ TableMappings }}',
ReplicationSettings = '{{ ReplicationSettings }}',
SupplementalSettings = '{{ SupplementalSettings }}',
ComputeConfig = '{{ ComputeConfig }}',
SourceEndpointArn = '{{ SourceEndpointArn }}',
TargetEndpointArn = '{{ TargetEndpointArn }}'
WHERE
region = '{{ region }}' --required
AND ReplicationConfigArn = '{{ ReplicationConfigArn }}' --required
RETURNING
replication_config;

DELETE examples

Deletes an DMS Serverless replication configuration. This effectively deprovisions any and all replications that use this configuration. You can't delete the configuration for an DMS Serverless replication that is ongoing. You can delete the configuration when the replication is in a non-RUNNING and non-STARTING state.

DELETE FROM aws.dms.replication_configs
WHERE region = '{{ region }}' --required
;

Lifecycle Methods

Reloads the target database table with the source data for a given DMS Serverless replication configuration. You can only use this operation with a task in the RUNNING state, otherwise the service will throw an InvalidResourceStateFault exception.

EXEC aws.dms.replication_configs.reload_replication_tables
@region='{{ region }}' --required
@@json=
'{
"ReplicationConfigArn": "{{ ReplicationConfigArn }}",
"TablesToReload": "{{ TablesToReload }}",
"ReloadOption": "{{ ReloadOption }}"
}'
;