translateSqlFile: Translate a SQL file

In hxia/SqlRender4Impala: Rendering Parameterized SQL and Translation to Dialects

Description

This function takes SQL and translates it to a different dialect.

Usage

translateSqlFile(sourceFile, targetFile, sourceDialect = "sql server",
  targetDialect = "oracle", oracleTempSchema = NULL)

Arguments

sourceFile	The source SQL file
targetFile	The target SQL file
sourceDialect	The source dialect. Currently, only 'sql server' for Microsoft SQL Server is supported
targetDialect	The target dialect. Currently 'oracle', 'postgresql', and 'redshift' are supported
oracleTempSchema	A schema that can be used to create temp tables in when using Oracle.

Details

This function takes SQL and translates it to a different dialect.

Examples

## Not run: 
translateSqlFile("myRenderedStatement.sql",
                 "myTranslatedStatement.sql",
                 targetDialect = "postgresql")

## End(Not run)

hxia/SqlRender4Impala documentation built on May 17, 2019, 9:15 p.m.