Prerequisites for working with DMS Studio - AWS Database Migration Service

Prerequisites for working with DMS Studio

In this section, you do the following prerequisite tasks to run this tutorial:

Create a local MySQL database

Before you get started with DMS Studio, create a local MySQL database and populate it with data. You can also run the DMS Collector on an existing database in your local network, rather than creating a MySQL database.

To create a local MySQL database and populate it with data

  1. Download and install the MySQL Community Server. Make sure to register for an Oracle account if you don't already have one. You do this because the Oracle Corporation owns MySQL, and MySQL downloads are hosted on Oracle's website.

    On the Choose a setup type screen, choose Developer Default. Provide a root password when prompted, and leave all other settings as they are.

  2. Add the following location to your path.

    C:\Program Files\MySQL\MySQL Server 8.0\bin\
  3. Install Git if you haven't already done so. To do this, see Git on the Git website. On the Adjusting your PATH environment page, verify that Git from the command line and also from 3rd party software is selected.

  4. Run the following command to download a script to create and populate a database on your server.

    git clone https://github.com/datacharmer/test_db.git
  5. Run the following command from the test_db directory to run the script. Provide your root password that you created when you installed MySQL. In the following command, there's no space between -p and your password.

    mysql -uroot -p<root password> < employees.sql

Create an Amazon S3 bucket

Next, create an Amazon S3 bucket to store information about your local data environment.

To create an Amazon S3 bucket to store local data environment information

  1. Sign in to the AWS Management Console and open the Amazon S3 console at https://console.aws.amazon.com/s3/.

  2. Choose Create bucket.

  3. On the Create bucket page, give the bucket a globally unique name using your sign-in name, for example test-dms-discovery-yoursignin. Choose your local AWS Region.

  4. Leave the rest of the settings as they are, and choose Create bucket.

Create an IAM role

Next, create an AWS Identity and Access Management (IAM) role for DMS Collector and the AWS DMS fleet advisor to use to access the S3 bucket.

To create an IAM role for AWS DMS fleet advisor to use

  1. Sign in to the AWS Management Console and open the IAM console at https://console.aws.amazon.com/iam/.

  2. In the navigation pane, choose Roles.

  3. Choose Create role.

  4. On the Create role page, choose AWS Service. Choose DMS.

  5. Choose Next: Permissions.

  6. For Filter policies, enter S3. Choose AmazonS3FullAccess.

  7. Choose Next: Tags and Next: Review.

  8. For Role name, enter DMSDiscoveryS3FullAccess. Choose Create role.

  9. On the Roles page, choose the DMSDiscoveryS3FullAccess role.

  10. On the DMSDiscoveryS3FullAccess Summary page, choose the Trust relationships tab. Choose Edit trust relationship.

  11. On the Edit trust relationship page, paste the following JSON into the Policy document box.

    { "Version": "2012-10-17", "Statement": [ { "Sid": "", "Effect": "Allow", "Principal": { "Service": [ "dms.amazonaws.com", "dms-fleet-advisor.amazonaws.com" ] }, "Action": "sts:AssumeRole" } ] }

    The preceding policy document grants the sts:AssumeRole permission to the services that AWS DMS uses for discovery.

  12. Choose Update trust policy.