Database Migration Service Flashcards
What is Amazon Database Migration Service (DMS)?
Amazon Database Migration Service (DMS) enables you to migrate databases to AWS easily and securely with minimal downtime. It supports homogenous migrations as well as heterogeneous migrations between different database platforms.
How does DMS minimize downtime during database migration?
DMS minimizes downtime by employing continuous data replication, which allows the source database to be fully operational during the migration process, ensuring business continuity.
What types of databases can be migrated using DMS?
DMS supports a wide range of source and target databases, including relational databases, NoSQL databases, and data warehouses. Popular databases such as Oracle, MySQL, PostgreSQL, Microsoft SQL Server, and Amazon Aurora are supported.
Can DMS be used for both homogenous and heterogeneous database migrations?
Yes, DMS supports both homogenous migrations (where the source and target databases are the same type) and heterogeneous migrations (where the source and target databases are different types).
What are some common use cases for DMS?
Common use cases for DMS include database migration to AWS, database consolidation, continuous replication for real-time analytics or backup, and database version upgrades.
What is the role of the replication instance in DMS?
The replication instance is a managed AWS compute resource that hosts replication tasks. It reads data from the source database, formats it, and loads it into the target database as part of the migration process.
How is data security managed in DMS?
Data security in DMS is managed through encryption in transit using Secure Socket Layer (SSL) and encryption at rest using AWS Key Management Service (KMS). Additionally, DMS allows for network isolation using Amazon VPC and supports IAM roles for access control.
Can DMS perform schema conversion?
While DMS is primarily focused on the data replication aspect of migration, AWS provides the AWS Schema Conversion Tool (SCT) to help convert the source database schema and code to match the target database for heterogeneous migrations.
Are there any limitations or challenges with using DMS?
Some limitations or challenges may include handling of certain data types or schema differences in heterogeneous migrations, performance tuning for large-scale migrations, and ensuring extensive testing during the migration planning phase.
What steps are involved in setting up a database migration using DMS?
Setting up a database migration with DMS involves creating a replication instance, defining source and target database endpoints, creating and configuring replication tasks, and then monitoring the migration process through the DMS console.