Migrate Oracle Workloads to PostgreSQL Using AI-Powered Tools in the VS Code PostgreSQL Extension

About this episode

Scott Hanselman discusses AI-powered migration tools for moving Oracle workloads to PostgreSQL with Jonathon Frost.

This week on Azure Friday, Scott Hanselman talks with Jonathon Frost about AI-enhanced migration from Oracle to PostgreSQL using the VS Code PostgreSQL extension. See how developers can automate schema conversion, transform application code, and validate results using an intelligent, agent-driven workflow. Chapters 00:00 - Introduction 00:36 - Model Hyperparameter Tuning, Agent Orchestration, and Determinism 02:25 - Architectural Overview of AI-enhanced Schema Migration 04:28 - How it is Built on the VS Code Extension for PostgreSQL 04:56 - Self-correction of AI-enhanced Migration 05:59 - Migration Demo 06:33 - Connect to Oracle Database 07:23 - Connect to PostgreSQL Database 07:50 - Connect to Azure OpenAI Endpoint 08:45 - Run Migration 09:37 - Review Completed Migration Report 11:07 - Visualize Schema of PostgreSQL Database 12:17 - Side-by-side File Diff 13:30 - Where to get the Extension and Learn More Recommended resources Learn Docs VS Code Extension Marketplace Page Azure Product Page Blog Connect Scott Hanselman | Twitter/X: @SHanselman Jonathon Frost | LinkedIn: linkedin.com/in/jjfrost Azure Database for PostgreSQL | LinkedIn…

People in this episode

Host: Scott Hanselman

Guest: Jonathon Frost

Topics covered

• AI-enhanced migration
• Oracle to PostgreSQL
• VS Code PostgreSQL extension
• schema conversion
• application code transformation
• migration validation

Keywords

• migration
• AI tools
• PostgreSQL extension
• schema migration
• database connection
• Azure OpenAI

Mentioned in this episode

Organizations: Azure, Oracle, PostgreSQL, VS Code, Azure Database for PostgreSQL

More episodes of Azure Friday

• New file share centric management model for Azure Files · June 3, 2026
• Anyscale on Azure: Scale Python AI workloads with managed Ray on AKS · June 2, 2026
• Azure MCP and Azure Skills · May 8, 2026
• Azure SRE Agent: End to end agentic operations platform for any kind of toil and at enterprise scale · April 24, 2026
• Migrate Oracle Workloads to Oracle AI Database@Azure · April 17, 2026
• Next gen General Purpose in Azure SQL Managed Instance - what it is and why it’s faster · April 3, 2026