translateSqlFile: Translate a SQL file

Description Usage Arguments Details Examples

Description

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

Usage

1
2
translateSqlFile(sourceFile, targetFile, targetDialect,
  oracleTempSchema = NULL)

Arguments

sourceFile

The source SQL file

targetFile

The target SQL file

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

1
2
3
4
5
6
## Not run: 
translateSqlFile("myRenderedStatement.sql",
                 "myTranslatedStatement.sql",
                 targetDialect = "postgresql")

## End(Not run)

kganilkg131/SQLCon documentation built on May 23, 2019, 12:51 a.m.