AWS DMS - AWS Prescriptive Guidance
ArchitectureLimitations

AWS DMS

AWS Database Migration Service (AWS DMS) is a managed service that helps you move data to the AWS Cloud easily and securely. If your database is relatively small and your application can tolerate a moderate level of downtime, then AWS DMS is a migration option worth considering. You can use AWS DMS even if you have minimal downtime requirements. This is because AWS DMS offers full load and continuous replication support.

AWS DMS offers the following advantages:

  • Supports both homogeneous and heterogeneous migrations

  • Uses change data capture to keep the source and target databases in sync and to minimize downtime during a migration

Architecture

The following diagram shows the architecture for migrating an on-premises PostgreSQL database to the AWS Cloud by using AWS DMS.

AWS DMS architecture

The diagram shows the following workflow:

  1. Create a PostgreSQL database instance in Amazon EC2.

  2. Create a replication instance in AWS DMS.

  3. Create source and target endpoints for a replication task in AWS DMS.

  4. Create a replication task that's responsible for migrating data from a source database to a target database.

  5. Complete the migration and clean up the resources.

For more information on how to use AWS DMS, see Working with self-managed PostgreSQL databases as a source in AWS DMS in the AWS DMS documentation.

Limitations

For more information on AWS DMS limitations, see Limitations on using a PostgreSQL database as a DMS source in the AWS DMS documentation.