Episode

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

with Scott Hanselman, Jonathon Frost

Azure Friday

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

Connect

Azure

Have feedback? Submit an issue here.