Database definition

What is AWS Database Migration Service (AWS DMS)?

AWS Database Migration Service (DMS) is a software tool for migrating a on the site database to the Amazon Web Services cloud. JThe service aims to reduce the duration of database transfers, which can otherwise take months. AWS DMS can handle homogeneous migrations, such as Oracle to Oracle, as well as heterogeneous migrations, such as Oracle to MySQL.

An administrator accesses AWS DMS from the AWS Management Console. The administrator defines a database source from which the data will be transferred and the database target that will receive the data. AWS DMS allows replication jobs to start in minutes and monitors the data replication process, providing the administrator with real-time performance data. If the service should detect a network or host failure during replication, it will automatically provide a replacement host. During database migration, AWS DMS keeps the source database operational even if a transfer is interrupted, minimizing application downtime.

The administrator can automatically manage task replication, including creating and stopping tasks through the AWS DMS application programming interface (API). To decrypt and transfer data, AWS DMS needs access to the appropriate database source credentials. If the 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 premise. If the customer wants to use Aurora Amazonthe migration service can only be used for cloud-to-cloud migration. AWS DMS supports one-time and continuous replication of data across instances running on Relational Database Service (RDS) and Elastic Computing Cloud (EC2). For heterogeneous migrations, AWS DMS integrates with AWS Schema Conversion Tool.