The AWS Database Migration Service helps you migrate databases to AWS easily and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. AWS Database Migration Service can also be used for continuous data replication with high availability.
This lab will walk you through the steps to Create a DMS Replication Instance and endpoints.
In this activity, you perform the following tasks:
- Create a DMS Replication Instance
- Create DMS source and target endpoints
- Go to the AWS DMS console and click on Replication Instances on the navigation menu. This will launch the Replication instance screen in the Database Migration Service.
- Click on the Create replication instance button on the top right side.
- Configure the replication instance with the following parameter values. Then, click on the Create button.
Note: Make sure that you have selected replication engine version as 2.4.5
| Parameter | Value |
|---|---|
| Name | replication-instance |
| Description | Oracle to Aurora DMS replication instance |
| Instance Class | dms.c4.xlarge |
| Replication engine version | 2.4.5 |
| VPC | vpc-xxxxxxxxx (VpcId from CloudFormation stack output) |
| Allocated storage (GB) | Leave default |
| Multi-AZ | Unchecked |
| Publicly accessible | Unchecked |
Note: Creation of the replication instance takes a few minutes. While waiting for the replication instance to be created, you can proceed with creation of source and target database endpoints in the next step. However, you can test the endpoint connectivity only after the replication instance has been created.
- Click on the Endpoints link on the left menu, and then click on Create endpoint on the top right corner.
- Enter the Connection details for the source endpoint as shown in the following table.
| Parameter | Value |
|---|---|
| Endpoint type | Source endpoint |
| Endpoint identifier | oracle-source |
| Source engine | oracle |
| Server name | Get OracleSCTInstancePrivateIP from CloudFormation stack output |
| Port | 1521 |
| SSL mode | none |
| User name | hr |
| Password | hr123 |
| SID | XE |
- Once the information has been entered, click Run Test under Test endpoint connection (optional). When the status turns to successful, click Create endpoint.
_Note: You can test the endpoint connectivity only after the replication instance has been created, wait for the replication instance creation to be completed.
- Repeat the previous steps to create the target endpoint for the Aurora PostgreSQL database with the following values.
| Parameter | Value |
|---|---|
| Endpoint type | Target endpoint |
| Endpoint identifier | aurora-postgresql-target |
| Source engine | aurora-postgresql |
| Server name | Get AuroraPostgreSQLEndpoint from CloudFormation stack output |
| Port | 5432 |
| SSL mode | none |
| User name | postgres |
| Password | Aurora321 |
| Database name | AuroraPostgreSQLDB |
- Once the information has been entered, click Run Test under Test endpoint connection (optional). When the status turns to successful, click Create endpoint.