2022
Details about the releases of Snowflake SnowConvert for Oracle during 2022.
Last updated
Details about the releases of Snowflake SnowConvert for Oracle during 2022.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Recognize some FORALL patterns.
Translation Specification of FORALL patterns.
Add casting when accessing DATE and TIMESTAMP fields in objects.
Fix duplicated constants in functions/procedures inside packages.
Fix transformation for INSERT with a record value
Fix some conversion errors.
Generate object breakdown section in HTML Conversion Report.
Transform the Parameterized Cursor declaration.
Transform the OPEN statement of parameterized cursors.
Fix function is not recognized when it is a Synonym.
Support new cases of MATERIALIZED VIEWS.
Footer added to HTML Conversion Report.
File breakdown added HTML Conversion Report.
Fix duplicated comments in package elements when there are parsing errors.
Fix deployment error when mixing named and positional parameters in procedure calls.
Fix transformation of date operations inside procedures.
Generate issues breakdown section in HTML Conversion Report.
Generate overall conversion summary section in HTML Conversion Report.
Transform the Empty RETURN statement in Procedures to Snowflake Scripting.
Support for SELECT INTO record clause to Snowflake Scripting.
Provide additional execution information step for pre-processing.
Change the RETURN statement when there are output parameters in Procedures to Snowflake Scripting.
Fix some cases for files not generated.
Fix for procedure calls inside functions with None schema.
Add EWI message to declaration and usages of the built-in packages composite data types.
Initial transformation for MATERIALIZED VIEWS.
Constraints modifiers removed in NOT NULL constraints.
Improve EWI description for Create Database Link.
Fix transformation for packages with None as schema
Remove duplicated semicolons in some commented statements
Support for default parameters in procedures.
Support for package variables as an output argument in procedures.
Initial Assessment reporting for Materialized Views.
Fixed parsing of some table properties.
Provide UI and CLI options to activate the arrange
Fix transformation for procedure calls inside packages.
Fixed parsing error in USING INDEX LOCAL clause.
Fix of conversion errors.
Improve EWI description and transformation for DBLink (database Link) Reference.
General assessment infrastructure improvements.
Now the default target language for procedures is set to Snowflake Scripting. Javascript can still be selected in the settings.
Better description and distribution for custom naming configuration.
Fixed an issue when the package name was qualified with the schema name.
Improvement in symbols loading which leads to a migration time reduction.
NLS_INITCAP function was being marked as not supported.
TO_CHAR(date, 'WW') was not giving an equivalent result.
Support for built-in package UTL_FILE.FOPEN, UTL_FILE.PUT_LINE, UTL_FILE.FCLOSE.
GROUP BY ROLLUP function was being marked as not supported.
REVERSE function was being marked as not supported.
Fixed an exception caused by output parameters transformation.
Fixed an exception causing files not to be transformed when migrating packages to Snowflake Scripting.
Some built-in packages were not being marked as not supported.
Support for built-in package function DBMS_LOB.SUBSTR.
Procedures and functions inside packages are converted to Snowflake Scripting when the setting is on.
Constants declared inside packages, are being declared inside each procedure or function that uses them in Snowflake Scripting.
HTML report improvements.
RATIO TO REPORT function was being marked as not supported.
CONNECT BY PRIOR was being partially marked as an error.
TO_CHAR(<date>, 'D') was not migrated properly.
SUPPLEMENTAL LOGGING clause removed from tables.
Fixed indentation with procedure calls in Snowflake Scripting.
Functions that migrate to procedures are now being converted to Snowflake Scripting when indicated.
Support for OUT parameters in procedures to Snowflake Scripting.
Change EULA file to a new and updated version.
Fixed a parsing error when the DEFAULT keyword was used in an assignment inside a procedure.
Fix transformation for numeric placeholders being used in procedures.
Provide a hybrid approach for the TRUNC built-in function translation.
DATEDIFF and DATEADD UDF improvement
Fix operation of NumToDsInterval + date
Convert Date data type depending on its default value
General improvements on the Pretty Print performance and output code
Added
Add support for INTERVAL in arithmetic operations.
Support DBMS_OUTPUT.PUT_LINE for Javascript and Snowflake Scripting.
Fixes and Improvements:
Some unsupported data types were not being handled.
EWI3004 added when DBLink is referenced, now contains the removed syntax.
TRUNC and ROUND functions as operators in arithmetic operations are now being handled properly.
Added
Support for DBMS_RANDOM.VALUE function.
Fixes and Improvements:
Fixes in function calls.
Added
Conversion of NUMTODSINTERVAL.
SYSDATE assignment to variables.
Fixes and Improvements:
Fixes in HTML report.
Fixes and Improvements:
Fix function call without parenthesis for JS procedures and packages.
CONTAINS function was causing parsing error.
Added MSCEWI 3111 with information for manual migration of COMMIT and ROLLBACK statements.
Fixes and Improvements:
Fix of conversion errors.
Improved MSCEWI 3076 to contain the built-in package name.
Added missing FROM keyword to DELETE statements.
Fix syntax errors due to spaces between compound operators.
Added:
Add UnrecognizedElementsLOC to Assessment.docx and Assessment.csv
Fixes and Improvements:
Fix of conversion errors.
Improved performance of SnowConvert-generated UDF Helpers
Added:
Map BFILE data type to VARCHAR and custom UDF added when inserting values to transformed BFILE columns.
Glossary section of the main concepts in the Assessment.docx report.
Added 2 precision decimals to the conversion rates of the assessment reports to improve precision.
Fixes and Improvements:
Comment out collection variables usages in Javascript stores procedures.
Empty object names in the Top-level objects report.
Added:
Top level query report.
Fixes and Improvements:
Improve readability on EWI 1036
Fix JSON data type, now it is transformed to variant
Fix case where comments were being lost at the end of the statements
Fix case where identifiers with double quotes where being transformed incorrectly
Fix Hyperlink for the release notes.
Improved Integration testing for:
Outer Join
Added:
New EWI when trying to select ROWID pseudocolumn.
Fixes and Improvements:
Removal of numeric literal suffixes like "d" and "f" (double and float) since this is not supported in Snowflake.
Fix transformation for Timestamp data type declarations
Fix transformation for Long Raw data type columns
Fix Using (+) operator with a column from a not-joined table and a literal expression
Fix Outer Join with (+) IN predicate when being transformed to ANSI
Fix NUMBER data type scale can not be greater than precision
Fix Transformation of ANYDATA to VARIANT
Fix transformation for Interval expressions
Fix XMLType, where it should be converted to Variant
Improved functional equivalence testing for:
Timestamp with time zone Data Type
Timestamp with Local time zone Data Type
FLOAT Data Type
NUMBER Data Type
BINARY_FLOAT Data Type
BINARY_DOUBLE Data Type
Improved Integration testing for:
ANYDATA Data Type
ANYTYPE Data Type
ANYDATASET Data Type
Timestamp with time zone Data Type
Timestamp with Local time zone Data Type
BINARY_DOUBLE Data Type
BINARY_FLOAT Data Type
NUMBER Data Type
FLOAT Data Type
ROWID pseudocolumn
Added:
Improved functional equivalence testing for:
Inner
Equijoin
Band join
Self Join
Semijoin
Cartesian Product
Improved functional equivalence testing for:
Long
Equijoin
Raw
ROWID
CLOB
NCLOB
BLOB
BFILE
CHAR
VARCHAR2
NCHAR
NVARCHAR2
Timestamp
Date
Interval Day to Second
Interval Year to Month
Transformation added for LENGTHB function.
Warning added when NUMBER scale is negative.
Transformation for NATIONAL CHARACTER - CHAR Data type.
Transformation for NATIONAL CHARACTER - CHAR VARYING Data type.
Fixes and Improvements:
Improved parsing for ANYTYPES Data types.
are now being marked as not supported.
All the unsupported syntax is being marked with or with
Hierarchy-oriented naming in the ObjectDB column of the Top-level objects report and Top-level queries report.
NUMBER default precision - scale changed from (38,19) to (38,18) to decrease inconsistencies in binary operations.