October 17, 2021

Migrating database to AWS using AWS DMS

There are many tools to migrate databases to AWS, depending on the type of database migration. For example, for migrating Oracle databases to AWS RDS Oracle, the native tools like data pump export/import or Golden gate also works more effectively.

In this blog, explaining how to migrate data to AWS with the help of AWS DMS service.


Architecture Diagram


AWS DMS, also known as AWS Database Migration Service is AWS cloud service that helps to migrate data, from on-premises databases to Amazon RDS or databases running on Amazon EC2 to RDS, as well as from one Amazon RDS database to another Amazon RDS database.

AWS DMS migrates data, tables and primary keys to the target database. All other database elements are not migrated.

AWS Schema Conversion Tool (SCT) is another AWS cloud service, it helps to migrate schema and code from source database to target database. In case of heterogeneous database migrations, AWS Schema Conversion Tool (SCT) helps to convert schema and code from source database to target database.


Please click on the below link, for my article posted in LinkedIn, explaining the Key benefits of AWS DMS, Limitations of AWS DMS and how to migrate databases to AWS using AWS DMS. 

https://www.linkedin.com/posts/vadirajhonwad_datamigration-databasemigration-awsmigration-activity-6854527909235855360-pYos