Inside a UK enterprise equipment room in the early evening, a technician's hands connect network cables to a single rack-mounted database server beside an open equipment case. Close framing shows cabl

Should a UK Enterprise Move Off Oracle Database to Managed PostgreSQL

12 min read

The worked example compares £78,389 in first-year Oracle EE and Partitioning support at list prices with £32,792 annually for selected AWS PostgreSQL Multi-AZ compute and storage, without establishing equivalent capacity. Existing deployments need their actual renewal quote, while migration costs depend on code conversion, testing and the chosen target service.

Daniel Thomas
Written by Daniel Thomas

For a UK enterprise paying Oracle Database Enterprise Edition support every year, managed PostgreSQL could reduce recurring costs. In this worked example, AWS compute and storage cost £32,792 annually against £78,389 for Oracle's first-year support at list prices, although equivalent workload capacity has not been demonstrated. The decision turns on your actual Oracle renewal quote, the target configuration and how much Oracle-specific code needs conversion, testing or rewriting before the migration saving starts.

Key pointers

  • Oracle Database Enterprise Edition costs $47,500 per Processor licence plus $10,450 for the first year of Software Update Licence & Support, list price (Oracle Technology Global Price List, 15 September 2026).
  • Current AMD EPYC and Intel Xeon chips carry Oracle's 0.5 core factor, so licensing all 16 physical cores in the example requires 8 Processor licences (Oracle Processor Core Factor Table).
  • PostgreSQL itself has no licence fee, but managed services can charge for compute, storage, data transfer, provisioned IOPS, additional throughput, monitoring and extended-version support.
  • Migration costs depend on the constructs in your codebase and the target service, because tools automate some PL/SQL conversion while other objects need manual changes.
  • Ask any commercial Postgres or hyperscaler supplier three things: what percentage of your schema converts automatically, what their Oracle-compatibility features cover, and what a Multi-AZ or zone-redundant configuration actually costs per year.
  • EDB Postgres Advanced Server's Oracle-compatibility features can reduce rewriting, but require an EPAS deployment with its own commercial subscription.
  • Staying on Oracle but moving it into Oracle Cloud Infrastructure, on consumption-based ECPU pricing or Bring-Your-Own-Licence terms, is a real middle option if a full migration is not worth the risk this year.
  • Get your own core count and option list priced against the vendor's own price list, and obtain your actual renewal quote for an existing deployment, before you trust anyone else's TCO model, including this one.
How an Oracle to PostgreSQL migration flows
Assess the source code, select a target deployment, convert and test before cutting over the application.

Why UK Enterprises Are Reconsidering Oracle Licensing

