Convert Oracle schemas to Azure Database for PostgreSQL by using AI

  • Module
  • 8 Units
Intermediate
Database Administrator
Data Engineer
Azure Database for PostgreSQL

Learn how to plan, run, validate, and finalize an AI-assisted Oracle-to-PostgreSQL schema conversion using the Visual Studio Code PostgreSQL extension, Microsoft Foundry, and GitHub Copilot agent mode.

Learning objectives

By the end of this module, you're able to:

  • Describe how the AI-powered schema conversion pipeline works and identify the role of each component.
  • Prepare the Oracle source, Azure Database for PostgreSQL flexible server, and Microsoft Foundry for a schema conversion.
  • Run an end-to-end schema conversion using the Migration Wizard and interpret the conversion report.
  • Triage and resolve review tasks by criticality using GitHub Copilot agent mode or manual edits.
  • Plan around unsupported Oracle objects and apply best practices before deploying converted PostgreSQL artifacts.

Prerequisites

  • Familiarity with relational database schema objects in Oracle and PostgreSQL.
  • Experience creating resources in the Azure portal.
  • Basic experience with Visual Studio Code.
Start