August 9, 2024
Previous updates to Ispirer products focused heavily on migration quality improvement, which is a key factor our customers value. While conversion quality remains crucial, user experience is equally important for long-term success.
This month, our team focused on enhancing the user experience and implementing several important updates to make the user experience with Ispirer products as smooth as possible. They include:
- the test connection button
- status updates after rerunning conversions
Conversion hasn’t been left unnoticed. The technologies that gained most attention to this time are:
- Oracle,
- PostgreSQL,
- SQL Server,
- Informix,
- Java,
- Informix,
- C and C# languages.
All of these migration directions have got a number of new conversion rules that will have an impact on improving conversion quality. For example, the data migration speed from Oracle to SQL Server has increased from 15 GB/h to 64 GB/h.
Assessment Wizard has received a significant enhancement in the latest release with a new customization counting method. This improvement allows for a more accurate analysis of database characteristics, ensuring precise predictions of the customizations needed to achieve up to 100% automation.
Conversion improvements:
- Oracle to Java: improved conversion of return statement, Numbers and Dates, named parameters, function SetConcat, %rowtype record, BigDecimal, ifNullElse, Numbers int act as BigDecimal conversion, Cursors, CRUD_EXTRACTION option, Comments, Exception when NO_DATA_FOUND, Map option. Improvements related to calling of procedure via "THIS" keyword, calling local method as global with wrong naming, calling local method issue if converting with statistics, calling constructors, calling member procedure with SELF parameter, calling only const variable from a proxy. Improved conversion of OUT parameters. Improvements related to Generating class for subtype from statics, Generating proxy as DEFAULT parameter. Updated SQLCursorHandler class in Java framework for Oracle. Resolved cursors conflict
- Sybase ASE to PostgreSQL: improvements related to password authentication,delete from join on the table itself and PRINT specific use case, order by multiple columns conversion
- SQL Server to PostgreSQL: improved conversion of swf_to_timestamp function, OUTPUT condition in MERGE method, converting OUTPUT condition in MERGE method, swf_patindex, MERGE operator, TRY_CAST conversion, JSON_QUERY method, json_value conversion, converting double-quoted aliases, MERGE with SELECT, converting OUTPUT (without INTO) condition in INSERT method, OPENJSON, converting XML.nodes(), update with output clause, converting xml.value, @@PROC_ID conversion, conversion default values. Added default to the result refcursor
- Oracle to SQL Server: improved conversion of sequences, tables with identity columns conversion
- Oracle to PostgreSQL: improved conversion of function DBMS_XMLGEN.GETXMLTYPE, Exceptions handling, conversion of random string generation, function DBMS_LOB.FILEEXISTS, %ROWTYPE in type conversion, conversion of DBMS_SQL.RETURN_RESULT, Hierarchical queries conversion, Member/static procedures and functions conversion, Arrays conversion, Index (not UNIQUE) on partitioned table, RAISE exception without parameters. Improvements related to Oracle syntax outer joins (+) conversion, Type of package variable
- C++ to C#: improved conversion of ACHAR, String in if, free method
- PBScripts to C#: improved conversion of useEffect for sru in tsx file, tsx file for commandbutton sru case
- Informix 4GL to Java: improved conversion of High function of Integer
- Informix to PostgreSQL: improved conversion of FREE cursor and prepared query statement, RETURNING table without RETURN, Procedure with over 100 params and like, Trigger functions, global vars conversion, casts in return query, foreach in inner block with exception, ON EXCEPTION in WHILE loop and MATCHES conversion, Insert into serial column with select
