August 7, 2023
For us at Ispirer, it is important not just to set the bar for the “good quality” of our services, but also to constantly raise it. In pursuit of this goal, we have made accelerating migration and saving your time our strong suit. This month we have made every effort and accelerated data migration for the following directions:
- SQL Server to PostgreSQL. General migration speed due to multiprocess conversion is 97GB/h.
- Oracle to PostgreSQL. General migration speed due to multiprocess conversion - 59GB/h.
SQLWays Wizard has got some major improvements as well.
- Now it supports PostgreSQL 15 and 16 versions as a target.
- Updated comprehensive reports for migration to Oracle are now available. Reports now contain info not only about errors, but also about warnings that may appear during the import process.
A jaw-dropping feature of Nglfly Wizard is now live. Our developers have added a framework for Informix 4GL to Java direction. Now the framework simplifies the emulation of code structures that do not have direct equivalents in Java.
Assessment Toolkit has also some major improvements. Now comprehensive reports for SQL Server to PostgreSQL direction contain information about the migration complexity of statements, objects and schemes. Besides, Ispirer Toolkit Efficiency Assumption provides info about automation level and the amount of necessary extensions. Also in the Migration Services Proposal section there is an approximate estimate of the labor costs for performing the migration.
As for migration quality, we continue to work hard to improve the results of automatic conversion. The process of adding new conversion rules is continuous. The following migration directions received updates this month:
- DB2 to PostgreSQL: improved conversion of ENCRYPT() and DECRYPT_CHAR(). Added the possibility to create CREATE_PGCRYPTO_EXTENSION extension.
- DB2 to SQL Server: improved conversion of CEIL\CEILING, IN operator, partition by, update statement with multiple columns with schema names, export commands inside scripts, digits(), cast with dates.
- Firebird to PostgreSQL: improved conversion of ROW_COUNT, concat with nulls, calls, for select do suspend, distinct(), parameters with default value.
- Informix to PostgreSQL: improved conversion of insert into serial, UPDATE statement, UPDATE STATISTICS.
- MariaDB to SQL Server: improved conversion of zero dates in DATETIME columns.
- Oracle to PostgreSQL: improved conversion of user exceptions.
- Oracle PL\SQL to Java: improved conversion of BULK COLLECT, triggers with UPDATING, OUT and IN OUT parameters, collections, UTL_SMTP. Added possibility to use change logger framework.
- Progress to PostgreSQL: improved conversion of arrays - nulls and bunary data.
- Sybase ASE to MySQL: improved conversion of STR_REPLACE().
- SQL Server to PostgreSQL: improved conversion of anonymous code blocks, cast with datetime and zero to datetime.
- SQL Server to Sap Hana: improved conversion of STUFF(), functions structure.
- SQL Server to SingleStore: improved conversion of OUTER APPLY, primary keys.
- Teradata to Azure SQL Server: improved conversion of GROUP BY with case.
- C# to JavaScript: added conversion of a connection string, string.Concat, references to base class, Padding, parameters with defaults, str.Append, str.Insert, str.Remove, assignment logic.
- Delphi to C#: added conversion of .FixedCols, TStringGrid and properties, TDateTimePicker and properties, TChart, TProgressBar, TStatusBar and properties, TSpinEdit and properties, StatusStrip, CheckBox.State, Application.OnHint, TStopwatch, button.click, .Split, ERROR_ALREADY_EXISTS, Application.ExeName, EDatabaseError.
- Delphi to JavaScript: improved conversion of ADOCommand for select/update/insert/, variables, function\procedure calls, variables/constant declaration, raise exception, longint type, extended type, enum type, variable parameters.
- Informix 4GL to Java: added conversion of array of string, system arguments, exit program, error logger. Improved conversion of arrays, reports with variables, main function, cursor usage, date() method, Globals, if construction, connection string, DATABASE statement, cast operator, err_get(), set isolation, unload, records in report, string comparison, cursor usage, date(), array comparison, Load statement, SQLC usage.
- Progress 4GL to C#: improved conversion of IsEnabled, HIDE, VIEW , MESSAGE, LENGTH(), SUBSTR(), LOAD-IMAGE().
Try out the latest features of Ispirer Toolkit by downloading its free demo license!
