5_Migrating Data into AWS Databases

AWS Database Migration Service (DMS)

Overview

• AWS DMS is a managed migration and replication service.
• It helps move existing databases and analytics workloads to and within AWS.
• It operates as a web service, migrating data from a source data store to a target data store.
• The source and target data stores are called endpoints.

Homogeneous vs. Heterogeneous Migrations

• Homogeneous Migration:
  • Migration between equivalent database engines.
  • Serverless; AWS DMS automatically scales required resources.
• Heterogeneous Migration:
  • Migration between source and target endpoints that use different database engines.

Tools for Streamlining Heterogeneous Migration

• AWS DMS Fleet Advisor:
  • Automatically inventories and assesses on-premises database and server fleets.
  • Provides potential migration paths and suggestions.
• Schema Conversion Solutions:
  • AWS Schema Conversion Tool (SCT)
  • AWS DMS Schema Conversion
  • Both tools automatically assess and convert the source database schema and most database code objects to a format compatible with the target database.
  • Used to make database migrations predictable, fast, and secure.

AWS Schema Conversion Tool (SCT)

• A standalone application that must be downloaded to your local drive.
• Works in conjunction with AWS DMS.

Use Case Example: Higher Education Data Lake Ingestion

• Data exists in an on-premises database and needs to be ingested into a data lake for analytics.
• AWS DMS destination endpoint connects the replication task to the Amazon S3 raw data bucket.

Integration with AWS Services

• AWS DMS integrates natively with many AWS services.

Strategic Importance

• AWS DMS is a strategically important migration tool for AWS environments.