AWS Database Migration Service

  • It help you migrate databases to AWS easily and securely.
  • Source database remains fully operational during the migration.
  • It can migrate data to and from most widely used commercial and open-source databases.
  • It supports homogenous migrations such as Oracle to Oracle, or heterogeneous migrations like, Oracle to Amazon Aurora.
  • Allows you to stream data to Amazon Redshift, Amazon DynamoDB, and Amazon S3 from any of the supported sources
  • Supported sources
    • Amazon Aurora
    • PostgreSQL
    • MySQL
    • MariaDB
    • Oracle
    • SAP ASE
    • SQL Server
    • MongoDB
  • Can also be used for continuous data replication with high-availability.

AWS Schema Conversion Tool

  • It makes heterogeneous database migrations to a format compatible with the target database , predictable by automatically converting
    • the source database schema
    • the database code objects
    • views
    • stored procedures
    •  functions
  • Objects that cannot be automatically converted are clearly marked
  • It can also scan application source code for embedded SQL statements and convert them.
  • Source database can be on-premises, or in AWS
  • Supports conversions from multiple RBMS providers to an equivalent database in RDS, or from multiple data warehouse providers to Amazon Redshift.
Menu