When organizations want to migrate databases quickly and securely to Amazon Web Service (AWS), the optimized route to follow is the Database Migration Service of AWS. There are several benefits here, the most critical being that the source database is fully functional and operational during the migration process, doing away with the need for downtime. Further, data can be migrated between the most commonly used applications.

Types of AWS DMS migration

AWS DMS migration allows continual replication of data with high availability and combines databases into petabyte-scale data warehouse by streaming data to Amazon Redshift or Amazon S3.

There are two types of AWS DMS migration.

•Homogeneous database migration: Here, both the source and the target database engines have to be the same or compatible with each other. It is an easy and one-step process as the schema structure, database code, and data types equally complement the source and the target database. Examples of this type of AWS DMS migration are Oracle to Amazon RDS for Oracle, MySQL to Amazon Aurora, MySQL to Amazon RDS for MySQL, or Microsoft SQL Server to Amazon RDS for SQL Server.

•Heterogeneous database migration: In this form of AWS DMS migration the source and the target database engines are different. A schema and code transformation are needed since the data types, database code, and schema structure are not the same. However, the conversions of the required data type are automatically done by the AWS Database Migration Service during the migration.Examples include Oracle to Amazon Aurora, Oracle to PostgreSQL, or Microsoft SQL Server to MySQL migrations.

Finally, AWS Database Migration Service can be used to migrate data both into and out of the cloud.