Migrate Oracle SQL to PostgreSQL
Recipe ID
org.openrewrite.sql.MigrateOracleToPostgresArtifact
org.openrewrite.recipe:rewrite-sqlConverts Oracle-specific SQL syntax and functions to PostgreSQL equivalents.
Usage
This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.
mod run . --recipe org.openrewrite.sql.MigrateOracleToPostgresIf the recipe isn’t available locally, install it with:
mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1Definition
This recipe runs the following recipes in order.
- Convert Oracle functions to PostgreSQL
org.openrewrite.sql.ConvertOracleFunctionsToPostgres - Convert Oracle data types to PostgreSQL
org.openrewrite.sql.ConvertOracleDataTypesToPostgres - Format SQL in string text blocks
org.openrewrite.sql.FormatSql
Data tables
Structured output this recipe can produce.
- SQL queriesShows matching SQL queries.
org.openrewrite.sql.table.DatabaseQueries - SQL functions in useShows matching SQL functions and the queries that contain them.
org.openrewrite.sql.table.DatabaseFunctions - Source files that had resultsSource files that were modified by the recipe run.
org.openrewrite.table.SourcesFileResults - Source files that had search resultsSearch results that were found during the recipe run.
org.openrewrite.table.SearchResults - Source files that errored on a recipeThe details of all errors produced by a recipe run.
org.openrewrite.table.SourcesFileErrors - Recipe performanceStatistics used in analyzing the performance of recipes.
org.openrewrite.table.RecipeRunStats