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.

September 30, 2015LoadTrek Software, United States
Microsoft SQL Server Migration to MariaDB

"Recently we have had the opportunity to work with the Ispirer team on the migration of a Microsoft SQL Server database into MariaDB. The migration...


September 15, 2015Splice Machine, United States
Oracle PL/SQL to Splice Machine

"As part of an extensive project we were faced with a complex migration task that was vital to the successful deployment of our database server technology in an...


Case Studies
November 26, 2015Progress to Microsoft SQL Server Migration, United States

A well established manufacturer of high-end critical components and utility systems for primary processing industries over the globe. The company develops and manufactures equipment used for...


November 25, 2015Delphi to C#.NET Application Migration, United States

This time the client of Ispirer was an accomplished enterprise from the U.S. with engineering and manufacturing branches. The company is committed to creation of new electronics products and...



The application is running since 15 days without any crashed, I did few minor corrections but the system is very stable and the respond time is correct.
Read more
Industry Events