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.

 
Watch SQLWays Online Presentation
Request a SQLWays Live Presentation
Download Free SQLWays Express Version
Download Free SQLWays Demo Version
Request a Quote for Ispirer Tools or Services
Company
Testimonials
November 7, 2014High Availability Systems Co. Ltd., Japan
Informix to Oracle Migration

"We first contacted Ispirer, our long-term migration partner, to discuss the challenging application migration situation we found ourselves in during a project for a...

...

October 20, 2014Groen West, Netherlands
Progress to Microsoft SQL Server Migration

"We've been using SQLWays for a few months to convert our Progress ERP-data into Microsoft SQL Server environment on a weekly internal base. We need to...

...

Case Studies
September 24, 2014Progress 4GL to Java, Progress to Oracle Migration, Belgium

A huge provider of solutions in travel sector, whose numerous team operates all over the world, asked Ispirer to perform a complex migration. His business is dedicated to enhancement of...

...

September 13, 2014Visual Basic to Visual Basic.NET Migration, United States

A consulting company from the United States focusing on enterprise mobile device management and delivering solutions to solve business problems addressed to Ispirer because of the necessity to...

...

What Our Clients Say

MS SQL Server to Oracle, US
November 21, 2014
Yes, the product is working well. We were able to convert the first little TSQL stored procedure to Oracle and it converted and executed correctly.
Read more

Industry Events