Postgres to Oracle Query Adaptation
Budget: $250 – $750 USD
I have several BI files with queries from an E-SUS application that were originally designed for Postgres. I need these queries and data manipulation scripts adjusted to work in an Oracle environment instead.
Specifics:
- You will be adapting data manipulation scripts and making specific adjustments to queries so they can interact with an Oracle database.
- The scripts do not include any particular data types or functions specific to Postgres, so your focus will primarily be on the adaptation of the queries and scripts.
Please note that while some basic indexing is used in the current Postgres queries, no extensive indexing or performance optimization techniques have been implemented. Your task will also involve ensuring that the adapted scripts maintain an acceptable level of performance in the Oracle environment.
Specifics:
- You will be adapting data manipulation scripts and making specific adjustments to queries so they can interact with an Oracle database.
- The scripts do not include any particular data types or functions specific to Postgres, so your focus will primarily be on the adaptation of the queries and scripts.
Please note that while some basic indexing is used in the current Postgres queries, no extensive indexing or performance optimization techniques have been implemented. Your task will also involve ensuring that the adapted scripts maintain an acceptable level of performance in the Oracle environment.