2022

Release 2.0.264 - December 19th, 2022

SnowConvert Core 13.0.16

Added

• Translation for function DB_NAME

• Translation for function SYSUTCDATETIME

• Translation of CAST parameter used to style format from date to string

Fixed

• The result of the AT TIME ZONE is different in the .csv of SQL Server and the .csv of Snowflake

• ALTER TABLE ADD COLUMN CONSTRAINT adds invalid IF EXISTS statement

• Fix to be inline as the date to string CAST documentation

Release 2.0.259 - December 12th, 2022

SnowConvert Core 12.0.0

Added

• CTE + INSERT has an incorrect conversion

• Stabilize using Elements Report Category/GrammarElement resolvers

• Generate object breakdown section in HTML Conversion Report

• Generate File breakdown section in HTML Conversion Report

Fixed

• Reduce procedure exceptions in some customer workloads

• EWI1040 is displayed but it should display EWI4063

• Regression due to SQL Changes in DotDouble Operator

• Stackoverflow migrating ALTER TABLE ADD CONSTRAINT

Release 2.0.246 - November 21st, 2022

SnowConvert Core 11.0.108

Added

• Procedures with unsupported options gives 0 % conversion rate

• Translate OPENXML table valued function

• Add a footer to HTML Conversion Report

• Generate File breakdown section in HTML Conversion Report

Fixed

• Function should be preserved as Function

• Cast issues for date/time not correctly converted

• Some generated Javascript function is invalid

• Date & Time functions do not work properly

• Exception in CREATE TABLE statement

Release 2.0.235 - November 10th, 2022

SnowConvert Core 11.0.62

Added

• Support for GETUTCDATE function

• Translation of Output parameter should be declared and returned

• Generate overall conversion summary section in HTML Conversion Report

• Generate issues breakdown section in HTML Conversion Report

Fixed

• FORMATMESSAGE Function Not Supported

• Functions defined in the code are generating EWI1031 when referenced

• SQL N strings are lost inside some Store Procedures

• Function Generated Javascript but it should be using the Target language selected

Release 2.0.218 - October 24th, 2022

SnowConvert Core 10.0.0

Added

• Remove Cartesian Product from the UPDATE statement

• Create a UDF function equivalent to xplogininfo

• Transform Bitwise operations

• Translate Expression AT TIME ZONE

• Translate CTE in SELECT and CREATE VIEW

Fixed

• Cast issues for date/time not correctly converted

• Ewis and expected code were not generated according to ALTER TABLE documentation

• File not generated with XP_LOGININFO in INSERT

• The table Named with @ should be replaced by T_ and the temporary table

• Parsing error for MERGE @Table statement

Release 2.0.200 - October 10th, 2022

SnowConvert Core 9.2.72

Added

• [Alter Table] Function SWITCHOFFSET must be converted

• [Alter Table] Parse ALTER TABLE data type

• [Alter Table] Save ALTER TABLE default values to a CREATE TABLE statement

• [UI] Change DBObject Name Conversion Setting text and default option to NONE

Fixed

• Comments lost in the header of procedures

• TopLevelQueries were not generated when only dynamic SQL queries

Release 2.0.173 - September 26th, 2022

SnowConvert Core 9.2.6

Added

• [Alter Table] [Translation] IDENTITY column option

• [Alter Table] Enable transformation for MEF default constraints collected

• [Alter Table] [Translation] SPARSE column option

Fixed

• Division of integer values must add trunc function

• Binary expression '+' must be converted to || Snowflake concatenation

Release 2.0.156 - September 12th, 2022

SnowConvert Core 9.0.37

Added

• Data types should be converted properly

Fixed

• DATEADD and DATEDIFF are giving issues converted together

• Function EOMONTH should be appropriately converted

• Store procedures Header comments are not added in the correct location

• Unexpected 'AS' for incorrect transformation of DATE_PART

Release 2.0.130 - August 29th, 2022

SnowConvert Core 7.11.122

Added

• Translate MASKED WITH (FUNCTION = 'mask_function')

• Create more specific EWI for unsupported types

• [UDF] Transform User Defined Functions with Nested IF depth greater than 1

• Translation for unsupported Table Elements within ALTER TABLE

Fixed

• Missing SELECT helper in a stored procedure

Release 2.0.112 - August 16th, 2022

SnowConvert Core 7.11.83

Added

• Translate scope_identity function

• Transform ALTER TABLE Default Constraint using CREATE TABLE statement

• Refactor TSqlsStat AST

Fixed

• Some duplicated procedure names with no schema are lost during arrange preprocess

• Added cast to return value when return type should be DATE

Release 2.0.95 - August 3rd, 2022

SnowConvert Core 7.11.47

Added

• Translate DEFAULT property in ALTER TABLE statement

• Remove ALTER TABLE unsupported table options

Release 2.0.89 - August 1st, 2022

SnowConvert Core 7.11.22

Added

• Translate SET statements inside IF/ELSE blocks

• Translate SELECT statements inside IF/ELSE blocks

• Parse ALTER TABLE rebuild option

• Remove