Note: You are viewing the documentation for an older major version of the AWS CLI (version 1).

AWS CLI version 2, the latest major version of AWS CLI, is now stable and recommended for general use. To view this page for the AWS CLI version 2, click here. For more information see the AWS CLI version 2 installation instructions and migration guide.

[ aws . dms ]



Reloads the target database table with the source data.

You can only use this operation with a task in the RUNNING state, otherwise the service will throw an InvalidResourceStateFault exception.

See also: AWS API Documentation

See 'aws help' for descriptions of global parameters.


--replication-task-arn <value>
--tables-to-reload <value>
[--reload-option <value>]
[--cli-input-json <value>]
[--generate-cli-skeleton <value>]


--replication-task-arn (string)

The Amazon Resource Name (ARN) of the replication task.

--tables-to-reload (list)

The name and schema of the table to be reloaded.


Provides the name of the schema and table to be reloaded.

SchemaName -> (string)

The schema name of the table to be reloaded.

TableName -> (string)

The table name of the table to be reloaded.

Shorthand Syntax:

SchemaName=string,TableName=string ...

JSON Syntax:

    "SchemaName": "string",
    "TableName": "string"

--reload-option (string)

Options for reload. Specify data-reload to reload the data and re-validate it if validation is enabled. Specify validate-only to re-validate the table. This option applies only when validation is enabled for the task.

Valid values: data-reload, validate-only

Default value is data-reload.

Possible values:

  • data-reload
  • validate-only

--cli-input-json (string) Performs service operation based on the JSON string provided. The JSON string follows the format provided by --generate-cli-skeleton. If other arguments are provided on the command line, the CLI values will override the JSON-provided values. It is not possible to pass arbitrary binary values using a JSON-provided value as the string will be taken literally.

--generate-cli-skeleton (string) Prints a JSON skeleton to standard output without sending an API request. If provided with no value or the value input, prints a sample input JSON that can be used as an argument for --cli-input-json. If provided with the value output, it validates the command inputs and returns a sample output JSON for that command.

See 'aws help' for descriptions of global parameters.


To refresh the list of tables available at an endpoint

The following reload-tables example reloads the list of available tables at an endpoint.

aws dms reload-tables \
    --replication-task-arn "arn:aws:dms:us-east-1:123456789012:task:K55IUCGBASJS5VHZJIINA45FII" \
    --tables-to-reload "SchemaName=prodrep,TableName=ACCT_BAL"


    "ReplicationTaskArn": "arn:aws:dms:us-east-1:123456789012:task:K55IUCGBASJS5VHZJIINA45FII"


ReplicationTaskArn -> (string)

The Amazon Resource Name (ARN) of the replication task.