Amazon Q Developer now transforms embedded SQL from Oracle to PostgreSQL
News
Amazon Q Developer now offers an advanced feature to automatically convert embedded SQL from Oracle to PostgreSQL during database migration projects.
- Utilizes metadata from AWS Database Migration Service (DMS) Schema Conversion
- Automatically detects and transforms Oracle SQL statements to PostgreSQL-compatible code
- Enables developers to review and accept proposed SQL conversions
- Provides a summary of transformation and recommended next steps
- Currently supported in Visual Studio Code and IntelliJ IDEs
This capability simplifies database migration by automating complex SQL conversion processes, reducing manual effort and potential errors in code transformation.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Apr 7
2025
2025
Converting embedded SQL in Java applications with Amazon Q Developer
Dec 3
2024
2024
Amazon Q Developer transformation capabilities for mainframe modernization are now available (Preview)
Aug 6
2025
2025
Automate conversion of Oracle SQL to PostgreSQL inside Java applications with AWS SCT
Jun 8
2026
2026
Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.