2022

Details about the releases of Snowflake SnowConvert for Oracle during 2022.

Release 2.0.264 - December 20th, 2022

SnowConvert Core 13.0.23

Added

Parsing for some SQL*Plus statements
  • PROMPT

  • START

  • Recognize some FORALL patterns.

  • Translation Specification of FORALL patterns.

  • Add casting when accessing DATE and TIMESTAMP fields in objects.

Fixes and improvements

  • Fix duplicated constants in functions/procedures inside packages.

  • Fix transformation for INSERT with a record value

  • Fix some conversion errors.

Release 2.0.259 - December 12th, 2022

SnowConvert Core 12.0.0

Added

  • Generate object breakdown section in HTML Conversion Report.

  • Transform the Parameterized Cursor declaration.

  • Transform the OPEN statement of parameterized cursors.

Fixes and improvements

  • Fix function is not recognized when it is a Synonym.

Release 2.0.245 - November 21st, 2022

SnowConvert Core 11.0.108

Added

  • Support new cases of MATERIALIZED VIEWS.

  • Footer added to HTML Conversion Report.

  • File breakdown added HTML Conversion Report.

Fixes and improvements

  • 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.

Release 2.0.234 - November 10th, 2022

SnowConvert Core 11.0.62

Added

  • 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.

Fixes and improvements

  • 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.

Release 2.0.219 - October 25th, 2022

SnowConvert Core 10.0.0

Added

  • Initial transformation for MATERIALIZED VIEWS.

Fixes and improvements

  • 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

Release 2.0.198 - October 10th, 2022

SnowConvert Core 9.2.72

Added

  • Support for default parameters in procedures.

  • Support for package variables as an output argument in procedures.

Fixes and improvements

Materialized View parsing improvements
  • Unusable Edition Clause

  • JSON Storage clause

  • For Update clause

Release 2.0.176 - September 26th, 2022

SnowConvert Core 9.2.11

Added

Initial Parsing for Materialized Views
  • Parsing Create Materialized View.

  • Parse Materialized View Refresh clause.

  • Parsing of Physical Properties.

  • Parse Evaluation Edition clause

  • Initial Assessment reporting for Materialized Views.

Fixes and improvements

  • Fixed parsing of some table properties.

Release 2.0.157 - September 13th, 2022

SnowConvert Core 9.0.48

Added

Transformation for records to Snowflake Scripting
  • Transformation of records custom types declaration inside procedures.

  • Transformation of record variables using custom types.

  • Transformation of records variables using %ROWTYPE.

  • Record properties assignment.

  • Record properties access.

  • Transformation of "INSERT INTO" when VALUES clause has records.

  • Provide UI and CLI options to activate the arrange

Fixes and improvements

  • Fix transformation for procedure calls inside packages.

  • Fixed parsing error in USING INDEX LOCAL clause.

  • Fix of conversion errors.

Release 2.0.125 - August 29th, 2022

SnowConvert Core 7.11.119

Fixes and improvements

  • Improve EWI description and transformation for DBLink (database Link) Reference.

  • General assessment infrastructure improvements.

Release 2.0.110 - August 16th, 2022

SnowConvert Core 7.11.81

Added

  • 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.

Fixes and improvements

  • Fixed an issue when the package name was qualified with the schema name.

Release 2.0.87 - August 1st, 2022

SnowConvert Core 7.11.22

Added

Transformation for stateful packages variables to Snowflake Scripting

Package variables are being transformed into session variables.

Variable reads and writes are being performed in real-time guaranteeing global consistency.

Fixes and improvements

  • 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.

Release 2.0.70 - July 18th, 2022

SnowConvert Core 7.9.154

Added

  • Support for built-in package UTL_FILE.FOPEN, UTL_FILE.PUT_LINE, UTL_FILE.FCLOSE.

Fixes and improvements

Output parameters transformation improvements

For supporting output parameters we returned a table but this was generating a lot of code to build that table before leaving the procedure. Also, the returned type was complex to build and confusing.

Now, we are returning an object in a single line and the type was changed to VARIANT. From the procedure calls, the migrator generates the needed code to retrieve the variables from the generated object. The new implementation is cleaner and easier to understand.

For more details, please refer to the limited access documentation.

  • 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.

Release 2.0.65 - July 4th, 2022

SnowConvert Core 7.9.95

Added

  • 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.

Fixes and improvements

  • 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.

Release 2.0.38 - June 21th, 2022

SnowConvert Core 7.9.34

Added

Lines of code conversion rate mode is now available.

By default, the conversion rate is calculated per character transformed for more precision. Now, the user can select how this calculation is done by choosing between lines of code or characters.

Fixes and improvements

  • SUPPLEMENTAL LOGGING clause removed from tables.

  • Fixed indentation with procedure calls in Snowflake Scripting.

  • Oracle built-in tables and views are now being marked as not supported.

Release 2.0.21 - June 7th, 2022

SnowConvert Core 7.3.0

Added

  • 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.

Fixes and improvements

  • 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.

Release 2.0.6 - May 25th, 2022