2021

Release 1.4.1 - December 22nd, 2021

SnowConvert Core 3.2.16

Added

• Robustness on parser on SELECT statements.

• Code preprocess before converting the source code. Learn more

• Accuracy improvements on Assessment.

Fixed

• Cursor error when the result is only 1 row inside Stored Procedures

• Unhandled exception while converting OBJECT_ID

• Transformation for temporal (#) tables

• Unhandled exception while converting aliases with special characters or spaces.

• Unhandled exception while converting MERGE statements

Release 1.3.4 - December 7th, 2021

SnowConvert Core 3.1.43

Fixed

• Transformation for ISDATE function

• Transformation for PATINDEX function

• Transformation for string concatenation using +

Release 1.3.3 - November 22nd, 2021

SnowConvert Core 3.1.24

Added

• Transformation for TRY_CONVERT and TRY_CAST function

• Transformation for STR function

Fixed

• Transformation for MONEY and SMALLMONEY

• Transformation for TABLE datatype in stored procedures

• Error on SELECT helper

• Transformation for addition assignment operators (+=, -=)

• Transformation for UPDATE statements using the table alias as target

• Comments lost during stored procedures transformation.

Release 1.3.1 - November 8th, 2021

SnowConvert Core 3.1.20

Added

• Count of User Defined Functions inside and outside queries

• Assessment section for User Defined Functions

• Transformation for @@ROWCOUNT function

Fixed

• Exception thrown while generating the HTML report

• Transformation for DECLARE statements with scalar default value

• Transformation for Common Table Expressions with Delete statement removing duplicates

Release 1.3.0 - October 25th, 2021

SnowConvert Core 3.1.11

Added

• Robustness on the parser for CREATE PROCEDURES

• Parsing and basic Assessment for CREATE FUNCTION

• Object conversion rate for each identified object.

Fixed

• Exception that was causing a file not to be generated

• Transformation for variable declaration inside labels

• Transformation for ROW_NUMBER with partition

Release 1.2.1 - October 11th, 2021

SnowConvert Core 3.1.9

Added

• Robustness on the parser for CREATE PROCEDURES

• Transformation for BULK INSERT statements

• Transformation for object_id inside IF statements

• Transformation for object_schema_name(@ObjectId, @DatabaseId)

• Transformation for object_name(@ObjectId, @DatabaseId)

• Transformation for modulo (%) operations in IF conditions

• Transformation for WAITFOR statements

• Transformation for empty statements inside Stored Procedures

• Transformation for ERROR_SEVERITY function

Fixed

• Transformation for double-dot qualifiers. Example:

Input

select * from db..table1

Output

select * from db.dbo.table1

• Comment objects with missing dependencies

• Inconsistent Total Issues value on UI vs Assessment report

• Custom database and schema options not working in the UI

• Disabling EWI comments generation in some cases

• Transformation for Procedures inside Unicode literals

Release 1.2.0 - September 28th, 2021

SnowConvert Core 3.1.8

Added

• Robustness on the parser for CREATE PROCEDURES

• Translation for LABELS and GOTO

• Translation for RAISERROR

• Translation for error functions such as:

  • ERROR_LINE

  • ERROR_STATE

  • ERROR_PROCEDURE

  • ERROR_NUMBER

  • ERROR_MESSAGE

• Translation for CONTINUE statement.

• Translation for OBJECT_ID function with object_type argument specified.

• Translation for CAST function

• Warning for not supported REVERT statement.

• Translation for COMMON TABLE EXPRESSIONS using DELETE , UPDATE or INSERT

• New Logo for SnowConvert and minor UI update (some colors changed). New images are displayed in the Using SnowConvert section.

Fixed

• Translation for CROSS APPLY

• Translation for NLiteral expressions inside SELECT statements

• Translation for IDENTITY with default values

• Translation for UPDATE statements with JOIN clauses

• Translation for SELECT INTO used in COMMON TABLE EXPRESSION

Release 1.1.17 - September 14th, 2021

SnowConvert Core 3.1.3

Added

• Robustness on the parser for CREATE VIEW and CREATE PROCEDURES

• Translation for CASE Expressions and built-In functions calls inside procedures.

• Translation for BREAK statement.

• Translation for supported ODBC SCALAR FUNCTIONS.

• Translation for SELECT @LOCAL_VARIABLE.

• Missing dependencies warning to views without their dependencies in the source code.

• Regions for PROCEDURES helpers.

• Warning for MASKED columns.

• Warning for DATABASE CONSOLE COMMANDS.

Fixed

• EXISTS translation in order to use the Snowflake built-in.

Release 1.1.16 - August 31st, 2021

SnowConvert Core 3.1.1

Added

• Robustness on the parser for CREATE TABLE , CREATE VIEW and CREATE PROCEDURES

• Assessment Accuracy Improvements:

  • Parsing errors count on output code and issues csv file.

  • Differentiation between warnings and errors count.

  • Warnings to some transformations properly added.

• Built-In functions translation:

  • CONVERT

  • COALESCE

  • ISNUMERIC

  • QUOTENAME

  • USER_NAME

  • SOUNDEX

  • DATEPART

  • DATENAME

  • NEWID

  • PATINDEX

  • FORMAT

  • PARSENAME

  • STUFF

  • DATABASE_PRINCIPAL_ID

• Translation for sysname ,