Translate a SQL file
This function takes SQL and translates it to a different dialect.
translateSqlFile(
sourceFile,
targetFile,
targetDialect,
tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"),
oracleTempSchema = NULL
)sourceFile |
The source SQL file |
targetFile |
The target SQL file |
targetDialect |
The target dialect. Currently "oracle", "postgresql", "pdw", "impala", "sqlite", "netezza", "bigquery", and "redshift" are supported. |
tempEmulationSchema |
Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created. |
oracleTempSchema |
DEPRECATED: use |
This function takes SQL and translates it to a different dialect.
## Not run:
translateSqlFile("myRenderedStatement.sql",
"myTranslatedStatement.sql",
targetDialect = "postgresql")
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.