As a general rule, automation streamlines the process of migration between source and target endpoints that use different database engines. In addition, it mitigates risks, prevents business disruption, and eradicates human error. But what stands behind all of that? Behind all the results stands a team of seasoned database specialists, developers, engineers and testers. Ispirer experts analyze our migration products every day, test new migration features, and make improvements to automatic migration quality. All of our efforts are directed at ensuring that the migration of databases and applications goes as smoothly as possible.
- En
-
What's new in Ispirer Tools, January 2023
January 11, 2023
Over the past month we have been working hard to improve the user experience of all our tools. Assessment Toolkit now generates extended reports for Informix as a source. Now information about statements, constructions, SQL functions and system objects is collected automatically which speeds up the process of assessment considerably. Ispirer Toolkit now provides migration tips which significantly simplifies the tuning process.
Conversion improvements:
- DB2 to PostgreSQL: improved conversion of FOR constructions, temporary tables conversion, DBMS_OUTPUT()
- Informix to PostgreSQL: improved conversion of DATETIME data type.
- Microsoft SQL Server to PostgreSQL: improved Conversion of Check Constraints, Convert(), object_id() functions, INSERT Select, OPENJSON(), OUTER APPLY(), recursion in triggers, triggers on multiple events.
- Microsoft SQL Server to Oracle: improved conversion of Alter Column statement.
- Sybase ASE to PostgreSQL: added conversion of Compare() function.
- Oracle to MySQL: improved conversion of Cursor variables, package level data types, ref cursor data types.
- Oracle to PostgreSQL: improved conversion of Cursors with parameters, DBMS_OUTPUT package, Update with Select statement, TO_CHAR(), getStringVal(), extractValue(), ROLLUP() functions.
- Oracle to Teradata: improved conversion of FOR LOOP construction.
- Microsoft SQL Server to Java: added conversion of OBJECT_ID(). Improved conversion of concat operator.
- Oracle to Java: improved conversion of Hibernate Target API, call UDF inside Embedded SQL, Floor(), Ceil(), GoTo, Functions calls inside expression, Select Into records, Fetch, number comparison with strings, records of date type, nested procedures, %ISOPEN attribute, date to string casting, NUMTODSINTERVAL(), NUMTOYMINTERVAL(), TO_DSINTERVAL(), TO_YMINTERVAL(), Catch blocks, %ROWTYPE.
- COBOL to C#: improved conversion of Decimal and Char, Long, Int, String variables. Added conversion for Accept statement, IS Numeric and Not Numeric constructions. Improved migration process in multiple streams.
- Delphi to C#: improved conversion of File data type, variables of Time data type, BlockRead() function.
- VB to C#: added conversion of DATEDIFF(), TimeString and DateString, TimeOfDay, DateAndTime.Timer, Today variables, DDB(), FV(), IPmt(), IRR(), MIRR(), NPer(), NPV(), PMT(), PPmt(), PV(), Rate(), SLN(), SYD(), WeekDay(), DateCerial(), MonthName(), WeekdayName(), Beep(), QBColor, IsArray, ISDBNULL, FileExists(), CType, Functions, Menu, MenuItems, ImageList For Toolbar, Toolbar Buttons, OleColor type, operations with Enum type, Font, Mask, ForeColor, Enabled properties, CObj. Improved Fields initialization when structures are used, ElseIF construction, Constant conversion,
- Informix 4GL to Java: added conversion of Execute with Insert, Select Into, Run, Insert, Execute procedure using into, Update, Whenever, GoTo statements, UNITS with date time parts, mdy(), extend(), return, ** operator, CALL, Allocate, Resize Array, Deallocate array, current, today.
