Release Notes

Release 1.1.11 - Jul 19, 2021

SnowConvert Core 3.0.20

Added

  • Improved Assessment Accuracy for:

    • Declare Statements in procedures.

    • If Statements.

    • Cursor Statements.

    • Merge Statements.

  • Translate statement SELECT INTO TableName .

  • Translate statements in Create Procedure:

    • Identity Column.

    • Column names with operators.

  • Disclaimer for SQL Identified objects and SQL Files conversion rate.

Fixed

  • EXECcall not being generated in the output.

  • SnowConvert conversion loop for certain store procedures.

  • Error migrating views and code being removed.

  • Translation of negative values being translated to positive values.

  • NOT EXISTS is being translated as EXISTS.

  • Inconsistencies in Assessment Accuracy conversion rate.

  • DefaultExpression should be counted as an error and affect the conversion rate.

  • MSC-ISSUE renamed to MSC-ERROR in all the reports.

Release 1.1.10 - Jul 6, 2021

SnowConvert Core 3.0.16

Added

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

  • Translate basic statements in CREATE PROCEDURES such as:

    • Translate BEGIN TRANSACTION statement

    • Translate COMMIT statement

    • Translate for ROLLBACK and ROLLBACK TRANSACTION statement

    • Translate THROW statement

    • Translate INSERT INTO EXEC

  • Translate Temporal Tables

  • Translate for EXECUTE Statement and N Literal

  • Translate of CREATE PROCEDURE AS OWNER

  • Translate built-in functions that have equivalence in Snowflake

  • Translate TRUNCATE Statement

  • Translate DROP TABLE statement

  • Telemetry for assessment

Release 1.1.9 - Jun 22, 2021

SnowConvert Core 3.0.13

Added

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

  • Translate basic statements in CREATE PROCEDURE such as:

    • Translate EXECUTE/EXEC statement

    • Translate embedded CREATE TABLE statement

  • Translate basic predicates such as:

    • BETWEEN Predicate

    • EXISTS Predicate

    • IN Predicate

  • Translate WITH Clauses in CREATE TABLE

  • Translate Cursor DECLARE, OPEN, FETCH, CLOSE and DEALLOCATE

Release 1.1.5 - Jun 9, 2021

SnowConvert Core 3.0.9

Added

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

Release 1.1.3 - May 25, 2021

SnowConvert Core 3.0.5

Added

  • Translated basic CREATE PROCEDURE

  • Translate basic statements in CREATE PROCEDURE such as:

    • DECLARE @variable

    • SET @variable

    • TRY CATCH Statement

    • IF Statement

    • While Statement

    • RETURN Statement

    • SELECT, UPDATE, INSERT, DELETE and MERGE.

  • Translate basic expressions in CREATE PROCEDURE such as:

    • IS NULL / IS NOT NULL predicate

    • BINARY Operations ( +, -, *, / )

    • Comparisons ( >,<, <=, >= )

In order to try out the newly added translation features, you can use this example code and migrate this example with SQLServer SnowConvert.

CREATE PROCEDURE Procedure1(
@model_year SMALLINT,
@FirstName NVARCHAR(50),
@Age INT,
@Balance SMALLMONEY,
@Description VARCHAR
) AS
BEGIN
DECLARE @cursor_db CURSOR;
DECLARE @database_id INT, @database_name VARCHAR(255);
DECLARE @product_list VARCHAR(MAX) = ' ';
DECLARE @Variable1 AS VARCHAR(100), @Variable2 AS VARCHAR(100);
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT OFF
SET @product_list = '';
SET @var1 += '';
SET @var2 &= '';
SET @var3 ^= '';
SET @var4 |= '';
SET @var5 /= '';
SET @var6 %= '';
SET @var7 *= '';
SET @var8 -= '';
SET @statement = 'SELECT * FROM TABLE1 WHERE COL1 = '+@param1+ ' AND COL2 = ' + @param2;
BEGIN TRY
IF @Age > 15
return
ELSE
return 2;
WHILE (@PATITO < 2)
BEGIN
SELECT * FROM TABLE1;
END;
INSERT INTO TABLE1 VALUES (1,2,3, @param1);
DELETE dbo.Table2 FROM dbo.Table2 INNER JOIN dbo.Table1 ON (dbo.Table2.ColA = dbo.Table1.ColA) WHERE @ColA = 1;
Update PruebaUpdate Set Col1 = 5;
END TRY
BEGIN CATCH
return -1;
END CATCH
END;
GO

Release 1.1.2 - May 14, 2021

SnowConvert Core 3.0.3

Added

  • Translate Tables

  • Translate Views

  • Assessment Report for Tables and Views

Known issue: you may get some error in the UI if you try to migrate Procedures and Functions