Menu
AWS Database Migration Service
User Guide (Version API Version 2016-01-01)

Upgrading the Engine Version of a Replication Instance

AWS periodically releases new versions of the AWS DMS replication engine software, with new features and performance improvements. The following is a summary of available AWS DMS engine versions:

AWS DMS Replication Engine Versions

Version Summary
2.2.x
  • Support for Microsoft SQL Server 2016, as either an AWS DMS source or an AWS DMS target.

  • Support for SAP ASE 16, as either an AWS DMS source or an AWS DMS target.

  • Support for Microsoft SQL Server running on Microsoft Azure, as an AWS DMS source only. You can peform a full migration of existing data; however, change data capture (CDC) is not available.

1.9.x Cumulative release of AWS DMS replication engine software.

Upgrading the Engine Version Using the AWS Management Console

To upgrade an AWS DMS replication instance using the AWS Management Console, do the following:

  1. Open the AWS DMS console at https://console.aws.amazon.com/dms/.

  2. In the navigation pane, choose Replication instances.

  3. Choose your replication engine, and then choose Modify.

  4. In the Replication engine version field, choose the version number you want, and then choose Modify.

Note

Upgrading the replication instance will take several minutes. When the instance is ready, its status changes to available.

Upgrading the Engine Version Using the AWS CLI

To upgrade an AWS DMS replication instance using the AWS CLI, do the following:

  1. Determine the ARN (Amazon Resource Name) of your replication instance:

    Copy
    aws dms describe-replication-instances \ --query "ReplicationInstances[*].[ReplicationInstanceIdentifier,ReplicationInstanceArn,ReplicationInstanceClass]"

    In the output, take note of the Amazon Resource Name (ARN) for the replication instance you want to upgrade. For example: arn:aws:dms:us-east-1:123456789012:rep:6EFQQO6U6EDPRCPKLNPL2SCEEY

  2. Determine which replication instance versions are available:

    Copy
    aws dms describe-orderable-replication-instances \ --query "OrderableReplicationInstances[*].[ReplicationInstanceClass,EngineVersion]"

    In the output, take note of the engine version number(s) that are available for your replication instance class. (You should see this information in the output from Step 1.)

  3. Upgrade the replication instance:

    Copy
    aws dms modify-replication-instance \ --replication-instance-arn arn \ --engine-version n.n.n

    Replace arn with the actual replication instance ARN from the previous step.

    Replace n.n.n with the engine version number that you want. For example: 2.2.1

Note

Upgrading the replication instance will take several minutes. You can view the replication instance status using this command:

Copy
aws dms describe-replication-instances \ --query "ReplicationInstances[*].[ReplicationInstanceIdentifier,ReplicationInstanceStatus]"

When the replication instance is ready, its status changes to available.