Ispirer Toolkit Improvements, July 2023

July 7, 2023

Ispirer Toolkit Improvements, July 2023

It's no secret that we strive to improve our products every day, because we want our customers to be 100% satisfied with the result. Every month we present a list of conversion rules that have been added to Ispirer Toolkit, which means that we are constantly improving the quality of automatic conversion. However, apart from quality, migration speed is a no less important factor for the client.

Migration projects are getting bigger, hundreds of thousands of lines of code already seem to be the norm, and millions of lines of code are no longer an exception. Due to the time consuming nature of these projects, we have been working on accelerating migration for a long time. And today is the day X. Finally, we are pleased to announce that our tool now migrates databases and applications 4 times faster than before. Thanks to the optimization of conversion rules and code refactoring, now the conversion of 11 thousand lines of code takes just 1 hour.

One more game-changing feature that our developers added to Ispirer Toolkit is the conversion of embedded sql in java .properties files. Now, in addition to Java files, our tool is able to convert embedded sql in .properties files as well for Java to Java direction (Oracle to PostgreSQL).

What is more, our experts extended the Ispirer Toolkit parser that collects information about objects and relationships between them from various sources, including Informix, COBOL, Interbase, Oracle, DB2 z/OS, C#. Now it ensures even better quality of collecting data about various objects and code structures.

Conversion improvements:

  • Db2 to SQL Server: improved conversion of GROUP BY clause, CTE in views, ROW_NUMBER(), COMMENT statement, DELETE statement, UPDATE statement.
  • Firebird to PostgreSQL: improved conversion of bit_and() and bin_or() functions, ASCII_VAL(), bin_shl(), bin_shr(), returning_values option, hierarchical queries, CURRENT_TIMESTAMP.
  • Informix to PostgreSQL: improved conversion of insert into serial column, on exception construction, foreach execute.
  • MariaDB to SQL Server: improved conversion of AUTO_INCREMENT option, DATETIME values, zero date value.
  • SQL Server to DB2 LUW: improved conversion of Update with joins.
  • SQL Server to SingleStore: improved conversion of error handling, substring function, alter table statement, patindex(), STUFF(), getdate(), TRY_CONVERT(), functions with DML statements to procedures, CROSS APPLY, OUTER JOIN.
  • Oracle to PostgreSQL: improved conversion of string literals. Added handling for a conditional compilation.
  • Oracle to Java: improved conversion of commit and rollback for Spring, input and output parameters, BULK COLLECT, cursor logic when converting to hibernate, date handling, SET TRANSACTION, autonomous transactions, abs(), for loop constructions, %rowtype of cursor, usage of TO_CHAR and TO_DATE, CASE WHEN constructions, arithmetic operations between strings and number values.
  • Teradata to SQL Server: added conversion of Period data type. Improved conversion of date and time arithmetics, format, ftell options, feof, fgets, fread, fputs, fwrite methods, comments.
  • C to C#: improved conversion of strtok method, macroses, va_start va_arg va_end macroses, variables of struct type, pointer ->, void pointer, procedures and functions with variable number of parameters, va_list type, global variables usage, define directive.
  • C# to Java: added conversion of IS OBJECT, ToString(), sealed class, equals() method, overridemethod(), using block.
  • Delphi to Java: improved conversion of enum data type, override and abstract functions, integer boolean and string data types, if, repeat while for constructions, case statements, ToString(), Exit(NIL), multidimensional arrays, FileSize, call of procedures and functions, nested functions. Added support for class inheritance, controller generation, class variables, TADODataSet, TADOConnection.
  • Java to Java (Ora to PG): added conversion of embedded sql in properties files.

Try out the latest features of Ispirer Toolkit by downloading its free demo license!

Discover more about Ispirer products and solutions!

Find Out More