aws dms get-target-selection-rules

Converts source selection rules into their target counterparts for schema conversion operations. AWS CLI reference

1 example 2 options Its page in the AWS CLI reference

Examples

from aws-cli, each command read by CmdID

To convert source selection rules to target selection rules

The following get-target-selection-rules example converts source selection rules that select the ExampleTable table in the ExampleSchema schema into target selection rules that reference its converted counterpart.

aws dms get-target-selection-rules --migration-project-identifier arn:aws:dms:us-west-2:123456789012:migration-project:EXAMPLEABCDEFGHIJKLMNOPQRS --selection-rules '{"rules": [{"rule-type": "selection", "rule-id": "1", "rule-name": "1", "object-locator": {"server-name": "example-source-server.us-west-2.rds.amazonaws.com", "database-name": "ExampleDatabase", "schema-name": "ExampleSchema", "table-name": "ExampleTable"}, "rule-action": "explicit"}]}'

Identify

--migration-project-identifierThe migration project name or Amazon Resource Name (ARN).

--selection-rulesA JSON string that contains the source selection rules to convert into their target counterparts.

Its output

{
    "TargetSelectionRules": "{\"rules\": [{\"rule-type\": \"selection\", \"rule-id\": \"1\", \"rule-name\": \"1\", \"object-locator\": {\"server-name\": \"example-target-server.us-west-2.rds.amazonaws.com\", \"schema-name\": \"exampledatabase_exampleschema\", \"table-name\": \"exampletable\"}, \"rule-action\": \"explicit\"}]}"
}

For more information, see Using selection rules in the AWS Database Migration Service User Guide.

Options

2 in the AWS CLI reference

--migration-project-identifierThe migration project name or Amazon Resource Name (ARN).

--selection-rulesA JSON string that contains the source selection rules to convert into their target counterparts.