← All recipes
Moderne licensed

Convert SQL Server functions to PostgreSQL

Recipe IDorg.openrewrite.sql.ConvertSqlServerFunctionsToPostgres
Artifactorg.openrewrite.recipe:rewrite-sql

Replaces SQL Server-specific functions with PostgreSQL equivalents.

Composite recipesqlserverpostgresqlmssqlsqlProprietary

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.ConvertSqlServerFunctionsToPostgres

If the recipe isn’t available locally, install it with:

mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1

Definition

This recipe runs the following recipes in order.

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