InsightWays

As you know, any project starts with analyzing the source system and careful planning. That is why we not only diligently improve the quality of conversion with our products but also invest in the development of InsightWays. Last month, we improved:

  • Refined Source Version Detection in Reports. InsightWays now provides more precise identification of source database versions, helping you better assess compatibility and potential challenges before migration.
  • Improved customization calculation. We've optimized the way InsightWays calculates customization efforts, offering more precise insights into the scope of manual adjustments required. This leads to more reliable effort estimations, helping teams allocate resources efficiently and plan timelines more confidently.

SQLWays

At Ispirer, we recognize that high-quality database conversion is an ongoing pursuit. Our commitment to delivering smooth, accurate, and efficient migrations drives continuous refinement of migration tools. That is why SQLWays got hundreds of new conversion rules and various improvements, including:

  • Optimized Script Logic for Before/After Import
  • Improved ORACLE Stored Procedure Handling
  • Enhanced Import with Disabled Data Export
  • Separated Data Export & Schema Conversion
  • PostgreSQL Import Optimizations

Conversion improvements for perfect transition in 2025

Oracle to Java

improved conversion of Types initialization of child object, LIKE operator, Arithmetic operations, $$plsql_line conversion, ORACLE_SYSTEM_VIEW option, return value casting

Sybase ASA to Oracle

improvements related to VARCHAR2 type conversion, Writing CLOB to TXT, data migration speed

Sybase ASE to SQL Server

improvements related to data conversion import, "NONCLUSTERED" Primary Keys. Improved conversion of VARCHAR NULL values, "+" operator conversion, DECLARE in trigger, column name 'SWC_Alias'

DB2 to PostgreSQL

improved conversion of Computed columns, DEFINITION ONLY, conversion of LIKE with tables, OID in Where clause, BINARY, VARBINARY, BLOB, INSERT, UPDATE statement. Improvements related to Auto generated timestamp column conversion, recursive CTE. Improved sqlstate usage in triggers

DB2 to MySQL

improvements related to mapping for string data types

SQL Server to PostgreSQL

improved conversion of data type BIT, Type UNKNOWN in function, function fields in views, SELECT * FOR XML PATH in subquery conversion, conversion of STUFF() with FOR XML PATH, DEFAULT VALUES conversion, LOWER, multiple type declaration in returns table statement, OUTER/CROSS APPLY, Declaration of cursor in dynamic conversion, UNPIVOT conversion, Complex PIVOT statement with functions conversion, conversion of sequential table joins, CLUSTERED COLUMNSTORE Index, tabal for alias of table, Extra ';' after drop table statement, table name, conversion to integer, ORDER BY differences, coalesce, TOP conversion. Improvements related to User type variables in procedures and functions, Geography data type properties (lat and long), conversion performance degradation, Return UNION in table function, Select and cursor in dynamic, name for aliases in complex UPDATE, Use functions in views and procedures

MySQL to PostgreSQL

improved conversion of tables with subqueries, JSON functions

Oracle to PostgreSQL

improved conversion of %type, PIVOT conversion, column names, DENSE_RANK LAST, JSON_VALUE, JSON_QUERY and JSON_EXISTS functions conversion, JSON_TABLE conversion, DECODE conversion, Unpivot, JSON_OBJECT conversion, conversion of cursor%ROWTYPE, ExtractValue to xpath conversion, math function REMAINDER, conversion of SYS_CONNECT_BY_PATH with SUBSTR, CTE conversion with PIVOT. Improvements related to Window function in aggregate function, using default schema for object, Long time conversion views, figure out type of a record member in a package, alias in hierarchical table, converting identical object names in different packages, Schema name, data types in PIVOT after conversion

COBOL to Java

improvements related to Procedure Division with USING, calling with USING, Redefine with occurs and type, string type conversion

SQL Server to Oracle

improved conversion of SELECT without FROM, conversion ";" WITH statement

C++ to C#

improved conversion of MakeLower method, Cstring reference parameter in method, Extra semi colons, LPCTSTR cast type parameter, Array struct, char parameter in method, RFX methods, CStringList conversion, Reference type parameter in method

PBScripts to C#

improved conversion of UserObject

Delphi to C#

improved conversion of Unit Create Nil, TScrollBox inheritance, TComponent inheritance, TListBox inherited, TStatusBar inherited, TGroupBox inherited, TSpeedButton inherited, TToolBar inherited. Improvements related to New ext. for designer file

Informix to PostgreSQL

improvements related to Correction extend conversion, converting a character string as an array