The AWS Database Migration Service (DMS) is a software tool for migrating an on-premises database to the Amazon Web Services cloud. The service aims to reduce the duration of database transfers, which can take months otherwise. AWS DMS can handle homogenous migrations, such as Oracle to Oracle, as well as heterogeneous migrations, such as Oracle to MySQL.
An administrator accesses the AWS DMS from the AWS Management Console. The administrator defines a database source from which data will be transferred and the database target that will receive the data. AWS DMS allows replication tasks to begin in minutes, and monitors the data replication process, providing the administrator with performance data in real-time. If the service should detect a network or host failure during replication, it will automatically provision a replacement host. During the database migration, AWS DMS will keeps the source database operational even if a transfer is interrupted, thereby minimizing application downtime.Content Continues Below
The administrator can automatically manage task replication, including task creation and termination through the AWS DMS application programming interface (API). To decrypt and transfer data, AWS DMS needs access to the proper credentials of the database source. If data is encrypted at the application level, it will remain encrypted when inserted into the target database.
AWS DMS supports Oracle, SQL Server, MySQL and PostGreSQL in the cloud and on-premises. If the customer wishes to use Amazon Aurora, the migration service can only be used for cloud-to-cloud migration. AWS DMS supports both one-time and continuous data replication into instances running on Relational Database Service (RDS) and Elastic Compute Cloud (EC2). For heterogeneous migrations, AWS DMS integrates with the AWS Schema Conversion Tool.