Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer PowerBuilder Conversion overview.

Ispirer SQLWays Database Migration Software

PowerBuilder Migration

SQLWays can help you automatically convert SQL statements, table and column names in PowerBuilder applications to conform to the syntax and requirements of the new database platform.

Challenges

The necessity of PowerBuilder applications conversion is often underestimated in database migration projects. But even if you continue using PowerBuilder (not migrating to Java, .NET i.e.), the application migration can still take 30-50% of the project cost.
In the most cases, SQL statements in PowerBuilder applications are coded in the database native syntax that is different for Sybase, Oracle, Informix, SQL Server, PostgreSQL, MySQL etc.
Even if you use the PowerBuilder graphical features to define the datasources (PBSELECT), you often need to modify table and column names throughout the entire application code.
Some database migration projects involve significant database schema changes (renaming, removing, changing columns, tables) that also need to be reflected in PowerBuilder applications.
Conversion Features
• Supports major databases - Oracle, SQL Server, DB2, Sybase, Informix, MySQL, PostgreSQL etc.
  
• Offers assessment tools
  
• Processes PowerBuilder Source Files (extracted from .PBL libraries), finds and converts SQL statements and database access code.
  
• Converts SQL SELECT and PowerBuilder PBSELECT statements in DataWindow objects (.SRD files) and Query (.SRQ files)
  
• Converts SQL SELECT, INSERT, UPDATE and DELETE statements in Window objects (.SRW files), User objects (.SRU files) and Function Objects (.SRF files)
  
• Supports Procedure calls
  
• Converts SQL built-in functions
  
• Supports Result Sets processing
  
• Converts DECLARE PROCEDURE FOR and ALIAS FOR statements
  
• Supports Dynamic SQL conversion
  
• Table and column mapping