What is Amazon Database Migration Service?
Amazon Database Migration Service (Amazon DMS) is a cloud service that makes it possible to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use Amazon DMS to migrate your data into the Amazon Web Services Cloud or between combinations of cloud and on-premises setups.
With Amazon DMS, you can discover your source data stores, convert your source schemas, and migrate your data.
To discover your source data infrastructure, you can use DMS Fleet Advisor. This service collects data from your on-premises database and analytic servers, and builds an inventory of servers, databases, and schemas that you can migrate to the Amazon Cloud.
To migrate to a different database engine, you can use DMS Schema Conversion. This service automatically assesses and converts your source schemas to a new target engine. Alternatively, you can download the Amazon Schema Conversion Tool (Amazon SCT) to your local PC to convert your source schemas.
After you convert your source schemas and apply the converted code to your target database, you can use Amazon DMS to migrate your data. You can perform one-time migrations or replicate ongoing changes to keep sources and targets in sync. Because Amazon DMS is a part of the Amazon Web Services Cloud, you get the cost efficiency, speed to market, security, and flexibility that Amazon services offer.
At a basic level, Amazon DMS is a server in the Amazon Web Services Cloud that runs replication software. You create a source and target connection to tell Amazon DMS where to extract data from and where to load it. Next, you schedule a task that runs on this server to move your data. Amazon DMS creates the tables and associated primary keys if they don't exist on the target. You can create the target tables yourself if you prefer. Or you can use Amazon Schema Conversion Tool (Amazon SCT) to create some or all of the target tables, indexes, views, triggers, and so on.
The following diagram illustrates the Amazon DMS replication process.
References
-
Amazon Regions that support Amazon DMS – For information about what Amazon Regions support Amazon DMS, see Working with an Amazon DMS replication instance.
-
Cost of database migration – For information on the cost of database migration, see the Amazon Database Migration Service pricing page
. -
Amazon DMS features and benefits – For information about Amazon DMS features and benefits, see Amazon Database Migration Service Features
. -
Available database options – To learn more about the variety of database options available on Amazon Web Services, see Choosing the right database for your organization
.
Migration tasks that Amazon DMS performs
Amazon DMS takes over many of the difficult or tedious tasks involved in a migration project:
In a traditional solution, you need to perform capacity analysis, procure hardware and software, install and administer systems, and test and debug the installation. Amazon DMS automatically manages the deployment, management, and monitoring of all hardware and software needed for your migration. Your migration can be up and running within minutes of starting the Amazon DMS configuration process.
With Amazon DMS, you can scale up (or scale down) your migration resources as needed to match your actual workload. For example, if you determine that you need additional storage, you can easily increase your allocated storage and restart your migration, usually within minutes.
Amazon DMS uses a pay-as-you-go model. You only pay for Amazon DMS resources while you use them, as opposed to traditional licensing models with up-front purchase costs and ongoing maintenance charges.
Amazon DMS automatically manages all of the infrastructure that supports your migration server, including hardware and software, software patching, and error reporting.
Amazon DMS provides automatic failover. If your primary replication server fails for any reason, a backup replication server can take over with little or no interruption of service.
Amazon DMS Fleet Advisor automatically inventories your data infrastructure. It creates reports that help you identify migration candidates and plan your migration.
Amazon DMS Schema Conversion automatically assesses the complexity of your migration for your source data provider. It also converts database schemas and code objects to a format compatible with the target database and then applies the converted code.
Amazon DMS can help you switch to a modern, perhaps more cost-effective, database engine than the one you are running now. For example, Amazon DMS can help you take advantage of the managed database services provided by Amazon Relational Database Service (Amazon RDS) or Amazon Aurora. Or it can help you move to the managed data warehouse service provided by Amazon Redshift, NoSQL platforms like Amazon DynamoDB, or low-cost storage platforms like Amazon Simple Storage Service (Amazon S3). Conversely, if you want to migrate away from old infrastructure but continue to use the same database engine, Amazon DMS also supports that process.
Amazon DMS supports nearly all of today's most popular DBMS engines as source endpoints. For more information, see Sources for data migration.
Amazon DMS provides a broad coverage of available target engines. For more information, see Targets for data migration.
You can migrate from any of the supported data sources to any of the supported data targets. Amazon DMS supports fully heterogeneous data migrations between the supported engines.
Amazon DMS ensures that your data migration is secure. Data at rest is encrypted with Amazon Key Management Service (Amazon KMS) encryption. During migration, you can use Secure Socket Layers (SSL) to encrypt your in-flight data as it travels from source to target.