Hello! We are a writer team from Definer Inc. In this issue, you are wondering how to start a DB migration with AWS Database Migration Service. Let's take a look at the actual screens and resources to explain in detail.

This article summarizes helpful information and practices when you want to migrate your database using the AWS Database Migration Service.

AWS Database Migration Service (DMS) is a DB migration service provided by AWS for relational databases, NoSQL databases, and data warehouses.   The following three terms are important to remember when using the Database Migration Service.   ・Endpoint Endpoint is the definition of the connection information to the database. There are two endpoints, one for the source DB and the other for the target DB.   ・Replication Instance This is the instance that connects the source and target DBs and executes the data replication task.   ・Replication Task This is the execution unit of data replication and where data migration is actually performed.   The following three patterns exist as data replication methods.   ・Full load The specified table data is migrated from the source DB to the target DB as it is.   ・Full load + CDC (continuous replication) Full load is executed while capturing changes in the source DB. After the full load is completed, the captured changes are periodically reflected in the target DB.   ・CDC (Continuous replication) Without performing a full load, changes in the source DB are periodically read and the changed data is reflected in the target DB.

Let's try Database Migration Service. As a precondition, it is assumed that the source (source) and target (target) DBs exist.   (1) Create a replication instance of DMS Go to the DMS console and select "Replication Instance" -> "Create Replication Instance". Enter the name, instance class, and network information such as VPC and SecurityGroup. For Public Access, check the box if you need to connect to the replication instance from the source/target DB via the Internet. Wait a few minutes for the creation to complete.     (2) DMS endpoint creation Two endpoints must be created, one for the source DB and one for the target DB. In the DMS console, go to "Endpoints" -> "Create Endpoints" If the source/target DB is RDS, check "Select RDS DB instance". Otherwise, enter connection information.     (3) Creating a DB Migration Task In the DMS console, click "Database Migration Tasks" > "Create Task". Specify the endpoints and replication instances created earlier. For the data replication type, we selected "full load" this time.   When the status becomes "Load Complete", replication is complete. After logging into the DB and checking the table list, the DB migration was successful.

## Log in to postgreSQL
psql -p 5432 -d ${database name} -U postgres -h ${RDS endpoint}                

 

Display DB table list

\dt
                    List of relations
 Schema |            Name             | Type  |  Owner   
--------+-----------------------------+-------+----------
 dev    | all_job                     | table | postgres
 dev    | all_skill                   | table | postgres                  

Things to read when considering AWS DMS for the first time ... Best Practices for AWS Database Migration Service - AWS ... Using AWS DMS and AWS Snowball for large-scale database migrations ... What is AWS Database Migration Service? AWS Database Migration Service (with minimal downtime ... Creating tasks for continuous replication using AWS DMS ... Trouble with migration tasks with AWS Database Migration Service ... Troubleshooting AWS DMS tasks with error status Best Practices for AWS Database Migration Service - AWS ...

・PrismScaler is a web service that enables the construction of multi-cloud infrastructures such as AWS, Azure, and GCP in just three steps, without requiring development and operation. ・PrismScaler is a web service that enables multi-cloud infrastructure construction such as AWS, Azure, GCP, etc. in just 3 steps without development and operation. ・The solution is designed for a wide range of usage scenarios such as cloud infrastructure construction/cloud migration, cloud maintenance and operation, and cost optimization, and can easily realize more than several hundred high-quality general-purpose cloud infrastructures by appropriately combining IaaS and PaaS.  

This article provides useful introductory information free of charge. For consultation and inquiries, please contact "Definer Inc".

・Definer Inc. provides one-stop solutions from upstream to downstream of IT. ・We are committed to providing integrated support for advanced IT technologies such as AI and cloud IT infrastructure, from consulting to requirement definition/design development/implementation, and maintenance and operation. ・We are committed to providing integrated support for advanced IT technologies such as AI and cloud IT infrastructure, from consulting to requirement definition, design development, implementation, maintenance, and operation. ・PrismScaler is a high-quality, rapid, "auto-configuration," "auto-monitoring," "problem detection," and "configuration visualization" for multi-cloud/IT infrastructure such as AWS, Azure, and GCP.