SQLWays 3.8, 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
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.
January 11, 2005 – 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.