Prepare your environment

In this step, you will use a CloudFormation (CFN) template to deploy the infrastructure for this database migration. AWS CloudFormation simplifies provisioning the infrastructure, so we can concentrate on tasks related to data migration.

  1. Open the AWS CloudFormation console , and click on the Create Stack button.

    CFn Stacks menu

  2. Select Template is ready, and choose Upload a template file as the source template. Then, click on Choose file and upload the DMSWorkshop2025.yaml. Click Next.

    Upload template file

  3. Populate the form as with the values specified below, and then click Next.

    Input ParameterValues
    Stack NameA unique identifier without spaces.
    MigrationType / Lab TypeDatabase that you want to migrate (Oracle or SQL Server).
    EC2ServerInstanceTypeAn Amazon EC2 Instance type from the drop-down menu. Recommend using the default value.
    KeyNameThe KeyPair (DMSKeypair) that you created in the previous step.
    RDSInstanceTypeAn Amazon RDS Instance type from the drop-down menu. Recommend using the default value.
    VpcCIDRThe VPC CIDR range in the form x.x.x.x/16. Defaults to 10.20.0.0/16
    IAMRoleDmsVpcExistDoes your AWS account already have dms-vpc-role(goto IAM>roles & search for “dms-vpc” to check) if this role is not there template will fail-rollback unless you change default Y to N?

    Upload template file

The resources that are created here will be prefixed with whatever value you specify in the Stack Name. Please specify a value that is unique to your account.

  1. On the Stack Options page, accept all of the defaults and click Next.

    Stack options

    Agree to create necessary IAM roles

  2. On the Review page, click Create stack.

    Agree to create necessary IAM roles

  3. At this point, you will be directed back to the CloudFormation console and will see a status of CREATE_IN_PROGRESS. Please wait here until the status changes to CREATE_COMPLETE.

    Agree to create necessary IAM roles

  4. Once CloudFormation status changes to CREATE_COMPLETE, go to the Outputs section.

  5. Make a note of the Output values from the CloudFormation environment that you launched as you will need them for the remainder of the tutorial:

    Agree to create necessary IAM roles