PostgreSQL on Azure: Faster Oracle Migration

Introduction

Organizations running legacy Oracle databases are under pressure to reduce costs, improve performance, and modernize without disrupting critical applications. Microsoft’s latest Azure update positions PostgreSQL as a core modernization path, combining migration tooling, enterprise-grade security, and new scale options for demanding workloads.

What’s new

Azure Database for PostgreSQL enhancements

Microsoft is continuing to invest in Azure Database for PostgreSQL as an enterprise-ready platform for production workloads. Key capabilities highlighted include:

• v6-series compute SKUs scaling up to 192 vCores
• Elastic clusters with Citus for horizontal scale across distributed PostgreSQL nodes
• SSD v2 storage for higher IOPS and lower latency
• Azure Monitor integration for performance monitoring and tuning
• Security features such as Microsoft Defender for Cloud, Entra ID integration, private endpoints, confidential compute, and encryption

AI-assisted Oracle migration tool in preview

A major announcement is the AI-assisted Oracle-to-PostgreSQL migration tool, now in preview in the PostgreSQL extension for Visual Studio Code.

According to Microsoft, the tool can:

• Analyze and convert Oracle schemas and stored procedures
• Update Java and .NET application code for PostgreSQL compatibility
• Rewrite SQL queries and stored procedure calls
• Generate unit tests and run validation in a scratch PostgreSQL environment
• Provide side-by-side comparisons and migration reports

The tool uses GitHub Copilot and a multi-agent AI approach to reduce manual rework and lower migration risk.

Azure HorizonDB enters private preview

Microsoft also introduced Azure HorizonDB, a new cloud-native PostgreSQL service for very large-scale workloads. In private preview, it supports:

• Up to 3,072 vCores
• Up to 128 TB of auto-scaling storage
• Sub-millisecond multi-zone commit latencies
• Up to 3x higher throughput than self-managed PostgreSQL

Why this matters for IT teams

For administrators and architects, this announcement is significant because it addresses both sides of modernization: migration complexity and post-migration performance. Teams moving off Oracle often face compatibility concerns, downtime risk, and skills gaps. Microsoft is trying to reduce those barriers with embedded AI tooling and managed PostgreSQL services on Azure.

The customer example from Apollo Hospitals shows the potential business impact, including 60% lower operational costs, 3x better system performance, and improved deployment speed after migrating from Oracle to Azure Database for PostgreSQL.

Next steps

IT leaders evaluating database modernization should:

• Review Oracle-dependent applications for PostgreSQL migration readiness
• Test the AI-assisted migration tool in preview for schema and code conversion scenarios
• Assess whether Azure Database for PostgreSQL meets current workload needs
• Track Azure HorizonDB if ultra-large PostgreSQL scale is a future requirement

For organizations planning an Oracle exit strategy, Microsoft is making PostgreSQL on Azure a much more compelling option.