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

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: linkedin.com/company/azure-database-for-postgresql Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure