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 SQLWays overview.

Ispirer SQLWays Database Migration Software

Changes in SQLWays

This chapter describes all improvements and modifications made in SQLWays version 3.9.

SQLWays 3.9

Converting DB2 GET DIAGNOSTICS, RETURN_STATUS, CURSOR WITH HOLD AND WITH RETURN to SQL Server
Converting DB2 TIMESTAMP, DECIMAL, NULLIF, DIGITS functions; Exception handlers, SQLCODE and SQLSTATE to SQL Server
EXIT and CONTINUE HANDLER; GET DIAGNOSTICS EXCEPTION, RESIGNAL conversion from DB2 to SQL Server
Sybase ASA comments (%) conversion to SQL Server
Declare cursor with VALUES and WITH; INT, UCASE functions conversion from DB2 to SQL Server
FOR statements conversion from Informix to SQL Server
CREATE DISTINCT INDEX from Informix to SQL Server conversion
"LET a,b, c =", EXIT, and CONTINUE FOREACH conversion from Informix to SQL Server
WEEKDAY, YEAR, ABS, ROUND, NVL, LPAD, RPAD, EXTEND functions conversion from Informix to SQL Server
CREATE TEMP TABLE, SELECT INTO TEMP table, Nested FOREACH, EXECUTE INTO conversion from Informix to SQL Server
SERIAL column, DBINFO('sqlca.sqlerrd1') conversion from Informix to SQL Server
RETURN p1,p2 statement with multiple values conversion from Informix to SQL Server
Informix CALL with RETURNING conversion to SQL Server EXECUTE with OUTPUT
Informix SYSTEM conversion to xp_cmdshell in SQL Server
OUTER joins conversion from Informix to SQL Server
FIRST in SELECT to TOP conversion from Informix to SQL Server
Informix UNITS DAY expression conversion to SQL Server DATEADD
RUles conversion between SQL Server databases
*= joins conversion from old SQL Server syntax to ANSI SQL syntax
Converting Sybase ASA triggers to SQL Server
Calling procedures and functions in MySQL
Option for READSIZE parameter for Oracle SQL Loader
Preserving trailing spaces in Oracle databases
EXEC statements with return clause conversion from Oracle to SQL Server
Options to convert CHECK constraints
@@ROWCOUNT to GET DIAGNOSTICS conversion from SQL Server to DB2
SQL Server trigger with IF UPDATE (col1) to DB2 conversion
EXEC, @@ERROR conversion from SQL Server to DB2
Option to output column names in the first row of data file
DATEDIFF function conversion from Sybase ASE to Oracle
Tablespace options for tables and indexes when migrating to Oracle
Option to skip data export if data file already exists
Casting data types in UNION when converting from SQL Server to DB2
Oracle INSERT INTO with RETURNING to SQL Server @@IDENTITY conversion
DELIMITER option for MySQL when importing procedures, triggers
Converting Sybase ASA identity columns to INTEGER with AUTO_INCREMENT in MySQL
DB2 EXECUTE stmt_var, DECLARE cursor, PREPARE to Oracle conversion
SQL Server identity to Oracle, Informix conversion
Primary and foreigh keys, check constraints, comments conversion from SQL Server to Informix
Schema and data conversion to PostgreSQL
Autoincrement column conversion from Access to Oracle, PostgreSQL
Default value for BOOLEAN, GETDATE() conversion from SQL Server to PostgreSQL
Option Unrecoverable for Oracle SQL Loader
newid() and GUID conversion from SQL Server to Oracle
DB2 SIGNAL SQLSTATE statement conversion to Oracle
TO_CHAR() function, SQLCODE and SQLERRM conversion from Oracle to PostgreSQL
Oracle data type mapping for MySQL - NUMBER, ROWID, BFILE
Oracle INSTR function conversion to MySQL
User accounts and sequences transfer between Oracle databases
suser_name() function conversion from Sybase ASE to PostgreSQL
CASE statemenst conversion to DECODE in Oracle 8i
INSERT SELECT without table conversion from SQL Server to Oracle
Tablespaces conversion for table and indexes from DB2 to Oracle
OUT refcur parameter conversion from Oracle to DB2
STAFF and ISDATE conversion from SQL Server to Oracle
IF, IFNULL, EXISTS in IF, DECLARE CURSOR, + (concatenation) conversion from Sybase ASA to Oracle
DECLARE EXCEPTION, NATURAL JOIN, KEY JOIN conversion from Sybase ASA to Oracle
STRING, DAYS, DATEDIFF function conversion from Sybase ASA to Oracle
User defined types (UDT) conversion from Sybase ASA to Oracle
Sybase ASA RETURN status in procedures conversion to Oracle
VALUES INTO statement, INTEGER function conversion from DB2 to Oracle
GET DIAGNOSTICS ROW_COUNT, DECLARE CONTINUE HANDLER conversion from DB2 to Oracle
DATEADD function conversion from SQL Server to MySQL
SPACE, STR function conversion from SQL Server to PostgreSQL
RAISERROR conversion from Sybase ASE to Oracle
Importing views in dependency order
Temporary tables, outer joins, cursor conversion from SQL Server to DB2
Added IF EXIST in DROP statements for MySQL
Converting procedures returning values from DB2 to Oracle
Conversion from Progress to SQL Server and Oracle
Auto-increment conversion from Informix to MySQL
Views, triggers, and procedures conversion from Informix to MySQL
FOREACH statement conversion from Informix to MySQL
Option to map Oracle Sequences to identity columns in tables
LPAD, TRUNC functions, cursor attributes conversion from Oracle to DB2
@@IDENTITY, @@ROWCOUNT, dynamic SQL EXEC, INSERT EXEC conversion from SQL Server to PostgreSQL
DATEADD, CAST, DATALENGTH, CHARINDEX conversion from SQL Server to PostgreSQL
Dynamic SQL statements conversion from Oracle to DB2
SQL Server "val<>NULL" to "val is not NULL" conversion in DB2
MySQL ENUM conversion to other databases
Temporary table conversion from SQL Server to MySQL
Oracle DECODE, TRUNC(date), ROWNUM conversion to CASE in PostgreSQL
@@ROWCOUNT, datetime functions, dynamic SQL conversion from SQL Server to MySQL
Datetime functions conversion from SQL Server to PostgreSQL
BEGIN TRANSACTION, ROLLBACK, COMMIT conversuion from SQL Server, Sybase ASE to MySQL
Support conversion from Informix SE databases
XML clause in SELECT conversion from SQL Server to Oracle