Exporting Amazon RDS Data to Amazon S3 Using AWS DMS

Amazon Database Migration Service (DMS) is an offering from AWS that lets you migrate data between different database versions, engines, and data store types. It's fully managed and can reduce the complexity of technically challenging migration scenarios.

Learning how to use AWS DMS will help anyone looking to work with sophisticated workloads in the public AWS cloud.

In this hands-on lab, you will use Amazon VPC and AWS DMS to securely and efficiently export data from an Amazon RDS instance to Amazon S3.

Please note, this lab creates a DMS replication instance which can take up to 25 minutes to finish creation. Please ensure you have enough time available before starting the lab.

Learning objectives

Upon completion of this beginner-level lab, you will be able to:

• Create an Amazon VPC endpoint
• Restrict access to an Amazon S3 bucket to a VPC endpoint
• Create a secret in AWS Secrets Manager
• Use AWS DMS to export data

Intended audience

• Candidates for the AWS Certified DevOps Engineer Professional certification
• Cloud Architects
• Data Engineers
• DevOps Engineers

Prerequisites

Familiarity with the following will be beneficial but is not required:

• AWS Database Migration Service (DMS)
• Amazon Virtual Private Cloud (VPC)
• AWS Secrets Manager
• Amazon Simple Storage Service (S3)

The following content can be used to fulfill the prerequisites:

• Introduction to the AWS Database Migration Service
• Introduction to AWS PrivateLink
• Using AWS Secrets Manager to Manage, Rotate, and Retrieve Secrets
• Using S3 Bucket Policies and Conditions to Restrict Specific Permissions

Updates

Jul 2nd, 2025 - Updated SQL version, instructions and screenshots to reflect current UI