Create DMS Source and Target Endpoints


Now that you have a replication instance, you need to create source and target endpoints for the sample database.

  1. Click on the Endpoints link on the left, and then click on Create endpoint on the top right corner.

    \[SqlDms10\]

  2. Enter the following information to create an endpoint for the source dms_sample database:

    Parameter Value
    Endpoint Type Source endpoint
    Endpoint Identifier sqlserver-source
    Source Engine sqlserver
    Server Name < SourceEC2PrivateDns >
    Port 1433
    SSL Mode none
    User Name awssct
    Password Password1
    Database Name dms_sample
    Test endpoint connection -> VPC < VPC ID from Environment Setup Step >
    Replication Instance DMSReplication

    \[SqlDms11\]

  3. Once the information has been entered, click Run Test. When the status turns to successful, click Create endpoint.

  4. Follow the same steps to create another endpoint for the Target Aurora RDS Database (dms_sample_dbo) using the following values:

    Parameter Value
    Endpoint Type Target endpoint
    Select RDS DB instance <StackName>-AuroraMySQLInstance
    Endpoint Identifier aurora-target
    Source Engine aurora
    Server Name < TargetAuroraMySQLEndpoint >
    Port 3306
    SSL Mode none
    User Name awssct
    Password Password1
    Test endpoint connection -> VPC < VPC ID from Environment Setup Step >
    Replication Instance DMSReplication

    \[SqlDms12\]

  5. Once the information has been entered, click Run Test. When the status turns to successful, click Create endpoint.