Database Migration Step-by-Step Walkthroughs
You can use AWS Database Migration Service (AWS DMS) to migrate your data to and from most widely used commercial and open-source databases such as Oracle, PostgreSQL, Microsoft SQL Server, Amazon Redshift, Amazon Aurora, MariaDB, and MySQL. The service supports homogeneous migrations such as Oracle to Oracle, and also heterogeneous migrations between different database platforms, such as Oracle to MySQL or MySQL to Amazon Aurora MySQL-Compatible Edition. Alternatively, you can use AWS DMS to move from existing, self-managed, open-source, and commercial databases to fully managed AWS databases of the same engine.
You can use DMS Schema Conversion to migrate to a different database engine. 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.
In this guide, you can find step-by-step walkthroughs that go through the process of schema conversion and data migration of the following source databases:
Oracle Database
-
Migrating an On-Premises Oracle Database to Amazon Aurora MySQL
-
Migrating an Amazon RDS for Oracle Database to Amazon Aurora MySQL
-
Migrating an Amazon RDS for Oracle Database to an Amazon S3 Data Lake
-
Migrating Oracle databases to Amazon Aurora MySQL with DMS Schema Conversion
-
Migrating Oracle databases to Amazon RDS for PostgreSQL with DMS Schema Conversion
-
Migrating an Amazon RDS for Oracle Database to Amazon Redshift
-
Migrating from Amazon RDS for Oracle to Amazon RDS for PostgreSQL and Aurora PostgreSQL
Microsoft SQL Server
MySQL
BigQuery
MariaDB
MongoDB
PostgreSQL
SAP ASE
In the DMS User Guide, you can find additional resources: