AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps move your database and workloads to AWS quickly, securely, and with minimal downtime and zero data loss.
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.