Reading time: 3 min

Published January 13, 2025

Release highlights

Every migration is a step forward—a chance to leave outdated systems behind and embrace better, faster tech for bigger market shares. Our latest updates target the tiniest details of the migration process to make it. Let's dive in:

Parser upgrades

With updates for Oracle, PostgreSQL, Informix, C#, MS SQL Server, DB2, Sybase ASA, Cobol, and Java, our parser is now sharper and more versatile.

SQLWays Wizard

Migrating databases is no small task, but SQLWays Wizard makes it manageable—and now, even better:

  • Smarter import process, saving you time and effort.
  • Small tweaks to the interface make status updates clearer.
  • Enhanced global mapping for smoother results.
  • New import approach for Linux versions.

Assessment Wizard

A good migration starts with understanding what's ahead. The Assessment Wizard now comes with:

  • Cleaner design and easier navigation for less guesswork.
  • More detailed complexity analysis for Informix to SQL Server, or tackling Google Cloud for SQL Server, Azure SQL Database, or Synapse Analytics.

The assessment reports now give a clear breakdown of the selected objects, their structures, and how many there are. They also show the complexity levels for individual structures, objects, and the entire scope.

Users can now evaluate migration projects, spot potential challenges, and understand the effort needed. The reports also highlight how efficiently the Ispirer Toolkit can handle the migration, including:

  • Estimated out-of-the-box conversion rates.
  • Potential improvements with customizations.
  • Suggested customization needs.
  • Approximate number of structures needing manual fixes.

With this info, you can quickly estimate your migration project and see how the Ispirer Toolkit can save time for lower costs.

Assessment Wizard report

Targeted migration directions: easier conversions in 2025

Specific directions also come with a few upgrades:

Oracle to Java

Improved conversion of BULK COLLECT, record to record casting, TO_DATE function, operations with dates, NULL as default value. Improvements related to calling of overloaded methods.

Sybase ASA to Oracle

Improved conversion of LONG VARCHAR column in EXISTS, IFNULL, table names conversion.

Sybase ASE to PostgreSQL

Improvements related to Auto-truncate if data for insert exceeds varchar defined length. Improved conversion of expression LTRIM(RTRIM(‘’)) IS NULL, IN predicate with NULL.

DB2 to PostgreSQL

Improved conversion of DELETE statement with FETCH and LIMIT clauses, Temp tables conversion. Improvements related to Deletion of VARCHAR type dimension on return from SETOF-function.

MS SQL Server to PostgreSQL

Improvements related to the unfinished process of conversion, reserved keywords as filed name in RETURNS TABLE, and before-after script logic. The conversion process is hanging on. Improved conversion of schema mapping for UDT, SP, UF, and Trigger's function, reserved keywords.

C++ to CS

Improvements related to Structure type using, Class using, and extern user type conversion.

Informix to PostgreSQL

Improved conversion of SERIAL8 and BIGSERIAL data types, conversion of a FOREACH loop variable, DATETIME type, RETURN. Improvements related to date-date result.

Oracle -> PostgreSQL

Improved conversion of OUTER APPLY, DBMS_SQL conversion, FETCH cursor BULK COLLECT INTO, conversion of EXCEPTION_INIT, conversion for type is table index by varchar. DDL refinement for a function whose body isn't wrapped in BEGIN...END; New lines in check constraint; Conversion for record table to refer to fields in a record for packaged variables; Conversion of NLS, conversion of NESTED TABLE .. STORE AS, Schema before UNNEST, NESTED TABLE clause of CREATE TABLE statement; Conversion of a global variable of type associative table with collection methods. Improvements related to the assignment of a collection constructor to a package variable, adding a schema to dynamic statements. Added nested procedure with PRAGMA AUTONOMOUS_TRANSACTION to dblink conversion.