Oracle Conversion Settings
Last updated
Last updated
Transform Synonyms: Flag to indicate whether or not Synonyms should be transformed. By default, it's set to true.
Transform Packages to new Schemas: Flag to indicate whether or not the Packages should be transformed to new Schemas.
Please check the naming of the procedure enabling and disabling the flag:
Transform Date as Timestamp:
Flag to indicate whether SYSDATE
should be transformed into CURRENT_DATE
or CURRENT_TIMESTAMP
. This will also affect all DATE
columns that will be transformed to TIMESTAMP
.
Transform OUTER JOINS to ANSI Syntax: Flag to indicate whether Outer Joins should be transformed to only ANSI syntax.
Data Conversion Types: You can upload a JSON file below to define specific data types considering data type origin and column name.
Comment objects with missing dependencies: This flag indicates whether the user wants to comment on nodes with missing dependencies.
Schema: The string value specifies the custom schema name to apply. If not specified, the original database name will be used. Example: DB1.myCustomSchema.Table1.
Database: The string value specifies the custom database name to apply. Example: MyCustomDB.PUBLIC.Table1.
Default: None of the above settings will be used in the object names.
Prepare my code: Flag to indicate whether the input code should be processed before parsing and transformation.
On this page, you can choose whether stored procedures are migrated to JavaScript embedded in Snow SQL, or to Snowflake Scripting. The default option is Snowflake Scripting.
Reset Settings: The reset settings option appears on every page. If you've made changes, you can reset SnowConvert to its original default settings.
Set encoding of the input files: Check for more details.
To review the Settings that apply to all supported languages, go to the following .
On this page, you can choose whether the successfully converted code percentage is calculated using lines of code or using the total number of characters. The character conversion rate is the default option. You can read the entire rate documentation on the.