2024
Details about the releases of Snowflake SnowConvert during 2024.
SQL Core 28.2.32 April 30th
This version is currently in preview.
Improved the EmbeddedCodeUnitReport. Added four more columns: FDM Count, PRF Count, FDM and PRF.
Added new breaking change at the UI. Now, the user will have to inquire about an access code for doing their assessment. For more details, please check here.
[SQLServer] Added translation for DB_ID function.
[SQLServer] Added basic translation for CREATE SCHEMA.
[SQLServer] Added an FDM for CREATE INDEX.
[Teradata] Improved binding variable translations.
[Teradata] Added new parsing capability for BYTE data type.
[Oracle] Improved translation of procedure parameters avoiding deployment errors.
SQL Core 28.2.11 April 24th
This version is currently in preview.
Common
Added a new assessment report EmbeddedCodeUnitReport, for more information, please visit here.
Improved the TopLevelCodeUnitReport. Added four more columns: FDM Count, PRF Count, FDM and PRF. For more information, please visit here.
Fixed an unexpected error in creating an assessment report.
Teradata
Added translation for CONTINUE HANDLER.
Oracle
Added and improved parsing capability to read EXPLAIN PLAN statement, U-Literals and CTAS.
Improve CURSOR translation when it has to define a cursor with object_construct.
SQLServer
Improved ALTER TABLE translation.
SQL Core 28.1.113 April 17th
Common
Improved the mechanism of line counting.
SQLServer
Improved the parser to read line breaks within Bracket Identifiers.
Improved translation for Alter Table commenting on the default constraints.
Improved translation robustness.
Oracle
Added more parsing functionality to read REVOKE, EXIT and ^= inequality operator.
Improved the parser to avoid errors when reading
ENABLE LOGICAL REPLICATION ALL KEYSImproved the assessment to identify correctly the BEGIN/END code unit .
SQL Core 28.1.100 April 9th
Common
Improved the parsing functionality, resulting in the resolution of numerous parsing errors (SSC-EWI-0001)
Teradata
Add parsing functionality for REMOVE statement
Fixed alias lost issue
COLLECT STATISTICS changed from EWI to FDM
Oracle
Improved the parsing functionality for:
SQL*Plus SPOOL command
Multiline table name or column name
Subqueries with a correlation name
Partition by and Global partition by clauses
Improved conversion robustness
SQLServer
Fixed double quote lost in translation issue
Fixed translation when INSERT is used as function name
Fixed translation for COS function
SQL Core 28.1.78 March 26th
Common
Added significant improvements to parsing functionality, resulting in the resolution of numerous parsing errors.
Teradata
Fixed RETURN of OPEN CURSOR when inside COMPOUND and LABEL statements.
Fixed column names converted as bind variables in INSERT statements.
Fixed RTRIM being added to SET in UPDATE statements.
Fixed VARCHAR's length missing when casting to VARCHAR.
Improved transformation of CAST functionalities.
Removed 'YYYY-MM-DD' date format showing as unsupported.
Oracle
Added transformation for UPDATE SELECT statements.
Added transformation for STORED PROCEDURE calls inside SELECT statements.
Improved transformation of FOREIGN KEY constraints defined in CREATE TABLE by moving them to ALTER TABLE statements.
SQL Server
Added transformation for Table Value Constructor in SELECT statement.
Added transformation for TINYINT casting.
Added transformation for the SYSDATETIMEOFFSET function.
Added transformation for sp_rename functionality for TABLEs and COLUMNs.
Fixed transformation for DEFAULT constraint not being added to CREATE TABLE.
Fixed TABLEs created by SELECT INTO statements showing as a missing object.
Improved transformation of CREATE PROCEDURE when returning RESULTSET variables.
Improved the transformation of ALTER TABLE statements by commenting out the WITH CHECK/NOCHECK clause and CHECK constraint, as they are redundant in Snowflake.
Removed unnecessary CREATE and DROP index statements, as they are redundant in Snowflake.
SQL Core 28.1.20 March 19
Common
Added New Code Unit Methodology
Added Code Completeness Score
Added New Reports: Top Level Code Unit Report and Scope Validation Report.
Provide tables conversion for free.
Improved SnowConvert messages - EWI, FDMs, and PRF
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 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 wrong numeric string format.
Added the transformation of 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