2024

Details about the releases of Snowflake SnowConvert during 2024.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

SQL Core 28.0.15 February 16th

Teradata

  • Preserve column size when casting to VARCHAR even if there are missing dependencies

  • Remove extra cast when casting VARCHAR

SQL Core 28.0.14 February 7th

Oracle

  • Foreign keys referencing views marked as not supported in Snowflake

  • Foreign keys data type mismatch marked as not supported in Snowflake

SQL Server

  • Fix MODULUS operation exception when using a column without table reference

  • Fix tables inside procedures that are being reported as objects in Assessment.docx

SQL Core 28.0.11 January 25th

Teradata

  • Reorder option NOT NULL before COMMENT in column table definitions

Oracle

  • Fix resolution of Symbol Procedures now considering parameters

SQL Core 28.0.9 January 22nd

SQL Server

  • Generating RAISE exception info in BEGIN-TRY CATCH Block

Oracle

  • Fix parsing error of VARRAY in table properties

  • Add transformation for SDO_GEOMETRY

SQL Core 28.0.3 January 16th

Common

  • Fix the wrong filename in Top level object report.

SQL Server

  • Support translation of XML functions.

SQL Core 27.1.43 January 9th

SQL Server

  • Add conversion support for comments (sp_addextendedproperty).

  • Fix SnowConvert demo has object counting inconsistencies.

  • Fix default alter not generating in different batches.

  • Fix conversion rate above 100% in SnowConvert demo.

  • Remove GO statement due to functionality already simulated with anonymous blocks.

Teradata

  • Fix the wrong column size of view when using LEFT on CAST as a VARCHAR.

Oracle

  • Fix nested functions are being counted as functions inside packages.

  • Fix TRUNC_UDF() included in Oracle conversion. but references Teradata.

SQL Core 27.1.29 January 2nd

SQL Server

  • Fix some missing dependencies issues generated that were incorrect.

  • Fix of Assessment json report when it generates the wrong numeric string format.

  • Added the transformation of the DELETE STATEMENT common pattern to remove duplicated rows.

  • Added the transformation for Select Objects inside an If Statement in Anonymous Blocks.

Oracle

  • Added parsing support for ALTER SESSION with PARALLEL.

  • Fix values on the Docx Report that were missing.

Last updated