Migration Made Simple: Monthly Tool Updates

Parser upgrades

This month, the Ispirer team has significantly updated the parser for the following technologies: Java, COBOL, SQL Server, PostgreSQL, C#, Informix, Sybase ASA, and Oracle. Due to constant improvements to the parser, our products ensure better conversion quality and adaptability.

SQLWays

Automating database migration is not an easy task; that's why our experts do their best every day to deliver excellent conversion results. The latest updates to SQLWays are the following:

Improved import notifications
Enhanced Oracle procedures extraction
Upgraded data and ddl export processes
Improved export of sequences from DB2 database
Added multiprocess conversion from Sybase ASA to Oracle

Migration quality has always been our number one priority, and we prove it by monthly parser upgrades. But what about conversion speed? We care about our clients' time savings. To make conversion even faster, we implement multiprocess conversion. Thanks to the update, SQLWays migrates Sybase ASA to Oracle twice as fast.

CodeWays (NGLFly Wizard)

CodeWays is a product that automates application migration from one programming language to another. We are constantly working on improving the tool's user-friendliness and functionality to make working with it smooth and user-friendly. In February, we improved the conversion reports, which ensure a detailed view of the conversion results and provide crystal-clear visibility with full control over the process.

Conversion improvements for perfect transition in 2025

Oracle to Java

improved conversion of collection in query, function conversion, Spring ".class", Updated NestedCollection class in Oracle framework for Java

Sybase ASA to Oracle

improved conversion of BIT type, conversion of indexes with the same names, CLOB data type conversion, procedure name, column IDENTITY query, type UNIQUEIDENTIFIER, WITH CTE as Subquery conversion, SWA aliases. Improvements related to Line overflow (>3000 characters). Added info for TranslateNameExt

Sybase ASE to SQL Server

improved conversion of Codepage option

DB2 to PostgreSQL

improved conversion of LIKE with tables, Extra OID in Where clause, CURRENT TIMESTAMP, DEFINITION ONLY. Improvements related to adding a comment line on view.

DB2 to MySQL

improved conversion of TIMESTAMP column WITH DEFAULT/GENERATED ALWAYS

MySQL to PostgreSQLL

improved conversion of JSON functions

Sybase ASE to MySQL

improvements related to name normalization

SQL Server to PostgreSQL

improved conversion of Extra tabal for alias of table, Extra ';' after drop table statement, Extra schema name for temp tables, cursor opening, Extra comma in list of fields for SWV_SelectAssignRec, FOR XML with CTE, conversion for CONVERT_SP_RETSTATUS_OUTPARAM and CONV_ALL_PROC_TO_FUNC options, conversion into func with SETOF; INSER, DELETE and UPDATE with OUTPUT, Select and cursor in a dynamic, conversion of STUFF with FOR XML PATH, conversion String Lower Register, conversion select. Improvements related to missing Comments

Oracle to PostgreSQL

improved conversion of SYS_CONNECT_BY_PATH with SUBSTR, conversion PIVOT, types from other packages conversion, conversion Unpivot, %rowtype conversion in RETURNS clause of a function, conversion adding ON TRUE after OUTER APPLY with LEFT JOIN, conversion of math function REMAINDER, ExtractValue to xpath conversion. Improvements related to Window function in aggregate function, missing columns if UNPIVOT used in WITH CTE, Function name is missing, alias in a hierarchical table