Parser upgrades

Let us remember that a parser is the technology that makes it possible to translate one database into another. All the upgrades help to have better conversion quality and adaptability. This month the parser was updated for the following technologies: DB2, Oracle, Sybase ASE, MS SQL Server, C#, Sybase IQ, COBOL, PostgreSQL, Informix.

The Ispirer experts also improved conversion of generated classes for Java as a target (Updated Plsqlutils, DBMapper, Collect, added XMLUtils).

SQLWays

In terms of database migration, SQLWays Wizard now has improved data mapping, upgraded schema and data export processes. Our experts contributed to the import process as well:

  • Improved import under ubuntu
  • Enhanced import data without generating DDL
  • Improved information about Import errors
  • Added support for MariaDB, SingleStore.

CodeWays (NGLFly Wizard)

NGLFly Wizard is the tool that is responsible for converting applications. This month our experts made it possible to improve file selection, reading and checking licenses, switching between pages.

Conversion improvements

Oracle to Java

improved conversion of TO_NUMBER function, default parameters conversion, order of parameter, BULK COLLECT, UDF in ESQL, TO_DATE function, BLOB type. Improvements related to Extract SQL into single Class, collection in query, calling of overloaded method, record to record casting, functions using the STANDARD package prefix. Replaced PlsqUtils.toOracleArray to DbMapper.mapJavaCollectionToDbArray

Teradata to Oracle

improvements related to conversion Table, size of imported views

Sybase ASE to SQL Server

improved conversion of Return, declare cursor, Transaction conversion, conversion Set Nocount. Improvements related to missing double dot for column name in absolute path to table; missing EQUAL sign for parameters; import default

DB2 to MySQL

improvements related to Keys conversion via Logical files in additional to indexes, Option value for CONVERT_LF_KEYS, CURRENT_TIMESTAMP conversion

DB2 to PostgreSQL

improved conversion of deterministic functions, Temp tables conversion, VARCHAR type, conversion of DELETE statement with FETCH and LIMIT clauses, conversion CURRENT TIMESTAMP. Improvements related to modifying the UNIQUE constraint request

SQL Server to PostgreSQL

added more custom objects for import. Improved conversion of PIVOT with CTE; DB_ID, OBJECT_SCHEMA_NAME, OBJECT_NAME functions conversion; SELECTs with variables, conversion of RIGHT and LEFT functions, OUTER APPLY, CROSS APPLY, With CTE Delete conversion, conversion of DML with CTE, INFORMATION_SCHEMA, String Lower Register conversion. Improvements related to import table name, creating indexes on tables in a file group; schema creation in dynamic, adding prefixes to swf-function parameters, Extra schema name for crosstab; schema mapping for UDT , SP, UF and Trigger's function; reserved keywords

Sybase ASA to Oracle

improved conversion of IFNULL, CLOB datatypes conversion, DATEFORMAT function with char parameter conversion, conversion SWV variable name, conversion LONG VARCHAR column in EXISTS, table names conversion. Improvements related to License issue with size export CLOB/BLOB data; LEFT JOIN and LEFT OUTER JOIN with subquery inside ON condition

Progress to PostgreSQL

improved conversion of tables with minus('-') in name

Oracle to PostgreSQL

improved conversion of Math functions, table schema, function with %ROWTYPE, conversion of cursor%ROWTYPE, Rownum with where, Alias in ORDER BY, RECORD type, conversion of global variable of type associative table with collection methods; OUTER APPLY, DBMS_SQL conversion. Improvements related to incorrect order of code generation in the file with the list of constraints, Brackets around record variable in package; missing ON TRUE after OUTER APPLY with LEFT JOIN; DDL refinement for a function whose body isn't wrapped in BEGIN...END; assignment of a collection constructor to a package variable. Added nested procedure with PRAGMA AUTONOMOUS_TRANSACTION to dblink conversion

SQL Server to Oracle

improved conversion of INSERT multiple rows

C++ to C#

improved conversion of union, char parameter in method, method sizeof with array, fopen method. Improvements related to Base conversion for constructor class with parameters inherited base class, define directive with arithmetic operations; Structure type using, Class using, using system header files

Delphi to C#

improved conversion of BeginPaint function, Align, BorderStyle, BorderIcons, Position, TRadioGroup form call, String function ToInteger, GetHBITMAP function, MessageDlg, LoadFromStream function, ReleaseDC function, Execute function, Recordset functions, OpenSchema function, LoginPrompt property, ADOConnection provider, TClientDataSet Active property, LoadFromFile function, TADOQuery With AddParameter, SaveToStream function, Unit. Improvements related to MouseUp using

Informix to PostgreSQL

improved conversion of BIGSERIAL type, conversion of units in DATETIME type, temporary table reference conversion, NextVal and CurrVal as identifiers conversion, RETURN in the exception section, FOREACH loop variable, DATETIME type, Standard math functions conversion. Improvements related to columns with dblinks in foreach select, Extra CAST in case if complex select with union in 'IN' predicate, type mapping for INT8.