15. Migration & Transfer

Explore

AWS Migration Tools

Database Migration Service

AWS Database Migration Service (AWS DMS) is a cloud service that makes it possible to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud or between combinations of cloud and on-premises setups.

With AWS DMS, you can discover your source data stores, convert your source schemas, and migrate your data.

To discover your source data infrastructure, you can use DMS Fleet Advisor. This service collects data from your on-premises database and analytic servers, and builds an inventory of servers, databases, and schemas that you can migrate to the AWS Cloud.

To migrate to a different database engine, you can use DMS Schema Conversion. This service automatically assesses and converts your source schemas to a new target engine. Alternatively, you can download the AWS Schema Conversion Tool (AWS SCT) to your local PC to convert your source schemas.

After you convert your source schemas and apply the converted code to your target database, you can use AWS DMS to migrate your data. You can perform one-time migrations or replicate ongoing changes to keep sources and targets in sync. Because AWS DMS is a part of the AWS Cloud, you get the cost efficiency, speed to market, security, and flexibility that AWS services offer.

At a basic level, AWS DMS is a server in the AWS Cloud that runs replication software. You create a source and target connection to tell AWS DMS where to extract data from and where to load it. Next, you schedule a task that runs on this server to move your data. AWS DMS creates the tables and associated primary keys if they don't exist on the target. You can create the target tables yourself if you prefer. Or you can use AWS Schema Conversion Tool (AWS SCT) to create some or all of the target tables, indexes, views, triggers, and so on.

⁠

AWS DMS replication process

AWS DMS replication process

⁠

Here's an overview of its key features and capabilities:

Minimized Downtime:

Ensures that the source database remains fully operational during the migration process.

Minimizes downtime to applications that depend on the database, maintaining business continuity.

Wide Compatibility:

Supports migration to and from most widely used commercial and open-source databases.

Offers flexibility for migrations between various database platforms, including on-premises, EC2, and cloud-based databases.

Migration Paths:

Supports various migration paths, including:

Migration from on-premises and EC2 databases to Amazon RDS or Amazon Aurora.

Homogeneous migrations, such as Oracle to Oracle.

Heterogeneous migrations between different database platforms, like Oracle or Microsoft SQL Server to Amazon Aurora.

Continuous Data Replication:

Enables continuous replication of data with high availability.

Facilitates the consolidation of databases into petabyte-scale data warehouses by streaming data to Amazon Redshift and Amazon S3.

Schema Conversion Tool (SCT):

Works in conjunction with DMS for migrating databases to AWS RDS or EC2-based databases.

Copies database schemas for homogeneous migrations and converts schemas for heterogeneous migrations.

Usage Scenarios:

Ideal for smaller, simpler conversions and supports databases like MongoDB and DynamoDB.

Suitable for larger, more complex datasets such as data warehouses, where SCT provides efficient migration solutions.

Replication Functions:

Offers replication functions for various scenarios, including:

On-premises to AWS migrations.

Replication to Snowball or S3 for offline data transfer.

Use Cases

Cloud to Cloud – EC2 to RDS, RDS to RDS, RDS to Aurora

On-Premises to Cloud

Homogeneous migrations – Oracle to Oracle, MySQL to RDS MySQL, Microsoft SQL to RDS for SQL Server

Heterogeneous migrations – Oracle to Aurora, Oracle to PostgreSQL, Microsoft SQL to RDS MySQL (must convert schema first with the Shema Conversion Tool (SCT))

Development and Test – use the cloud for dev/test workloads

Database consolidation – consolidate multiple source DBs to a single target DB

Continuous Data Replication – use for DR, dev/test, single source multi-target or multi-source single target

AWS Database Migration Service simplifies and accelerates the migration process, ensuring seamless data transfer while minimizing disruption to business operations. With its wide compatibility and advanced features, DMS is a valuable tool for organizations transitioning their databases to AWS infrastructure.

Source for Migration

For the full list of supported sources click

here⁠

Topics

⁠

Using an Oracle database as a source for AWS DMS⁠

⁠

Using a Microsoft SQL Server database as a source for AWS DMS⁠

⁠

Using Microsoft Azure SQL database as a source for AWS DMS⁠

⁠

Using Microsoft Azure SQL Managed Instance as a source for AWS DMS⁠

⁠

Using Microsoft Azure Database for PostgreSQL flexible server as a source for AWS DMS⁠

⁠

Using Microsoft Azure Database for MySQL flexible server as a source for AWS DMS⁠

⁠

Using OCI MySQL Heatwave as a source for AWS DMS⁠

⁠

Using Google Cloud for MySQL as a source for AWS DMS⁠

⁠

Using Google Cloud for PostgreSQL as a source for AWS DMS⁠

⁠

Using a PostgreSQL database as an AWS DMS source⁠

⁠

Using a MySQL-compatible database as a source for AWS DMS⁠

⁠

Using an SAP ASE database as a source for AWS DMS⁠

⁠

Using MongoDB as a source for AWS DMS⁠

⁠

Using Amazon DocumentDB (with MongoDB compatibility) as a source for AWS DMS⁠

⁠

Using Amazon S3 as a source for AWS DMS⁠

⁠

Using IBM Db2 for Linux, Unix, Windows, and Amazon RDS database (Db2 LUW) as a source for AWS DMS⁠

⁠

Using IBM Db2 for z/OS databases as a source for AWS DMS⁠

⁠

Target for Migration

For the full list of supported targets click

here⁠

AWS DMS doesn't support migration across AWS Regions for the following target endpoint types:

Amazon DynamoDB

Amazon OpenSearch Service

Amazon Kinesis Data Streams

Topics

⁠

Using an Oracle database as a target for AWS Database Migration Service⁠

⁠

Using a Microsoft SQL Server database as a target for AWS Database Migration Service⁠

⁠

Using a PostgreSQL database as a target for AWS Database Migration Service⁠

⁠

Using a MySQL-compatible database as a target for AWS Database Migration Service⁠

⁠

Using an Amazon Redshift database as a target for AWS Database Migration Service⁠

⁠

Using a SAP ASE database as a target for AWS Database Migration Service⁠

⁠

Using Amazon S3 as a target for AWS Database Migration Service⁠

⁠

Using an Amazon DynamoDB database as a target for AWS Database Migration Service⁠

⁠

Using Amazon Kinesis Data Streams as a target for AWS Database Migration Service⁠

⁠

Using Apache Kafka as a target for AWS Database Migration Service⁠

⁠

Using an Amazon OpenSearch Service cluster as a target for AWS Database Migration Service⁠

⁠

Using Amazon DocumentDB as a target for AWS Database Migration Service⁠

⁠

Using Amazon Neptune as a target for AWS Database Migration Service⁠

⁠

Using Redis as a target for AWS Database Migration Service⁠

⁠

Using Babelfish as a target for AWS Database Migration Service⁠

⁠

Using Amazon Timestream as a target for AWS Database Migration Service⁠

⁠

Using Amazon RDS for Db2 and IBM Db2 LUW as a target for AWS DMS⁠

⁠

What is AWS Database Migration Service? - AWS Database Migration Service Migrate databases to AWS easily and securely using AWS Database Migration Service (AWS DMS) with this User Guide. docs.aws.amazon.com⁠

⁠

Use Cases

Source for Migration

Target for Migration

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.