Reading time: 3 min

Published September 26, 2024

Key Features of This Release

In September 2024, we managed to reach several milestones:

  • AI assistant release. On September 10, we announced the AI integration with Gemini. In brief: this new feature of SQLWays Wizard allows cutting 80% of the time for post-migration code optimization. You can find a detailed guide on how to use AI Assistant in our blog.

AI time savings, September 2024

  • Updated frameworks for Java and Delphi to C# direction. To improve the conversion quality even further, we provide additional frameworks. Such an improvement brings to the table the highest conversion quality for Java and Delphi to C# directions.
  • Updated the list of system schemas in Oracle queries. The update enhances the user experience by simplifying the choice of objects for conversion, users do not have to exclude system objects any more. The tool excludes them by default.

Improving Conversion For a Seamless Transition

Major conversion enhancements:

Oracle to Java

improved conversion of Generation of proxy, Types object type inheritance when there is type body, query parameters, Number literals conversion, CASE WHEN operator, Use with CONSTANTS, function SetConcat, Comments, Cursors, SUBTYPE of Varray conversion, COMMA_TO_TABLE procedure, COLUMN_VALUE function. Implemented conversion of following types: dbms_sql.number_table, dbms_sql.date_table, dbms_sql.clob_table, dbms_sql.timestamp_table, dbms_sql.varchar2_table, dbms_utility.lname_array, Dbms_utility.uncl_array.Improvements related to TransactionStatus declaration, exception setConcat, Unregistered function runtime error, using keyword as name

DB2 to PostgreSQL

improved conversion of query for ColumnList, cursors in IF statements in procedures, cursor variable with Table option

SQL Server to Oracle

improved conversion of following functions: ATN2, OBJECT_NAME, ORIGINAL_DB_NAME, SCHEMA_ID, SESSION_USER, SMALLDATETIMEFROMPARTS, SQUARE, SUSER_ID, SYSUTCDATETIME, TIMEFROMPARTS, TODATETIMEOFFSET, USER

SQL Server to MySQL

improved conversion of CONVERT function for string trimming

SQL Server to PostgreSQL

improved conversion of SELECT FROM OPENXML, IDENT_INCR function, Exec procedure with default values, function TranslateQualifiedIdentifier, conversion of $$ in dynamic variables, CONTEXT_INFO function, conversion default values, ON TRUE in the expressions LEFT JOIN LATERAL and CROSS JOIN LATERAL, QUOTE_IDENTIFIERS option. Improvements related to converting declare namespace statements in xquery, conversion schema name UNNEST and STRING_TO_ARRAY

Oracle to SQL Server

improved conversion of Tables with identity columns in Oracle 12.1

Oracle to PostgreSQL

improved conversion of Nested Aggregate Functions, Hierarchical queries conversion, CONNECT_BY_ROOT, conversion UTL_I18N.UNESCAPE_REFERENCE, TO_NUMBER, UTL_FILE conversion, JSON_VALUE conversion, multiset conversion, PrepareObjectNameDest function, AddDepend function. Improvements related to using of member/static functions, converting TYPE is RECORD and PIPELINED functions, duplicated calls in sqlways_all.bat

C++ to C#

improvements related to Inheritance. Improved conversion of delegate var, typedef struct, Classes, main method, conversion typedef iterator, iterator to int, Constants from file, Enum from other header file, fprintf method, char in case operator

Delphi to C#

improved conversion of SystemColors, FormProps BorderStyle and Position, FormProps FormStyle, FormProps Align, Create with params, TADOConnection Connected property, TClientDataSet First, TDataSet as Event Param, TClientDataSet Eof, String ToDouble function, TMouseButton mbLeft, FormProps BorderIcons, TRadioGroup ItemIndex set and get, Const string in not unit function. Updated framework generated by the tool.

Informix to PostgreSQL

improved conversion of Named Notation when calling functions, Select from OUTER without condition, select from OUTER table, identity serial column, Trigger with table name conversion, export of BYTE column with null values

Delphi to Java

improvements related to comparing map and string

COBOL to Java

improvements related to generation classes for the structures