Reading time: 5 min

Published November 18, 2024

Assessment Wizard

Assessment Wizrad upgraded

Assessment Wizard now evaluates migration complexity for Informix to PostgreSQL. Its assessment reports deliver detailed insights into selected objects, their structures, and quantities. These reports also highlight the complexity levels of individual structures, objects, and the overall project scope.

The tool identifies varying levels of automation complexity—low, medium, and high—based on the diversity of constructs. This information is invaluable for analyzing migration projects and anticipating potential challenges. Additionally, the report evaluates the efficiency of Ispirer Toolkit, providing an approximate out-of-the-box conversion rate, potential conversion rates with customization, suggested customizations, and the estimated number of structures needing manual adjustment.

With these features, users can quickly estimate migration efforts and clearly see how the Ispirer Toolkit reduces migration costs.

SQLWays Wizard

  • Added multiprocess conversion for MySQL to PostgreSQL and MySQL to MS SQL Server. Now, the conversion process is much faster than migrating in one flow.
  • Performance optimization of GUI, UX improvements on the Migration Reports page, and more detailed information about errors on the editor page in the output window.
  • Performance optimization for Reading Database Structure for SQL Server, Oracle sources. The time for reading information about objects from the source database has decreased several times. But in the conversion process, the overall performance improvement is 10-15%.

NGLFly Wizard

Improvements related to result page information and project file generation for VS 2022 options(Delphi to C# ). Automatic generation of a project file, which simplifies working with results. The user no longer needs to create the project in the new IDE; the tool makes it. The user only needs to open it and can work with the results.

Major conversion enhancements:

Oracle to Java

improved conversion of SELF, dbms_lob.read function conversion, LENGTH function, Number type, Cast_TO_RAW function, constructor conversion, CASE WHEN operator, ternary operator, NOT INSTANTIABLE and OVVERIDING keywords, UDF in ESQL, REGEXP_INSTR function conversion, Spain symbol in name of SQL parameter, xsltKeyFunction. Improvements related to calling proxy in object type, variables scope conflict, synonyms support implementation, Record to record casting extension, a mapper for an object with the inner collection and inner object, subtype on table record, mapper generation, long conversion of packages.

Sybase ASE to Java

improved conversion of esql.

MySQL to PostgreSQL

improvements related to a request to unload CHECK constraints, сonversion of the system () function.

SQL Server to PostgreSQL

improved conversion of quoted schemaname, data conversion for SQL_VARIANT, refcursor conversion, conversion in case of no prefix for params, ON TRUE for LEFT JOIN LATERAL, in _rs type, JSON_MODIFY function, Try-catch conversion. Improvements related to Mem_busy error during table conversion.

Oracle to MySQL

improvements related to package conversion.

MySQL to SQL Server

improved conversion of ENUM and SET.

Oracle to PostgreSQL

improved conversion of ColumnList query, dynamic conversion, %ROWTYPE type, table index, conversion DROP, and MODIFY. Improvements related to unnecessary quotes near CROSSTAB, Quotes in PARTITION BY clause of CREATE TABLE, assigning a value from function to a pack variable, Type mapping falls back to a wrong type, procedure name conversion by option.

SQL Server to Oracle

improved conversion of SELECT INTO statement with variables and the conversion of ISJSON.

C++ to C#r

improved conversion of typedef, Array struct, const char pointer, char pointer temporary variable, char pointer temporary variable extend.

COBOL to C#

added StopRun method to Compatibility.

Delphi to C#

improved conversion of ASCII to Text, Inheritance from TStringGrid, Constructor inheritance, TStringGrid inheritance props via object, String ToInteger function, TADOConnection using, bool to string with param, Log function out of Form, Date functions ToString, TCheckListBox items property, TCheckListBox Checked property get, TCheckListBox Checked property set, TCheckBox AllowGrayed property, TCheckBox State property, Private controls, TRadioButton Checked property, TBevel Form Add Controls, TLabel WordWrap property, TCoolBar Control, TBevel BorderStyle, TSpeedButton Font, Quotes in caption, TCheckListBox CheckOnClick property, TDualFaceBtn control, TDrawGrid control, Lines. Add function, DeleteObject Using, OpenClipboard function, EmptyClipboard function, SetClipboardData function, CloseClipboard function, ParamStr checks if exist — improvements related to access to controls for another unit via the form name.

Informix to PostgreSQL

improved conversion of sign function. Improvements related to lost function names.

ESQL in ASP.NET

improved conversion of function to_date and quotes handling.