Precision & Performance – Ispirer Monthly Highlights
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
DB2 for z/OS (OS390) to PostgreSQL
improved conversion of partition by range, ROWID data type
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