Oracle Database Enterprise Edition is licensed by Processor or by Named User Plus. This example uses the Processor metric and assumes the whole server is within the licensing scope. For AMD EPYC and current Intel Xeon chips, the core factor is 0.5, so a two-socket server with eight cores per socket (16 physical cores) needs 8 Processor licences. At $47,500 per Processor for Enterprise Edition, that is $380,000 in perpetual licence fees before a single option is added, plus $83,600 for the first year of Software Update License & Support (Oracle's own name for this line item) at the published 22% rate.

Options add to the Enterprise Edition price where the deployment requires them. Partitioning costs $11,500 per Processor plus $2,530 first-year support. Real Application Clusters costs $23,000 per Processor, and Active Data Guard costs $11,500 per Processor. Each option repeats the licence-plus-22%-first-year-support arithmetic on top of the base Enterprise Edition fee in Oracle's published price list.

Lower utilisation alone does not reduce licensing requirements, but the licensable core count depends on the deployment and applicable terms. PostgreSQL itself carries no licence fee. Managed PostgreSQL services still charge for infrastructure and applicable extras: AWS lists charges including data transfer, provisioned IOPS, additional throughput, monitoring and extended-version support alongside compute and storage (AWS pricing). That difference in cost structure is a reason to compare the full recurring bills before a renewal.

What Oracle Costs You Today

Using Oracle's own published price list, a UK enterprise purchasing Oracle Database Enterprise Edition with the Partitioning option for a single two-socket, 16-core server would incur the following licence and first-year support costs, in US dollars at Oracle's global list price, before any negotiated discount:

Assumptions: all 16 physical cores are within the licensing scope, AMD EPYC or a current Intel Xeon (0.5 core factor), licensable Processors = 16 × 0.5 = 8. GBP figures use the European Central Bank's 29 September 2026 reference cross-rate of 1 USD = £0.7549 (ECB reference rates); this is an exchange-rate estimate, not a UK quoted price, and moves with the market and with any discount Oracle offers. GBP values are rounded to the nearest pound after conversion.

ComponentFormulaUSDIndicative GBP
Enterprise Edition licence (one-off)8 × $47,500$380,000£286,862
Partitioning licence (one-off)8 × $11,500$92,000£69,451
Enterprise Edition support (first year)8 × $10,450$83,600£63,110
Partitioning support (first year)8 × $2,530$20,240£15,279
Total first-year support$103,840£78,389

That £78,389 represents first-year support on top of a fresh £356,313 licence purchase at these list prices and the stated exchange rate. Page 15 of Oracle's price list specifies that published support prices apply to the first year only; renewals use the previous year's support fees plus Oracle's Inflationary Adjustment Rate, subject to applicable contractual caps. An existing deployment requires its actual renewal quote. These figures do not include the server hardware or DBA time.

What Managed PostgreSQL Costs Instead

PostgreSQL itself has no licence fee. The following examples use AWS's and Microsoft's published UK-region rates, but they are different configurations and do not establish equivalent workload capacity to each other or to the Oracle server.

Annual costs assume 8,760 hours of operation. The AWS storage calculation treats 2 TB as 2,000 billed GB and uses the Multi-AZ rate of $0.266 per GB-month, giving 2,000 × $0.266 × 12 = $6,384. Figures exclude applicable VAT and service charges beyond the components shown.

OptionSpecDeploymentAnnual cost (USD)Indicative GBP
AWS RDS for PostgreSQL, eu-west-2 (London)db.r6g.4xlarge, 16 vCPU, 128 GiBMulti-AZ with one standby (compute only)$37,054.80£27,973
AWS RDS for PostgreSQL storage, 2 TB gp3eu-west-2 (London), 2,000 billed GBMulti-AZ with one standby$6,384£4,819
AWS RDS total (compute + 2 TB storage)Multi-AZ with one standby$43,438.80£32,792
Azure Database for PostgreSQL Flexible Server, UK SouthStandard_D16ds_v5, 16 vCore, 64 GiB, General PurposeSingle instance (non zone-redundant), compute only$14,436.48£10,898

Source: AWS RDS for PostgreSQL pricing and Azure Database for PostgreSQL Flexible Server pricing, with rates checked on 29 September 2026.

That AWS Multi-AZ figure, £32,792 a year for compute and 2 TB of storage, is approximately 41.8% of the example's £78,389 first-year Oracle support cost, before counting Oracle's one-off licence purchase. It is a comparison of selected cost components, not evidence that the configurations deliver equivalent performance or that an existing deployment's renewal would cost £78,389.

The Azure figure covers a single instance with half the AWS instance's RAM and excludes storage. Adding zone-redundant high availability doubles Azure compute to $28,872.96 annually before storage, compared with $37,054.80 for AWS compute alone. Multi-AZ and zone redundancy therefore need their own cost calculations; they are not free additions to the single-instance price. PostgreSQL table partitioning carries no extra database licence fee.

These examples do not include a separate commercial PostgreSQL support subscription. EnterpriseDB's own documentation for its EDB Postgres AI Cloud Service shows estimated management-infrastructure costs of $400-700 a month for Azure, $400-600 for AWS and $600-800 for Google Cloud at list price. These are infrastructure estimates, not support-subscription quotes; EDB's service pricing is based on provisioned vCPUs, while infrastructure in a customer's own cloud account is billed by that cloud provider (EDB pricing and billing). Community PostgreSQL with no paid support contract is also a legitimate choice for teams confident in their own DBA skills, since the licence itself is free either way.

What the Migration Adds to the Cost

The licensing saving is straightforward to calculate. The migration project is not, because it depends on how much Oracle-specific code your applications rely on.

Schema conversion tools automate part of the work. AWS's Schema Conversion Tool (SCT) connects to the source Oracle database, converts the schema and produces an assessment report showing which objects converted cleanly and which need manual attention (AWS SCT documentation). Ora2Pg is a free, open-source tool that scans an Oracle database, extracts its structure or data and generates SQL scripts for PostgreSQL; it also automates some PL/SQL conversion, including autonomous-transaction wrappers using dblink or pg_background (Ora2Pg project documentation). One licensing consultancy puts typical automatic conversion rates at 75-92% of schema objects, a figure it presents as its own benchmark rather than a number either Oracle or AWS publishes (Oracle Licensing Experts).

PL/SQL can concentrate the remaining effort. Packages, autonomous transactions, Oracle-specific built-in procedures such as DBMS_OUTPUT and DBMS_LOB, and some cursor-handling patterns require assessment against the conversion tool and target service. They do not universally require manual rewriting. The same consultancy estimates 6-9 person-months of manual conversion work for a 200,000-line PL/SQL codebase; that is its worked estimate, not a vendor-published figure or a quote for your estate.

EDB Postgres Advanced Server can narrow the compatibility gap, at a cost. EDB's Oracle-compatible features include a PL/SQL-compatible stored procedural language, Oracle-style data-dictionary views, and dblink_ora, an OCI-based database link that lets EDB Postgres Advanced Server query a live Oracle system directly, useful for a phased cutover (EDB compatibility documentation). EPAS is a separate database distribution requiring its own deployment and commercial subscription, not an extension you can add to RDS or Aurora PostgreSQL. Its effect on conversion effort needs testing against your codebase.

Oracle-specific architecture also needs assessment. Real Application Clusters' shared-storage active-active clustering, Exadata-specific hardware optimisations and some advanced spatial 3D functions do not map cleanly onto PostgreSQL or its managed-service equivalents in the consultancy's comparison. If your workload leans heavily on any of these, migration risk rises accordingly and a like-for-like comparison stops being simple.

Options Compared

OptionLicence costWhere it runsBest fitWeakest point
Stay on Oracle Database EE (on-premises or lift-and-shift)$47,500/Processor plus 22% first-year support, list price; existing deployments need their actual renewal quoteExisting data centre or IaaSHeavy RAC, Exadata or PL/SQL estates where rewrite risk outweighs the savingRecurring support and infrastructure costs remain
Oracle Base Database Service (OCI)Consumption (ECPU-hour), with software and support included or BYOLOracle Cloud InfrastructureStaying on Oracle's engine while moving off owned hardwareRequires pricing the selected service and applicable licence terms
AWS RDS or Aurora for PostgreSQLNo PostgreSQL licence fee; AWS service charges applyAWS, UK region available (eu-west-2 London)Teams already on AWS wanting a fully managed databaseConversion work depends on the codebase; EPAS compatibility requires a separate EPAS deployment
Azure Database for PostgreSQL Flexible ServerNo PostgreSQL licence fee; Azure service charges applyAzure, UK region available (UK South)Teams already on Microsoft AzureZone redundancy doubles the compute cost shown here
EDB Postgres Advanced Server / EDB Postgres AIPostgreSQL free; EDB subscription on topEPAS deployment or EDB's cloud service using AWS, Azure or Google CloudLarge PL/SQL estates that need Oracle-compatible features to reduce rewritingAdds a commercial subscription that must be included in the comparison
Self-managed community PostgreSQLNoneOwn servers or any cloud VMTeams with strong in-house PostgreSQL DBA skills wanting full controlYou own patching, backup, HA and on-call unless you buy support

No option here is universally right. A UK enterprise with a modest PL/SQL footprint and a mature AWS or Azure estate has a straightforward case for assessing RDS or Flexible Server. A UK enterprise with a large, RAC-dependent, deeply PL/SQL estate may find EDB Postgres Advanced Server, or simply staying on Oracle in OCI under BYOL terms, the lower-risk route this year, even though it defers the licensing saving.

Questions to Put to Any Supplier Before You Commit

  • What percentage of our actual schema converts automatically with your tooling, based on a real assessment report against our database, not a generic industry figure?
  • What specifically in our PL/SQL codebase will need manual rewriting, and can you quantify it in person-days rather than a percentage?
  • What does Multi-AZ, or zone-redundant, configuration cost for the instance size we actually need, including storage, IOPS, throughput, data transfer, monitoring and extended-version support?
  • If we choose EDB Postgres Advanced Server or another commercial Postgres distribution, what does the support subscription cost per year, and what happens if we later want to move off it?
  • What is the realistic cutover window, and what does a rollback plan look like if application testing finds a blocking incompatibility?
  • If we stay with Oracle, what does a Base Database Service or BYOL arrangement in OCI actually cost against our current on-premises licence, actual support renewal quote and infrastructure?

Editorial Analysis

The economics can favour leaving Oracle for a UK enterprise whose annual support bill is large relative to the cost of converting and testing its applications. In this worked example, £78,389 in first-year Oracle support at list prices compares with £32,792 annually for the selected AWS Multi-AZ compute and storage configuration, or 41.8% of the first-year support figure. That gap justifies an assessment, but does not establish equivalent capacity or a full migration business case; an existing deployment must use its actual renewal quote to assess recurring savings. Migration risk sits in application behaviour as well as schema conversion, including PL/SQL packages, triggers and autonomous transactions. A UK enterprise should size the remaining conversion work and validate target performance with its own assessment and application tests before setting a migration date against a licence renewal.

Sources

Data & Insights

Oracle first-year support and annual managed PostgreSQL costs in GBP

Oracle first-year support at list prices, AWS annual compute and storage, and Azure annual compute only are different cost scopes and do not establish equivalent workload capacity or an existing Oracle deployment's renewal cost.

Oracle first-year support and annual managed PostgreSQL costs in GBPOracle first-year support at list prices, AWS annual compute and storage, and Azure annual compute only are different cost scopes and do not establish equivalent workload capacity or an existing Oracle deployment's renewal cost.£0.00£20,000.00£40,000.00£60,000.00£80,000.00Oracle EE + Partitioning first-year supportOracle EE + Par…AWS RDS PostgreSQL Multi-AZ annual compute + 2 TB storageAWS RDS Postgre…Azure Flexible Server annual single-instance compute onlyAzure Flexible …Oracle EE + Partitioning first-year support, Cost for one year (GBP): £78,389.00AWS RDS PostgreSQL Multi-AZ annual compute + 2 TB storage, Cost for one year (GBP): £32,792.00Azure Flexible Server annual single-instance compute only, Cost for one year (GBP): £10,898.00
View the data
Oracle first-year support and annual managed PostgreSQL costs in GBP
CategoryCost for one year (GBP)
Oracle EE + Partitioning first-year support£78,389.00
AWS RDS PostgreSQL Multi-AZ annual compute + 2 TB storage£32,792.00
Azure Flexible Server annual single-instance compute only£10,898.00
Source: Oracle Technology Global Price List; AWS RDS for PostgreSQL pricing; Azure Database for PostgreSQL Flexible Server pricing; ECB reference rate 29 September 2026

Oracle first-year support by component in the 16-core example

The £78,389 first-year Oracle support figure at list prices splits between Enterprise Edition and Partitioning before any other options are added.

Oracle first-year support by component in the 16-core exampleThe £78,389 first-year Oracle support figure at list prices splits between Enterprise Edition and Partitioning before any other options are added.Enterprise Edition first-year support£63,110.00 (80.5%)Partitioning first-year support£15,279.00 (19.5%)
View the data
Oracle first-year support by component in the 16-core example
CategoryFirst-year support (GBP)
Enterprise Edition first-year support£63,110.00
Partitioning first-year support£15,279.00
Source: Oracle Technology Global Price List, 15 September 2026; ECB reference rate 29 September 2026

Frequently Asked Questions

Does moving to managed PostgreSQL remove Oracle's licence fee completely?

PostgreSQL itself carries no per-core or per-user licence fee under the PostgreSQL Licence. Moving a workload does not by itself establish which existing Oracle payments can end; that depends on the remaining estate and contractual commitments. You still pay managed-service charges, including applicable compute, storage, data transfer, IOPS, throughput, monitoring and extended-version support, plus any separate commercial support subscription.

Is PL/SQL code fully compatible with PostgreSQL?

No, but manual rewriting is not universally required. Tools such as Ora2Pg automate some conversion, including autonomous-transaction wrappers, while the remaining work depends on the constructs and target service. EDB Postgres Advanced Server supplies additional Oracle-compatible features through a separate EPAS deployment.

How long does a typical Oracle to PostgreSQL migration take for a UK enterprise?

The duration depends on code complexity, data volume and testing requirements. Devopsity publishes estimates of 4-8 weeks for simple databases below 100 GB and up to 12 months for complex enterprise work, with project-cost bands ranging from €23,000 to €700,000 across those categories (migration project estimates). These are one consultancy's estimates, not vendor-published timelines or a substitute for your own schema assessment.

Do we need Multi-AZ or zone-redundant PostgreSQL to match what Oracle Data Guard gave us?

Assess the target against your actual availability, recovery and standby requirements rather than assuming the configurations are equivalent. AWS RDS Multi-AZ with one standby and Azure zone-redundant high availability add a second instance, with compute costing approximately twice the single-instance rate in these examples. AWS Multi-AZ gp3 storage also costs twice the Single-AZ rate shown here, so include storage as well as compute.

Can we keep using Oracle Database but reduce our costs without migrating engines?

Oracle's Base Database Service on Oracle Cloud Infrastructure offers consumption-based ECPU pricing, with software and support included or Bring-Your-Own-Licence terms for existing licences. It provides an alternative to owned hardware without changing the database engine. Whether it reduces your costs depends on the service configuration, eligible licences and current infrastructure bill.

Should we trust a migration consultancy's TCO model over our own numbers?

Use it for planning ranges only. Price your own core count, options and instance sizes against Oracle's published price list and AWS's or Azure's published pricing pages, using your actual Oracle renewal quote for an existing deployment because the published support prices cover the first year only. Then treat any consultancy's percentage or person-month estimate as a sense check on your own numbers, not a substitute for them.