Skip to main content

Question

 Jkanjaria User (JkanjariaU17487363)

US
JkanjariaU17487363 Member since 2025 1 post
Posted: 3 weeks 6 days ago
Last activity: 3 weeks 6 days ago
Posted: 30 May 2025 12:45 EDT
Last activity: 30 May 2025 13:49 EDT

Oracle to AWS Postgres Conversion

Hi,

We are converting from Oracle to AWS Postgres.  Postgres has a lot more datatypes.  What is the Oracle datatype to Postgres datatype conversion that we should be using.   Is there documentation that lists the Oracle datatypes to corresponding Postgres datatypes.

 

Thank you,

Jalpa

 

 

 

To see attachments, please log in.
Pega Platform 8.8.5
Pega Platform
Government
Data Scientist

  • Reply
Posted: 3 weeks ago
Posted: 30 May 2025 13:49 EDT
Ranjith Kondru (RanjithK8179)
Navy Federal Credit Union

Navy Federal Credit Union
US

@JkanjariaU17487363 - 

You do refer below links as a reference, since you are migrating from Oracle to AWS Postgres i am assuming you might be leveraging AWS Database Migration Service (AWS DMS) and the AWS Schema Conversion Tool (AWS SCT) which will take care of the conversion of datatypes https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.tables.common.html

https://docs.aws.amazon.com/dms/latest/sbs/chap-rdsoracle2postgresql.html

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice