Configure the Target Database (Local Microsoft SQL Server to RDS Microsoft SQL Server)

This guide is only for migration to RDS Microsoft SQL Server target. If your target database uses another schema, you can skip this page.

  1. Now on our EC2 instance we’ve been connecting to via RDP, we are going to connect to our SQL Server RDS target database, from within SQL Server Management Studio, select SQL Server Authentication and connect to the SQL Server RDS instance using the following parameters Please note the password is not provided below you need to goto Secrets Manager and open DMSDBSecret and reveal the SQL Server password. It is also on first Cloudformation Stack’s Output tab under SQL Server password :

    then use information below to populate the login window

    ParameterValue
    Server TypeDatabase Engine
    Server Name< TargetSQLServerEndpoint (you can find this in Cloudformation Output tab or goto RDS service in console and pick your RDS SQL Server instance>
    Logindbadmin
    PasswordSee Cloudformation Output tab & see value in DMSDBSecretP or look up password in AWS Secrets Manager for secret ending in RDSDBSecret
    Remeber Password check boxchecked

    it should look similar to

  2. Open a New Query window if one doesn’t open.

  3. Run the following script to create a target database dms_sample_target on RDS SQL Server.

    use master
GO

CREATE DATABASE dms_sample_target
GO

    Procedural code change

The target database (dms_sample_target) has now been created. You can return to the AWS Management Console.