← All recipes
Moderne licensed

Convert SQL data type

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

When migrating between SQL dialects, data types often need to be converted. For example, Oracle's VARCHAR2 can be replaced with Postgres VARCHAR, or NUMBER with NUMERIC.

Single recipeProprietary

Usage

You’ll need the Moderne CLI configured before running the command below.

mod run . --recipe org.openrewrite.sql.ConvertDataType --recipe-option "oldDataType=VARCHAR2" --recipe-option "newDataType=VARCHAR"

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

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

Options

NameTypeDescription
oldDataTyperequiredStringThe data type to find and replace, case insensitive.
e.g. VARCHAR2
newDataTyperequiredStringThe new data type to use as replacement.
e.g. VARCHAR

Data tables

Structured output this recipe can produce.

  • 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