Modernize Databases for the Cloud

Sandra Ahlgrimm walks through migrating a Java application's database from Oracle DB to PostgreSQL, using GitHub Copilot and the GitHub Copilot app modernization extension inside IntelliJ.

Overview

The episode shows a database migration as more than a schema swap: the Java application needs dependency updates, configuration changes, and behavior verification.

What the episode covers

• Migrating a Java application's database from Oracle DB to PostgreSQL using GitHub Copilot.
• Using the GitHub Copilot app modernization extension in IntelliJ.
  • Installed via IntelliJ plugins or the ACPI registry.
• Using Copilot in agent mode to:
  • Analyze the project
  • Identify dependencies
  • Set up the environment
• Catching and fixing issues during setup (examples mentioned):
  • Date format problems
  • README corrections
• Running a built-in database migration task to update:
  • Dependencies
  • Configuration
  • Function calls
• Manually verifying application behavior before and after the migration.

Series context and resources

• Part of the Modernize Java Apps with AI series (Episode 4 of 9).
• Playlist: https://www.youtube.com/playlist?list=PLlrxD0HtieHhaBJWlcxGd-kTDikSD4xyD
• GitHub Copilot Modernization extension: https://aka.ms/GHCPMod-Java
• Sample repo: https://github.com/Azure-Samples/java-migration-copilot-samples