This is in continuation of earlier blog on AWS DMS where we shall Configure Ongoing Replication from RDS to Redshift. Later we shall see some wonderful DMS features.
Lets start:
Refer to Sample screen shots showing how to configure DMS service: Login to your AWS account.
On the landing page various options are available like creating Replication Instance, End points, migration tasks etc. We need to start with Replication Instance.
Navigate to Replication Instance => Create Replication Instance
Choose the values as per your requirement. Below is a sample screenshot:
GoTo => AWS DMS Home Page => Create Endpoint
Landing page is a common page, it is used to create both Source/Target Endpoint, one at a time. First create Source Endpoint using Source details. Then create Target Endpoint using Target details.
In below fields use Source/Target information as per your system:
Choose as per your organization standards. Default : aws keys
Once Endpoint is created, we can Click Run test to check for any issues in connectivity from Replication Instance to created Endpoint.
NOTE: We need to create both Source and Target endpoints before proceeding further.
Single Endpoint can be used by More than one replication tasks.
For example, if you have two different applications running on same Source database and you want to migrate them separately then do below:
Create two replication tasks one for each application Use same DMS endpoints in both tasks and Voila!!!! Run the replication.
GoTo: Database Migration Tasks => Create Task
On Landing page, you need to use below details configured as per Step-1 and 2 previously:
NOTE: Decide on which kind of Migration you would like to do and choose Migration Type accordingly.
Section: Task Settings: In this section you need to decide on :
Choose the settings carefully as per your requirement.
Section: Premigration Assessment
Before running actual migration we have option to generate assessment report. It checks for any issues/errors we might get during actual migration. It creates a report and save it to our defined S3 location to refer to. Enable Checkbox to use this report.
Section: Migration Task startup:
If you want to just create the task but run it later, choose “Manually later” option.
Below screen shows you a quick summary of your replication task and its last runtime information.
To check detailed summary with the status of our Migration task, get stats on timings, check whether mapping rules were followed, errors encountered during task migration and other details.
Migration Task Summary:
GoTo: DMS => Database migration tasks=> Your replication task name
Once started, we can check different metrics under various available tabs to see the status of our replication task. Below sample shows stats for Table migration done.
If Multi-AZ is selected for AWS DMS, it itself provisions and maintains a standby replica of the replication instance(RI).
Replica is kept in different Availability Zone. The primary RI is replicated synchronously across availability Zones to a standby replica
Using Multi-AZ provides below benefits:
AWS DMS supports both normal regions and AWS GovCloud (US)
AWS GovCLoud(US) is designed to allow US government agencies and customers to move sensitive workloads into the cloud. It addresses the specific Compliance and Regulatory requirements.
DMS can be used for Heterogeneous Migration ie when source and target use different database engines.
4. Available migration options:
NOTE: Exception: Can not be used to migrate from On-Prem to On-Prem
On Amazon EC2, you can choose to run instances with License included (which means you already have purchased from Microsoft). Second option is to pay cost for Windows server and Sql Server License together with EC2 cost.
For rest, as per Microsoft terms, customers have option of BYOL ie Bring Your Own License
Through part 1 and 2 of this blog, we tried to understand DMS, its architecture, features and how to use DMS . Hope this will help you to kickstart your adventure with DMS and gain good understanding of it. Best of Luck!!!
Learn about Rackspace Managed SQL Databases.
Learn about Rackspace Database Services.
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.