PostgreSQL (OFBiz) - ofbizolap

PostgreSQL (OFBiz) - ofbizolap database

Create Source endpoint

  1. Open the Database Migration Services (DMS) service. Go to Services, Database Migration Services.

  2. In the navigation pane, click Endpoints, then select Create endpoint. Create source endpoint OFBiz

  3. Endpoint type: Source endpoint.

  4. In Endpoint configuration:

    • Endpoint identifier: SourceOFBiz-ofbizolap
    • Source engine: postgres
    • Server name: Use the IP address that you wrote down in step 1 in the section “PostgreSQL (OFBiz) - ofbiz”
    • Port: 5432
    • User name: ofbiz
    • Password: Same password used to logon to the linux box
    • Database name: ofbizolap Select source endpoint OFBiz

      The IP address above in the field Server name is only an example. Your IP address may be different. Use the IP address that you wrote down in step 1

  5. Expand Test endpoint connection. Select:

    • VPC: Target
    • Replication Instance: mid-repinst-ofbiz
    • Click on Run test. Wait for the test result. In case of error, review the parameters again.

  6. After the sucessful status, click on Create endpoint Select source endpoint OFBiz

Create Target endpoint

  1. In the navigation pane, click Endpoints, then select Create endpoint. Create target endpoint OFBiz

  2. Select Endpoint type: Target endpoint.

  3. Check box Select RDS DB instance and select the RDS Instance: mid-ofbiz-instance-1.

  4. In Endpoint configuration:

    • Endpoint identifier: TargetOFBiz-ofbizolap
    • Password: the same password that you set when you created the RDS database
    • Database name: ofbizolap

    All other settings can be used as the default values. Select target endpoint OFBiz

  5. Expand Test endpoint connection. Select:

    • VPC: Target
    • Replication Instance: mid-repinst-ofbiz
    • Click on Run test. Wait for the test result. In case of error, review the parameters again.

  6. After the successful status, click on Create endpoint Select target endpoint OFBiz