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 PostgreSQ
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 PostgreSQL
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
Teradata to Oracle
improved conversion of Query for views
SQL Server to Oracle
improved conversion of ";" WITH statement, conversion of MERGE. Improvements related to converting select from values
C++ to C#
improved conversion of sprintf method, GetWindowText method, Array struct extend, char parameter in method, Extend method sizeof with array
Delphi to C#
improved conversion of TDateTime type
Sybase ASE to PostgreSQL
improved conversion of Row count for refcursor, comparison of two NULLs values. Adding extra square brackets to the schema name in the passed type