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
May 4, 2016Quality and Qualifications Ireland, Ireland
Oracle to Microsoft SQL Server

"We had the opportunity to work with Ispirer in 2015 as we needed to migrate an Oracle Database to MS SQL Server. The database supported a number of core...

...

February 23, 2016Mixon, United States
Informix to Microsoft SQL Server Migration

"To whom it may concern;

Recently it became necessary to migrate approximately 100 Gb of data from Informix database to Microsoft SQL Server...

...

Case Studies
March 24, 2016MySQL to Oracle, United States

An insurance enterprise, founded more than a century ago in the US that offers a great variety of personal and commercial insurance programs. Their policies are designed on the basis of special...

...

March 14, 2016Oracle to Sybase ASE, Japan

This was one of the projects Ispirer performed with our partners from Japan. We had already successfully performed quite a number of projects together. This time, Ispirer team faced the challenge...

...

Feedback

Hello. I looked at the Demo and I am very impressed. I do consulting in the SAP world and would be interested to learn more.
Read more
Industry Events