Generally Available: Oracle schema conversion to Azure PostgreSQL in Visual Studio Code

You can now convert Oracle database schema objects to Azure Database for PostgreSQL-compatible schema directly in the PostgreSQL extension for Visual Studio Code. The experience provides a project-based workflow for Oracle to Microsoft for PostgreSQL offerings, using Azure Database for PostgreSQL flexible server as a scratch database for validation and testing during schema conversion. The workflow automatically flags items that can't be converted as Review Tasks, so you can address them before applying the generated artifacts.

With this release, you can move schema conversion into a guided Visual Studio Code experience instead of managing the process across separate tools. You can load Oracle schemas, run conversion, validate converted objects, review flagged items, and then apply the generated PostgreSQL artifacts with more visibility into what was converted and what still needs attention.

Learn more.