Use AWS DMS to convert Oracle datatypes to Postgres?

Question

I'm confused on how to approach this. I think I have to create a DMS migration task in AWS and select the Source Endpoint as Oracle and the Target as Postgres? I see this listed on the AWS document:

Example Change data type of target column

The following example changes the data type of a target column named SALE_AMOUNT from an existing data type to int8.


{
    "rule-type": "transformation",
    "rule-id": "1",
    "rule-name": "RuleName 1",
    "rule-action": "change-data-type",
    "rule-target": "column",
    "object-locator": {
        "schema-name": "dbo",
        "table-name": "dms",
        "column-name": "SALE_AMOUNT"
    },
    "data-type": {
        "type": "int8"
    }
}

I was told I need to use it somehow but I'm not sure how this ties into creating a DMS migration task. Where do I create the rules for the DMS transformation of the data types transforming from Oracle to Postgres? I don't know what to do and my POC isn't responding. I created a table in Oracle and now I want to load the table from Oracle to our Postgres database using DMS.

Use AWS DMS to convert Oracle datatypes to Postgres?

0 Answers0