AWS Database Migration Service

AWS DMS supports migration between 20-plus database and analytics engines, such as Oracle to Amazon Aurora MySQL-Compatible Edition, MySQL to Amazon Relational Database (RDS) for MySQL, Microsoft SQL Server to Amazon Aurora PostgreSQL-Compatible Edition, MongoDB to Amazon DocumentDB (with MongoDB compatibility), Oracle to Amazon Redshift, and Amazon Simple Storage Service (S3).

The following should be taken into account when preparing a database migration using AWS Database Migration Service:

• You configure a network to connect your databases to an AWS DMS replication instance.
• Source and target endpoints - Make sure you are aware of whatever data and tables from the source database need to be transferred to the target database. 
• Migration of schema and code - AWS DMS does not convert schema or code. To transform your schema, you can utilise programmes like Oracle SQL Developer, MySQL Workbench, and pgAdmin III.
• Unsupported data types: Verify that you can transform the source data types into the target database's equivalent data types. 
• Results of the diagnostic support script - We advise that you execute diagnostic support scripts when you're planning your migration.
• Premigration evaluations - A premigration evaluation assesses certain elements of a database migration task to assist find any issues that might prevent the task from functioning as intended.