Oracle Views to Postgres Migration
Budget: €2 – €6 EUR
I have between one and five Oracle database views that now need to live in PostgreSQL. The set is mixed—some definitions are straightforward while a couple contain more involved logic with joins, sub-queries, and conditional calculations. Raw speed is not my main concern; accuracy and faithful recreation of the existing results matter far more.
You will receive the Oracle view DDL and sample data to test against. Your job is to translate each view to native Postgres syntax, adjust or replace any Oracle-specific functions, and return working Postgres CREATE VIEW scripts. I will validate the scripts by running them on our staging database and comparing row counts and sample outputs.
Once each view produces identical results in Postgres, the task is done. If you spot minor opportunities for cleaner syntax in the new environment, feel free to include them, but exhaustive performance tuning is outside this scope.
You will receive the Oracle view DDL and sample data to test against. Your job is to translate each view to native Postgres syntax, adjust or replace any Oracle-specific functions, and return working Postgres CREATE VIEW scripts. I will validate the scripts by running them on our staging database and comparing row counts and sample outputs.
Once each view produces identical results in Postgres, the task is done. If you spot minor opportunities for cleaner syntax in the new environment, feel free to include them, but exhaustive performance tuning is outside this scope.