2023
Details about the releases of Snowflake SnowConvert for Oracle during 2023
Last updated
Details about the releases of Snowflake SnowConvert for Oracle during 2023
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
SnowConvert Core 22.2.63
Fixes and improvements:
Fix returning values in procedures with output parameter
Improve output parameter equivalent transformation
Fix translation related to partition by list on tables
Improve the variable assignment in functions
Fix return statement that is transformed in order to support output parameters with original and equivalent values
Optimize the preprocess code stage
SnowConvert Core 22.2.48
Added:
Parse LITERAL and INNER as identifiers
Support for OraAggregateClause when it is the body of a function
Support for STRING type
SnowConvert Core 22.2.30
Added:
Parse FROM clause with VERSIONS BETWEEN
Support DECLARE CURSORS defined with CTE
Fixes and improvements:
Fix parsing error in collection method with index
Improve detection of built-in table/view references and report of MSCEWI3118
SnowConvert Core 22.2.9
Fixes and improvements:
The qualified table/view name is being changed in queries
SnowConvert Core 22.0.47
Added:
Fixes and improvements:
Parse MINING, AT, RANGE, LARGE, FULL, OUTER, ATTRIBUTE, OPERATOR as an identifier
SnowConvert Core 22.0.32
Added:
Parsing for Identifiers: MINING, AT, RANGE, LARGE, ROWNUM, FULL, OUTER, ATTRIBUTE, OPERATOR
Transformation for FORALL referenced sub-query as an expression
Fixes and improvements:
Reduced the number of built-in functions marked with Pending Functional Review EWI
SnowConvert Core 22.0.23
Added:
Transformation for XMLQUERY.
Transformation for the IS [ NOT ] EMPTY expression
Fixes and improvements:
Improve EWI mechanism for better consistency.
Add EWI for unsupported Table Collection Expression.
Parsing for XmlQuery function.
Add parsing support for the JSON_VALUE function
SnowConvert Core 21.0.165
Added:
Parsing of nested calls supported.
Fixes and improvements:
Gregorian to Julian date precision improvement.
Fix issues related to FORALL transformation.
SnowConvert Core 21.0.153
Added:
Added Support for Create Type Body Syntax
Fixes and improvements:
Remove generation of HtmlReport for all conversions and assessments
Parsing Errors on Returning Into, partition_extension_clause, Q string, VALIDATE, and ROLLUP Identifiers
Conditional Compilation Parsing Error
Fix Built-In Package Assignment conversion error
Resolve Labeled Statements conversion error
Improve problematic Dynamic SQL identification
Init cursor single quotes cause a compilation error
Fix concurrency conversion issue with FORALL transformation
SnowConvert Core 21.0.129
Fixes and improvements:
Solved parsing error on Return Into Clause
Solved parsing error on Partition Clause
Solved parsing error on Q Literal
Solved parsing error on Validate Clause
Solved parsing error on Rollup Clause
SnowConvert Core 21.0.107
Fixes and improvements:
Update the license mechanism to a more secure compliant mechanism
Improve consistency in conversion for Materialized Views
Count of Materialized Views that reference multiple objects added to the Assessment Report
Deprecate Output Parameters' EWI (MSCEWI1078)
Parse CLOB Cast, IS EMPTY expression and Flashback query
Count of nested cursors and cursors inside queries added to the Assessment Report
Include conversion settings in the Assessment Report to view the selected conversion language such as JavaScript and Snowflake Scripting
Parse SAVEPOINT as an identifier
Improve exception handling
Parse the CREATE TYPE element spec
SnowConvert Core 21.0.43
Fixes and improvements:
The object conversion rate in packages is not 100% with only low EWIs present
The object conversion rate in views is not 100% with only low EWIs present
The object conversion rate in procedures is not 100% with only low EWIs present
The object conversion rate in materialized views is not 100% with only low EWIs present
Multiple exceptions are thrown when using simple expressions in procedure calls
SnowConvert Core 20.4.20
Fixes and improvements:
Fix inconsistencies in reporting MSCEWI1020
SnowConvert Core 20.2.8
Fixes and improvements:
Fix duplicated MSCCP0004 issue in the Issues report
LazyColumn serialization fix
SnowConvert Core 18.4.127
Fixes and improvements
Preserve column names when transforming INSERT in forall statement
SnowConvert Core 18.4.111
Fixes and improvements
Fix Parsing Error in Lock Table
Fix for performance issue when parsing nested Selects with left join
Fix for parsing error when NOCOPY is used without OUT parameters
SnowConvert Core 18.4.67
Added
Count for Temporary Tables in Assessment.docx
Add EWI to invalid subqueries
Fixes and improvements
Support for multiple ForAll pattern-based transformations in a procedure
Inconsistency between the EWIs number in .csv file and output code
Replacing branding Mobilize.Net by Snowflake
Transformation of SQL Plus Command SPOOL.
Added a count feature in the assessment report of Materialized Views that reference multiple elements.
Fixed issue with the count of Procedures. This fix ensures that the count accurately reflects Top Level Procedures and Package Procedures in the migration, excluding those that are nested.
Enhanced the transformation of qualified names with schemas.
Add count for Dynamic SQL section in Assessment report.
Update the subqueries section of the assessment template to count invalid subquery patterns.
A breakdown of cursor usage patterns in assessment report.
Improved error handling for the process of collecting information for reports.
Added transformation of OPEN FOR statement.
Change default database name behavior to NONE for CLI and UI.
Count table-valued functions and multi-statement functions in Assessment.
Parsing of LOG ERRORS clause in Update and Delete statements.
Enhanced the EWI View count in the Issues report.
Improved counters for tables with BLOB/CLOB datatypes.
Include a count of both table-value and multi-statement functions in the assessment report.
COMMIT and ROLLBACK transformation improved.
COMMIT and ROLLBACK documentation improved
Improve encoding handling infrastructure.
Vulnerability reduction patch included.
Add count of Loops and Cursors to Assessment report.
Add EWI for parameterized cursors when the same record is used in FOR and FETCH statements.
Fix conversion errors.
Transformation added for %Type attribute.
EWI is added when the same parameterized cursor is used in fetch and for operations in the same procedure.
Fix the issue with bindings when a variable has %TYPE attribute as a data type.
Fix conversion errors.
Fix case inconsistencies in record fields.
Add EWI to Oracle Loop
Add EWI to fetch bulk operations
Removes UDFs from not supported functions, they are marked now only with the
Removed the deprecated conversion parameters --snowcript and --disableSnowScript from the CLI.