2024
Details about the releases of Snowflake SnowConvert during 2024.
Last updated
Details about the releases of Snowflake SnowConvert during 2024.
Last updated
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 .
[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.
This version is currently in preview.
Added a new assessment report EmbeddedCodeUnitReport, for more information, please visit .
Improved the TopLevelCodeUnitReport. Added four more columns: FDM Count, PRF Count, FDM and PRF. For more information, please visit .
Fixed an unexpected error in creating an assessment report.
Added translation for CONTINUE HANDLER.
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.
Improved ALTER TABLE translation.
Improved the mechanism of line counting.
Improved the parser to read line breaks within Bracket Identifiers.
Improved translation for Alter Table commenting on the default constraints.
Improved translation robustness.
Added more parsing functionality to read REVOKE, EXIT and ^= inequality operator.
Improved the parser to avoid errors when reading ENABLE LOGICAL REPLICATION ALL KEYS
Improved the assessment to identify correctly the BEGIN/END code unit .
Improved the parsing functionality, resulting in the resolution of numerous parsing errors (SSC-EWI-0001)
Add parsing functionality for REMOVE statement
Fixed alias lost issue
COLLECT STATISTICS changed from EWI to FDM
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
Fixed double quote lost in translation issue
Fixed translation when INSERT is used as function name
Fixed translation for COS function
Added significant improvements to parsing functionality, resulting in the resolution of numerous parsing errors.
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.
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.
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.
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
Foreign keys referencing views marked as not supported in Snowflake
Foreign keys data type mismatch marked as not supported in Snowflake
Fix MODULUS operation exception when using a column without table reference
Fix tables inside procedures that are being reported as objects in Assessment.docx
Reorder option NOT NULL before COMMENT in column table definitions
Fix resolution of Symbol Procedures now considering parameters
Generating RAISE exception info in BEGIN-TRY CATCH Block
Fix parsing error of VARRAY in table properties
Add transformation for SDO_GEOMETRY
Fix wrong filename in Top level object report.
Support translation of XML functions.
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
Fix the wrong column size of view when using LEFT on CAST as a VARCHAR.
Fix nested functions are being counted as functions inside packages.
Fix TRUNC_UDF() included in Oracle conversion. but references Teradata.
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.
Added parsing support for ALTER SESSION with PARALLEL.
Fix values on the Docx Report that were missing.