Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

SQLWays 3.8 facilitates conversion of server-side applications from Informix to all major databases

January 11, 2005

SQLWays 3.8, new release of Ispirer Systems’ database migration software, demonstrates enhanced ability in business logic conversion, transferring stored procedures and triggers from Informix to Oracle, Microsoft SQL Server, IBM DB2, Sybase and MySQL.

Ispirer Systems Ltd., a provider of comprehensive and multi-platform database migration solutions, has released the new version of its automated migration software SQLWays 3.8.

The new release of SQLWays is based on Ispirer’s recent achievements in converting database business logic and makes possible the migration of stored procedures and triggers from Informix Dynamic Server to Oracle PL/SQL, Microsoft SQL Server and Sybase Transact-SQL, IBM DB2 and MySQL.

Conversion of business logic is the most complex part of database migration. Its rapid and cost-effective implementation requires a specialized automated solution. The market shortage of such solutions for Informix has been an obstacle to converting this database to other platforms at a reasonable cost and within short deadlines.

SQLWays 3.8 considerably facilitates this task being enhanced to automatically convert most language constructions including many specific Informix features, in particular, the unique ability of Informix to return intermediate results from a procedure and then resume the procedure's execution from the previous return point.

Besides facilitating business logic conversion, SQLWays 3.8 easily migrates Informix data and schema including tables, views, indexes, keys, relationships, constraints, and various other table properties, provides advanced data type mapping and resolves identifier and reserved word conflicts. Being capable of solving major migration issues and harmonizing multiple minor differences between Informix and other databases, SQLWays is clearly distinguished from data transfer and ETL tools focused merely on data and leaving many time-consuming conversion tasks to be handled manually.

At the same time, unlike complicated solutions based on a combination of separate porting tools and requiring considerable manual effort for integration (data transfer/ETL, ER diagram for schema conversion etc.), SQLWays is used as an integrated solution that automatically solves all modifications between interdependent tables, views and procedures.

"Companies are not able to enjoy the advantages of new technologies merely through a syntactically correct conversion and emulation of their existent applications against new database management systems," said Dmitry Tolpeko, Product Manager at Ispirer Systems Ltd. "At the same time, every company strives to preserve its investments in the current IT infrastructure."

"We are committed to providing a migration solution that can enable the current applications of our clients to draw the maximum benefit from the latest database versions and offering our customers an actual opportunity of efficient IT modernization," added Tolpeko commenting on the recent product release.

Besides migrating from Informix, SQLWays easily transfers data, database schema and business-logic between Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL and other databases.

About Ispirer Systems

Ispirer Systems Ltd. specializes in automated cross-platform database migration from all major databases to the newest database management systems developed by IBM, Oracle, Microsoft, Sybase and MySQL. The company successfully works in the field of database migration since 1999. Its customers include world leading financial, social and educational institutions and global corporations.

To learn more about Ispirer Systems Ltd, its migration solution and services, please visit http://www.ispirer.com.

 
Testimonials
July 25, 2017Open Business Solutions, United Kingdom
IBM DB2 AS/400 to Oracle

"We had a requirement to decommission an IBM AS400 for a customer and archive all the data to an Oracle Database. ...

June 24, 2017Kellenberger, Switzerland
Delphi to C#.NET

Dear Ms. Shavel

"I would gladly provide you with our experience with Ispirer conversion service. We had an old Borland Delphi 7.0 project, which was brought back to life. ...

Case Studies
July 5, 2017Oracle Forms to Java, United States
The feasibility of automated Oracle Forms to Java migration using Ispirer MnMTK has been proved!


In early 2017 Ispirer Systems was contacted by one of the global information technology...

...

May 1, 2017Oracle to PostgreSQL, Russia
Professional services of migrating Oracle packages and stored procedures to PostgreSQL.


At the end of 2016 Ispirer Systems carried out migration services for one of the Russian system...

...

Feedback

Testing for demo version has been successfully done, migrated all tables and data with total 2Gb.

Read more
Industry Events