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

Fixed:

  • Lines of code counting for wrapped statements

  • Inconsistencies with untranslated statements in stored procedures and functions

  • Issues migrating CURSOR FOR LOOP statements

  • Fix for some stability issues

Release 0.8.3 - June 28th, 2021

SnowConvert Core 3.0.14

Added:

  • Optional feature to transform SYSDATE as CURRENT_TIMESTAMP. This will also transform DATE columns to TIMESTAMP. This transformation can be set from the migration settings:

Fixed:

  • Fix transformation for ALTER SESSION using NLS_DATE_FORMAT.

  • Now an issue will be reported in the assessment when the input file or files have encoding incompatibilities.

Release 0.8.0 - June 21st, 2021

SnowConvert Core 3.0.13

Added:

  • Create Assessment rules for PROCEDURES section of the report.

  • Create Assessment rules for SCHEMAS section of the report

  • Create Assessment rules for PACKAGES and PACKAGES BODIES section of the report.

  • Emit the SET statements to create session variables.

Fixed:

  • Fix to support EXIT WHEN cursor NOTFOUND.

  • Transformation for Alter Session using NLS_DATE_FORMAT.

Release 0.7.5 - June 9th, 2021

SnowConvert Core 3.0.11

Added:

  • Create Assessment rules for the PROCEDURES section of the report (Dynamic SQL and DBMS_SQL).

Fixed:

  • (UI) Fix progress title when the application runs in Assessment mode.

  • Parsing error with EDITIONABLE procedures.

  • Delete empty folder when the application is running a migration in Linux and Mac.

  • Error comment added for unsupported operators.

  • Error comment added when there are Nested Procedures/Functions.

Release 0.7.3 - June 8th, 2021

SnowConvert Core 3.0.9

Added: