2021

Details about the releases of Mobilize.Net SnowConvert for Oracle during 2021.

Release 0.8.7 - July 20

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 8

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 7

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 28

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 21

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 9

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 8

SnowConvert Core 3.0.9

Added:

  • Transformation for Functions with only logical statements

  • Functions transformation for external program calls

  • Parse for wrapped statements

  • Assessment rules for the following sections of the report:

    • ROWNUM in the Procedures section

    • SYS_CONTEXT and SESSIONID in Data Values section

    • OLAP Functions inside Views

    • CustomType inside View

    • SQL/C/JAVA functions

    • Wrapped Objects

Fixed:

  • Fix for Procedures conversion rate drop, due to an exception.

  • Change parameters for EXEC helper.

  • Fix transformation for invalid column identifiers in Snowflake Tables.

  • Remove unused ERROR_HANDLERS variable from procedure helpers.

  • Change commit transformation to use EXEC helper.

  • Simplify object property assignation of SQL object (EXEC) and Error Object (RAISE).

  • Fix escaping quotes when using a STUB function in procedures.

Release 0.7.2 - May 25

SnowConvert Core 3.0.5

Added:

  • Transformation for constants in stateful packages.

  • General improvements on assessment docx report.

  • Convert qualified names.

  • Support for functions with only one SELECT INTO query.

  • Assessment rules for the following sections of the report:

    • Views

    • DataTypes

    • Data Values

    • Object Naming

    • Constraints

    • User Defined Functions

Fixed:

  • Fix assessment for unsupported PL/SQL expressions.

  • Use correct datatype for a column when the default value is SYSDATE.

  • (Cursor) Binding variables for OPEN FOR with a query.

  • Parsing Errors fixed.

  • OutOfMemory exception thrown by unclosed comments.

  • Functions bindings inside packages.

  • (UI) Improve readability of Object Conversion settings.

  • Comment out unsupported XML type and URI type.

  • Bind qualified names of record values when used in other queries.

Release 0.7.1 - May 11

SnowConvert Core 3.0.1

Added:

  • Transformation for functions calls inside procedures and other functions.

  • Transformation for Raise statement inside procedures.

  • Data types counting in the tables section of the Assessment report

Fixed:

  • Unsupported CREATE INDEX and CREATE DBLINK statements were not being commented out in the output code.

Release 0.7.0 - April 27

SnowConvert Core 2.1.0

Added:

  • Initial transformation for Functions.

  • Transformation for stateless packages.

    • Create new schemas based on the package name.

    • Extract and transform Stored Procedures and Functions from the package body.

    • Added option to disable the creation of new schemas when transforming packages.

Fixed:

  • Incorrect values returned by the ROWCOUNT of the SQL implicit cursor.

  • Several parsing improvements for tables and packages.

Release 0.6.6 - April 16

SnowConvert Core 2.0.5

Added:

  • Parameter binding for CURSOR FOR LOOP.

  • PL/SQL functions translation: TO_CHAR, CHR, TO_NUMBER, UPPER, SUBSTR, ABS, FLOOR, INSTR, LENGTH, LPAD, LTRIM, REPLACE, RPAD, RTRIM, TRIM, TRUNC.

Fixed:

  • Procedures parameter datatypes migration enhanced.

  • Assessment generation performance improvements.

  • Several parsing improvements for procedures.

Release 0.6.5 - March 31

SnowConvert Core 2.0.1

Added:

  • Transformation for SELECT INTO in stored procedures.

Fixed:

  • Assessment related errors when migrating many files.

  • Inconsistency in BULK COLLECT INTO transformations.

Release 0.6.3 - March 29

SnowConvert Core 2.0.0

Added:

  • Transformation for IMPLICIT SQL CURSOR ATTRIBUTE in stored procedures.

  • Transformation for DECLARE BLOCK in stored procedures.

Release 0.6.2 - March 23

SnowConvert Core 1.14.0

Added:

  • Support for SELECT with UNION in stored procedures.

Fixed:

  • False report of missing dependencies.

Release 0.6.1 - March 17

SnowConvert Core 1.12.3

Added:

  • Transformation for EXECUTE IMMEDIATE in stored procedures

  • Transformation for MERGE in stored procedures

  • Transformation for INSERT in stored procedures

  • Transformation for UPDATE in stored procedures

  • Transformation for SELECT in stored procedures

  • Transformation for DELETE in stored procedures

  • Transformation for IN operator in stored procedures

  • Transformation for BETWEEN operator in stored procedures

  • Transformation for CURSOR DEFINITION in stored procedures

  • Transformation for CURSOR OPEN in stored procedures

  • Transformation for CURSOR FETCH in stored procedures

  • Transformation for CURSOR CLOSE in stored procedures

  • Transformation for CURSOR FOR LOOP in stored procedures

  • Transformation for IS NULL and IS NOT NULL in stored procedures

  • Transformations for Binary Operations in stored procedures

  • Transformation for Logical Operations in stored procedures

  • Transformation for Relational Operations in stored procedures

Fixed:

  • Add empty parentheses for converted procedures without parameters

Release 0.5.1 - March 1

SnowConvert Core 1.10.2

Added:

  • Transformation for COMMIT in procedures.

  • Transformation for CURSOR VARIABLE declaration in procedures.

  • Helper function implemented to handle EXECUTE IMMEDIATE and CURSOR.

Release 0.4.0 - February 13

SnowConvert Core 1.10.1

Added:

  • Transformation for EXIT statement in procedures.

  • Transformation for CASE statement in procedures.

Fixed:

  • Concatenation operator and function improved.

Release 0.3.2 - January 29

SnowConvert Core 1.9.9

Added:

  • Added parsing for Comment on table.

  • Added parsing for ALTER TABLE.

  • Added parsing for Table Properties.

  • Added parsing for COLUMN NOT SUBSTITUTABLE AT ALL LEVELS.

  • Added parsing for MDSYS.SDO_GEOMETRY.

Fixed:

  • Notification inventory and Conversion Report fixes.

  • Character counting inconsistency in Assessment.

Release 0.3.1 - January 19

SnowConvert Core 1.9.8

Added:

  • Added parsing and assessment for create package and create package body.

  • Added parsing for alter table.

  • Added parsing for COLUMN NOT SUBSTITUTABLE AT ALL LEVELS.

  • Added parsing for MDSYS.SDO_GEOMETRY.

Fixed:

  • Error handling when parsing multiple files.

  • Character counting fix in for assessment.

Release 0.3.0 - January 8

SnowConvert Core 1.9.6

Added

  • Added CmdRunner Migration steps.

  • Added Assessment for tables, views, and synonyms.

  • Added preview assessment for procedures.

  • Added the telemetry for assessment.

  • Added the breakdown of the issues for assessment.