Tools update: Release Highlights
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
COBOL to C#
improved framework for current direction, SPACES LOW-VALUES statements, PERFORM THRU TIMES, string variables in IF
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.