AWS-Logo_White-Color
1.
Getting Started
1.1.
Sign in to your AWS Account
1.2.
Create a Key Pair
1.3.
Prepare your environment
1.4.
Connect to the EC2 Instance and install the Schema Conversion tool
2.
Select your DMS source
2.1.
Oracle source
2.1.1.
Connect To The Source Oracle Database
2.1.2.
Configure The Source Oracle Database
2.2.
SQL Server source
2.2.1.
Open SQL Server Management Studio
2.2.2.
Configure The Source MS SQL Server Database
3.
Select your DMS Target
3.1.
Schema Conversion
3.1.1.
Granting permissions in the target database
3.1.2.
Create a Schema Conversion Project
3.1.3.
Convert the Schema
a.
Modify the Procedural Code
3.2.
Data Migration
3.2.1.
Configure the Target Database
a.
Configure the Target Database (Local Microsoft SQL Server to RDS Microsoft SQL Server)
b.
Aurora (MySQL compatible) target
c.
Aurora (PostgresSQL compatible) target
3.2.2.
Create a replication instance
3.2.3.
Create DMS Source and Target Endpoints
3.2.4.
Create a DMS Migration Task
3.2.5.
Inspect the Content of Target Database
a.
Microsoft SQL Server target
b.
Aurora (MySQL compatible) target
c.
Aurora (PostgresSQL compatible) target
d.
Oracle target
e.
Amazon S3 Target
3.2.6.
Replicate Data Changes
4.
Serverless replication
4.1.
Migrate Data using DMS Serverless
4.1.1.
Creating a Serverless Replication
4.1.2.
AWS DMS Serverless Replication Stages
4.2.
Testing DMS Serverless Scaling Operations
4.2.1.
Generate Load on the Source Database
4.2.2.
Monitor CloudWatch Dashboard for upscale event
4.2.3.
Monitor CloudWatch Dashboard for downscale event
5.
Monitoring DMS Migrations
5.1.
CloudWatch Metrics
5.2.
Event Notifications
5.3.
Table Statistics
5.4.
Task Logs
5.5.
Task Status
5.6.
RunBook
6.
Troubleshooting Migrations with AWS DMS
6.1.
Memory Pressure on DMS Instance
6.1.1.
Environment Creation
6.1.2.
Troubleshooting Steps
6.1.3.
Resolution
6.2.
Table Errors In DMS Task
6.2.1.
Environment Creation
6.2.2.
Troubleshooting Steps
6.2.3.
Resolution
7.
Environment Cleanup
7.1.
Delete the Serverless Migration Task
7.2.
Delete the Database Migration Task
7.3.
Delete the DMS Endpoints
7.4.
Delete the DMS Replication Instance
7.5.
Delete the CloudFormation Stack
7.6.
Delete S3 Bucket and IAM Roles
More
AWS Study Group - Blog
AWS Study Group - FB Group
English
Tiếng Việt
Clear History
Workshop
Cloud Journey
Last Updated
21-01-2025
Team
Hoàng Long
Hoàng Kha
Database Schema Conversion & Migration
>
Select your DMS Target
>
Data Migration
> Inspect the Content of Target Database
Inspect the Content of Target Database
We use different methods to inspect your target database, depending on its schema:
Microsoft SQL Server target
Aurora (MySQL compatible) target
Aurora (PostgresSQL compatible) target
Oracle target
Amazon S3 Target