This document gives the requirements and best practices for changing the technology of your backend database from Oracle to PostgreSQL.
...
Examples of NULL handling
| Oracle | Postgres | Postgres | SemQL (Oracle, PostgreSQL |
|---|
| ) | ||
|---|---|---|
SELECT 'Something plus' || NULL FROM dual; Something plus | SELECT 'Something plus' || NULL; [NULL] | select concat('Something plus', null); Something plus |
CONCAT( 'Something plus', null ) Something plus |
Reference Information
The following link provides reference Information to convert Oracle to PostgreSQL.
...
postgres RDS r5.2xlarge (8CPU/64GRAM)
oracle RDS db.m5.2xlarge (8CPU/32GRAM)
The DI runtime was installed on the ec2 instance where Semarchy runs, in the same region as both RDS source and target instances with only 4G of RAM.
...