2021
Details about the releases of Snowflake SnowConvert for Oracle during 2021.
Release 1.0.37 - December 22nd, 2021
SnowConvert Core 3.2.14
Added:
Improved functional equivalence testing for Inner & Equi join.
Fixes and Improvements:
Improved assessment reports when there are no identified objects.
Fixed case for TO_DATE function with numeric input parameter.
Improved backslash handling in REGEXP function.
Release 1.0.3 - December 7th, 2021
SnowConvert Core 3.1.43
Added:
Improved limited access documentation by implementing the new translation specification pages for:
Join
Band Join.
Inner Join.
Data types
Character Data types
Numeric Data types
Long Data type
Datetime and Interval Data types
Raw and Long Data types
LOB Data types
JSON Data type
Extended Data types
Rowid Data Type
ANSI Data Types
User-Defined Types
Any Types
Spatial Types
Fixes and Improvements:
Improved transformation for cumulative statements in window functions.
Fixed calls of procedures and functions inside packages.
Release 1.0.2 - November 22nd, 2021
SnowConvert Core 3.1.24
Added:
Improved limited access documentation by implementing the new translation specification pages:
Outer Join.
Anti Join.
Self Join.
Semi Join.
Equijoin.
Cartesian Products.
Added EWI1066 to inform that some operations between Number datatypes may not be functional in the output code.
Fixes and Improvements:
Fixed inconsistency for procedure naming calls within package outputs.
Fixed implicit schemas not being added to procedure calls.
Release 1.0.1 - November 8th, 2021
SnowConvert Core 3.1.20
Fixes and Improvements:
Improve parsing recovery when there is not semicolon at the end of the statements.
Parsing error missing EWI for package item list declarations.
Fixing error related to translation of Date arithmetic operations with "+" and "-" signs.
Fixing error related to blank or empty strings in REPLACE and CONCAT built in functions.
Fixed Procedure numeric precision inconsistency.
Fixing inconsistency in procedure naming for package outputs.
Release 1.0.0 - October 26th, 2021
SnowConvert Core 3.1.12
Added:
Generation of HTML report for the conversion Assessment.
Conversion rate for objects in the Assessment report.
Information for Custom types in the Assessment report and the Top-level objects report.
TRUNC_UDF is now being used to transform TRUNC function.
Fixes and Improvements:
Updated colors in the Assessment report.
Updated views that depend on tables with Custom Types.
Aliases used in INSERT statements are now being removed.
Statement ALTER TABLE ... RENAME TO ... is no longer being marked as invalid.
Fixed consistency for types used in NVL function.
Synonyms referenced inside procedures and functions are now being converted to the referenced object.
Identifiers with the character '#' no longer cause procedures with empty bodies.
Fixed some cases in which procedures and functions were being generated with an empty body and add details to possible conversion errors inside procedural code.
Release 0.8.15 - October 12th, 2021
SnowConvert Core 3.1.10
Added:
Improve granularity for "CREATE TYPE" EWI messages
Implement Views mechanism for querying DDL elements with Types
Replace Type usage in DDL by Variants
Fixes and Improvements:
Fix for "CREATE SEQUENCE" with NOPARTITION keyword
Fix for "Large" number in store procedures
Added EWIs for known functional differences in Non-Ansi Outer Join syntax
Fixed Blank values in Oracle interpreted differently in Snowflake
Increased grammar coverage on Packages
Release 0.8.14 - September 28th, 2021
SnowConvert Core 3.1.8
Added:
Initial parsing of CREATE TYPE (heading, Options Structure, Object Structure, Varray and nested TABLE structure)
Parsing and transformation of Oracle Literals with 'q' operator parsing and transformation
New Logo for SnowConvert and minor UI update (some colors changed). New images are displayed in the Using SnowConvert section.
Fixes and Improvements:
Fixed parsing error where ARRAY was not recognized as DATA TYPE
Fixed issue with date formats inside procedures and functions when DATE_INPUT_FORMAT was changed (JSDATE_UDF added).
Fixed inconsistences reporting warnings 'missing dependencies' (EWI1022)
Fixed problem with not equal operator precedence in JavaScript
Oracle Outer Join (+) is no longer being transformed to ANSI OUTER JOIN. Syntax with (+) is supported by Snowflake.
Release 0.8.13 - September 16th, 2021
SnowConvert Core 3.1.5
Added:
Implementation for Execute Immediate Into Record.
Transformation for cursor ROWTYPE property.
ROWTYPE helper.
Disclaimer for total parsing errors and unrecognized objects on Assessment.docx report.
EWIs (MSCEWI1051, MSCEWI1052, MSCEWI1053) for unsupported datatypes on Stored Procedures and Functions parameters.
EWI (MSCEWI3079) for Occurrence parameter in INSTR function.
Fixes and Improvements:
Comment is emitted correctly for EWI1040.
Reduced several parsing errors.
Reduced several conversion errors.
Improved Cursor helper for RECORDS.
EXEC call is also commented out when the statement inside is commented.
Multiple duplicated helpers emitted in the same procedure when there is an input error.
Fixed mismatch in parsing errors counting, between Assessment report and Issues report.
Fixed Top level Objects report showing 100% conversion rate when there were parsing errors.
Release 0.8.11 - September 1st, 2021
SnowConvert Core 3.1.1
Added:
EXEC is now used inside cursors.
Sequences are now being created with the "OR REPLACE" keyword.
Functions and procedures inside packages are now added to the top level object report.
Transformation for SQL built-in functions with Snowflake counterpart (functional equivalence may vary).
Fixes and Improvements:
Improved transformation for NULL values inside PL/SQL.
Some MSCEWI1037 "Translation planned for the future" were replaced with more informative EWIs.
Warning count in Assessment.csv was different from warning occurrences in output code.
BINARY_FLOAT datatype is converted to FLOAT.
FLOAT column datatype is no longer reported as error.
Oracle attributes like SQL%ROWCOUNT, SQLERRM or SQLCODE are binded correctly.
Fixed error with column names using '<' or '>'.
Fixed error that reported 99% objects conversion.
Reduced conversion errors.
Release 0.8.9 - August 16th, 2021
SnowConvert Core 3.1.0
Added:
Transformation for records inside procedures.
Fixed:
Fixed code of EXEC helper when handling records.
Improve parsing recovery for PACKAGES declaration.
Fixed transformation for PACKAGE constants values that are used inside procedures.
Release 0.8.8 - August 4th, 2021
SnowConvert Core 3.0.22
Added:
New Assessment.docx aspect.
Transformation for LIKE operator inside procedures.
Regions for procedure helpers.
New assessment section for procedures and functions inside packages.
Fixed:
Sequences with start values over the Snowflake limits are now being marked and reported.
Enhanced JavaScript comments for better highlighting.
Sequence NEXTVAL is now being supported.
ALTER TABLE transformation fixed to be deployable.
Enhanced transformation for TO_CHAR with Julian format parameter.
Duplicated variables appearing inside procedures.
Release 0.8.7 - July 20th, 2021
SnowConvert Core 3.0.20
Added:
Transformation for CONNECT BY clause in a SELECT query.
Transformation for SELECT with ROW LIMITING CLAUSE.
Transformation for raise_application_error.
Option in the UI to select the encoding when performing a migration.
MSC-ISSUE was renamed to MSC-ERROR in all the reports and output code
Fixed:
Inconsistencies with the conversion rate in the Top Level Object Report.
Error with date arithmetic operations.
Issues in the transformation of the TO_CHAR function first parameter.
Handling for the NLS_CALENDAR parameter when is set to GREGORIAN in the TO_DATE function.
Release 0.8.6 - July 8th, 2021
SnowConvert Core 3.0.19
Fixed:
Issues reporting errors when converting EXECUTE INMEDIATE statements.
Fix for some procedures with bodies not being generated.
Release 0.8.5 - July 7th, 2021
SnowConvert Core 3.0.16
Added:
Transformation for variables in stateful packages
Transformation for RECORD TYPES in stored procedures
Transformation for LAG function
Transformation for ALTER SESSION when modifying the NLS_NUMERIC_CHARACTERS session parameter