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
functionTransform
ALTER TABLE
Default Constraint usingCREATE TABLE
statementRefactor 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 inALTER TABLE
statementRemove
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 optionRemove