SQLWays 6.0 is Released

By: Ispirer  10/04/2012
Keywords: Database And Application Migration

April 3, 2012 – Ispirer Systems Ltd., a world-leading provider of cross-platform database and application migration solutions, has released SQLWays 6.0, a new version of its database migration software.

“SQLWays 6.0 has been developed in several directions,” said Dmitry Tolpeko, Ispirer Product Manager, describing the product’s potential. “Its conversion power has dramatically increased in comparison with the previous version.”

Sybase to DB2 z/OS

After completing one more project in this migration direction the following solutions have been found and added to SQLWays 6.0:

  • Supporting IXF data format for DB z/OS;
  • Supporting external functions for Java with an opportunity of indicating WLM environment;
  • A possibility of changing database structure;
  • Migration of various system functions such as BitAnd, REVERSE, BitOR, etc.

Sybase to MySQL

One of our clients faced the problem that when converted from Sybase to MySQL the queries worked slower. The solution was found in identifying Cartesian products in queries and doing splitting. Apart from this, database migration tool SQLWays 6.0 has become capable of gathering more statistics. Now it can automatically find Cartesian products, collect statistics, and do splitting, which saves our clients time, effort and expenses.

Oracle to PostgreSQL

SQLWays 6.0 is capable to convert Oracle Pro*C API to PostgreSQL ECPG API in C applications. Migration process goes internally in tool and there is no need to convert embedded SQL separately.

Oracle to MySQL

Database migration tool SQLWays now can convert Business Logic from Oracle to MySQL that works with files, XML types, HTTP servers, TCP connections and LOBs. The tool has been updated and now supports conversion of MySQL external functions that emulate the work of Oracle packages UTL_FILE, DBMS_UTILITY, UTL_HTTP, UTL_TCP, DBMS_LOB and XMLTYPE.

Informix to Oracle

SQLWays 6.0 has been upgraded to include and perform:

  • Incomplete datetime and interval values conversion;
  • Overloaded stored routines migration.

Ispirer Systems is also glad to announce that the list of supported databases has been extended. Now SQLWays 6.0 has Greenplum and EnterpriseDB as a source and target databases.

About Ispirer SystemsIspirer 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, MySQL & SchoonerSQL. The company successfully works in the field of database migration since 1999.Today it has over 500 customers worldwide including world leading financial, social and educational institutions and global corporations. To learn more, please visit the website 

Keywords: Database And Application Migration

Other news and updates from Ispirer


PowerBuilder Migration to SQL Server, Oracle, Open Source Databases - Ispirer

We've being in the market for eleven years so far, and during that time our company was trying to optimize our migration product to guarantee excellent results to our customers and help them to automate database migration process. Ispirer offers a new solution based on its product SQLWays to migrate PowerBuilder applications to SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL and other databases.


Oracle Endeca Information Discovery: Quickly Explore All Relevant Data - Ispirer

Essentially, information discovery begins where traditional BI ends, providing business users with advanced yet simple-to-use data exploration and analysis tools to unlock hidden insight in disparate systems," explains Gilman. A number of key forces are converging to make information discovery a critical element of any enterprise BI strategy, according to Tobin Gilman, vice president, Business Analytics Product Marketing, Oracle.


Oracle Oracle Announces General Availability of MySQL Cluster 7.2 - Ispirer

Oracle VM Certification: Virtualization support adds to features including auto-sharding, elastic scalability and self-healing, that makes MySQL Cluster an ideal choice for deploying highly demanding web and communications applications in the cloud.


Oracle Buys Taleo - Ispirer - Database and Application Migration Software

Investors and security holders of Taleo are urged to read the proxy statement and the other relevant materials when they become available before making any voting or investment decision with respect to the proposed merger because they will contain important information about the merger and the parties to the merger.


SQLWays 5.0 Is Released - Ispirer - Database and Application Migration Software

As a result of this continuous software improvement process, SQLWays 5.0 has even more impressive conversion results from the initial product run and is capable of handling even more difficult migrations with complex business logic elements. Ispirer Systems, a professional migration vendor, announces release of SQLWays 5.0 version with extended list of supported databases, conversion capabilities and new sales strategy.