Cloud-based Database Migration Service of Amazon Web Service (DMS AWS) facilitates easy and seamless migration of databases to AWS. It is based in the cloud and users can migrate existing on-premises databases to the cloud or between two cloud providers. The advantage is that by migrating with AWS DMS, users can avail all the cutting-edge features of the cloud.

There are two methods of migrating databases through DMS AWS.

•Homogeneous database migration: This form of migration is necessary when the engines, the data codes, data types, and the schema structures of the source and the target databases are the same. This makes the migration a simple one-step process. After a link is established between the designated source and the target databases, migration can be started with DMS AWS with a click of a button.

For homogeneous migration, the source database can be an Amazon RDS or operating on an Amazon EC2 instance outside the AWS. The target database can be on Amazon RDS or Amazon EC2 instance.

A few examples of this type of migration are MySQL to Amazon RDS for MySQL. Oracle to Amazon RDS for Oracle, Microsoft SQL Server to Amazon RDS for SQL Server, and MySQL to Amazon Aurora.

•Heterogeneous database migration: As distinct from the previous method, this type of database migration is necessary when the engines, the data codes, data types, and the schema structures of the source and the target databases are different.

Hence, migration is a more complex two-step process. First, with the AWS Schema Conversion Tool (AWS SCT) the data code and the schema structure of the source database have to be converted to match that of the target database. Once this is done, migration is started automatically by DMS AWS. The source database in heterogeneous migration can be on Amazon RDS or Amazon EC2 instance, either off-site or on.

A few examples of heterogeneous migration are Microsoft SQL Server to MySQL migrations, Oracle to Amazon Aurora, or Oracle to PostgreSQL.

There are several benefits of DMS AWS, making it the preferred choice of organizations for database migration.

•DMS AWS automatically deploys, manages, and tracks database migration while providing full infrastructure support. Migration can be started as soon as DMS AWS is configured.

•Users get unlimited storage capacities and pay only for the quantum of resources used. Additional storage is provided immediately in case of shortage and migration can be restarted immediately.

•DMS AWS offers automatic fail over and reversal capabilities. In case of an outage in the primary server during migration, secondary servers are triggered instantly. When the outage is resolved, the primary server is updated with all changes in the break period, and migration is resumed as before.

•Safe and secure migration as data at the source is encrypted with AWS Key Management Service and by Secure Socket Layer in the target database.

These are the benefits of database migration with DMS AWS.