2023
Details about the releases of Snowflake SnowConvert for SQLServer during 2023.
Last updated
Details about the releases of Snowflake SnowConvert for SQLServer during 2023.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
SnowConvert Core 22.2.73
Fixes and improvements:
Improve 'arrange' to correctly split triggers and indexes.
Improve 'arrange' to correctly recognize CREATE OR ALTER VIEW as a VIEW object.
SnowConvert Core 22.2.63
Fixes and improvements:
Fix transformation for EOMONTH function regardless of the letter case
Fix EXECUTE statement translation with arguments in procedures
SnowConvert Core 22.2.48
Added:
Support for DROP IF NOT EXIST pattern
Fixes and improvements:
Fix the preprocessing step in order to consider only .sql extension files
SnowConvert Core 22.2.30
Added:
Support DECLARE CURSORS defined with CTE
Add validation for SQL Server arrange
Fixes and improvements:
Include schema on temporal tables in procedures
SnowConvert Core 22.2.9
Fixes and improvements:
Remove blank space at the end of brackets enclosed columns
Update RAISERROR_UDF to not throw an exception when severity is 10 or lower
SnowConvert Core 22.0.47
Added:
Fixes and improvements:
Add CREATE INDEX to the Assessment Report
Fix conversion rate on CREATE TABLE with Fill Factor
SnowConvert Core 22.0.32
Added:
Transformation for STR function
Fixes and improvements:
Reduced the number of built-in functions marked with Pending Functional Review EWI
SnowConvert Core 22.0.23
Fixes and improvements:
Improve EWI mechanism for better consistency
SnowConvert Core 21.0.170
Added:
Implicit zero number transformation for empty string
Transformation for BEGIN TRANSACTION with a label
Fixes and improvements:
Fix parsing error related to CTE expressions.
SnowConvert Core 21.0.153
Added:
Add support for OUTER APPLY
Fixes and improvements:
Remove generation of HtmlReport for all conversions and assessments
Implicit conversion to date type for empty string
Fix critical error MSEWI1013 for tables
SnowConvert Core 21.0.129
Added
Transformation for @@servername
Fixed
Transformation for Transform function when using a fixed VARCHAR size
Removed a bug that caused MSEWI1013 to be shown where it should not
SnowConvert Core 21.0.107
Added
Update the license mechanism to a more secure compliant mechanism
Count of Materialized Views that reference multiple objects added to the Assessment Report
Materialized Views statements are represented as Top Level Objects in reports
Support return table for Stored Procedures that return more than one row
Count of nested cursors and cursors inside queries added to the Assessment Report
Support translation for ERROR_MESSAGE() function
Include conversion settings in the Assessment Report to view the selected conversion language such as JavaScript and Snowflake Scripting
Support translation for NUMERIC(X, X) data type
Improve exception handling
Fixed
Remove unnecessary USING clauses being added in DELETE statements
Add ALTER TABLE DEFAULT constraint to CREATE TABLE columns
Parse TABLE HINT when INDEX = <index_value>
Parse UNION after a SELECT statement inside the parenthesis
Parse CLUSTER and RAW as identifiers
Parse SAVEPOINT as an identifier
SnowConvert Core 21.0.43
Fixed
Parse XML Data Type Methods in SET statement
The object conversion rate is 100% when MSCEWI4046 is present
The object conversion rate is 100% when MSCEWI1027 is present
The object conversion rate is 100% when MSCEWI4015 is present
Exceptions while converting Default Constraint Definition of ALTER TABLES
Assessment.docx Showing 0% instead of a hyphen (-) without objects present
The LoC Converted exceeded 100% in some workloads
Mapping STUFF function to INSERT instead of using UDF
SnowConvert Core 20.4.20
Added
Support translation for functions OBJECT_NAME and OBJECT_SCHEMA_NAME
Fixed
Remove ProcedureCall EWI when calling the built-in function
Fix exceptions while converting TSqlsQuery
SnowConvert Core 20.2.8
Added
The cursor complex pattern section added to .docx report
Fixed
Remove ProcedureCall EWI when calling CAST built-in function
Fix parsing error related to the '\' character
SnowConvert Core 18.4.127
Fixed
Fix ALTER TABLE conversion rate caused by REFERENCES and CHECK NOT column constraints not being marked as converted
SnowConvert Core 18.4.111
Fixed
Fix on parsing of CREATE COLUMNSTORE INDEX
Throw statement transformed to Raise
Fix for Insert list referencing tables when it shouldn't.
Fix for a missing EWI in Alter Statement
SnowConvert Core 18.4.67
Added
Count for Temporary Tables in Assessment.docx
Add EWI to invalid subqueries
Fixed
Retaining NOLOCK when it should be removed
Inconsistency between the EWIs number in .csv file and output code
Replacing branding Mobilize.Net by Snowflake
DATEADD with millisecond is wrongly reported as Not Supported
SET NOCOUNT OFF/ON causes an empty line with a single semicolon (;)
Add count for Dynamic SQL section in Assessment report
Update the subqueries section of the assessment template to count invalid subquery patterns
Too many arguments for function TO_TIMESTAMP_NTZ
SUSER_SNAME() and SUSER_NAME() should be converted to CURRENT_USER()
Different output when migrating two files with Scalar functions
Update the subqueries section of the assessment mode template to count invalid subquery patterns
Edit the .docx to add the cursor's information required
Create the rules required to count FETCH inside loops
Create the rules required to count nested CURSOR occurrences
Create the rules required to count CURSOR ref occurrences
Some CTEs are not being converted properly to Snowflake Scripting
Update UI for a new option to overwrite schema/data warehouse
Change the default database name behavior to NONE for CLI
Translate CTE + Update
Upload AssessmentMode Elements report to blob storage
Count table-value functions and multi-statement functions in Assessment
LEFT JOIN is being removed from the DELETE statement
CTEs are not being converted properly to Snowflake Scripting
Alter Table Default Values are lost
Add Cursors and Loops in procedures in Conversion Report .docx template
Create infrastructure to count patterns in code
Count table-valued functions and multi-statement functions
Improve encoding handling infrastructure
Function TRY_CAST should be maintained
A vulnerability reduction patch included
Translate CTE + SELECT INTO
Edit the docx template to add Cursors and Loops in procedures
Add fields in assessment csv for loops and cursors
Count the number of loop occurrences in procedures
Count the number of cursor occurrences in procedures
The data type MONEY should be mapped to Number(38,4)
Translation for Multiple Output parameters should be declared and returned
UPDATE is adding a new AND condition that could interfere with OR expressions
Some comments on functions and procedures are lost
Invalid node type comparison in Assessment Summary
Add EWI for complex pattern fetch inside loop
Removes UDFs from not supported functions, they are marked now only with the
Removed the deprecated conversion parameters --snowscript and --disableSnowScript from the CLI.