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.