Changes in SQLWays

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

Variable declaration, assignment, flow of control statements conversion from Informix
FOREACH statement conversion from Informix
Error handling conversion from Oracle to SQL Server
Exceptions conversion from Informix to Oracle
Converting Informix procedures with RETURN WITH RESUME
Row level trigger conversion from Oracle to SQL Server
Trigger conversion from Informix
Informix UNITS operator
EXECUTE statement from SQL Server to Oracle
Converting DDL statements in procedures to dynamic SQL for Oracle
Option to divide large data files to several parts
Ability to specify table columns for migration
LIKE to %TYPE conversion from Informix to Oracle
Interval data type and expressions conversion from Informix
Informix MATCHES conversion to SQL Server
DATEPART function from SQL Server to Oracle
WITH SELECT conversion from DB2 to Oracle
FOR statement from Oracle to DB2
Converting reserved words from Access to MySQL
SQLWays creates a subdirectory in the LOB directory for each table and put LOBs files.
RIGHT and LEFT function conversion from SQL Server to Oracle.
SQL%FOUND and SQL%NOTFOUND from Oracle to SQL Server
Oracle INSERT statement with RETURNING clause
Exporting identity columns from MySQL
Converting SQL Server @@FETCH_STATUS to Oracle
Support for IXF format for transferring data to IBM DB2 OS/390 using IMPORT/LOAD commands
DECLARE statement with list of variables conversion from SQL Server to MySQL
Identity conversion from DB2 to MySQL
Converting Oracle UNIQUE to SQL Server DISTINCT
DECODE function from Oracle to MySQL
CHARINDEX and PATINDEX conversion from SQL Server to Oracle
@@ERROR conversion from SQL Server to Oracle
TRUE and FALSE conversion from Oracle to SQL Server
Option to not convert NOT NULL constraints
% operator to MOD function from SQL Server to Oracle
Exporting foreign keys and SERIAL columns from PostgreSQL
Oracle RAISE_APPLICATION_ERROR to SQL Server RAISEERROR conversion
TOP clause conversion from SQL Server to Oracle
Option to import only new rows to MySQL
UPDATE statement with multiple tables from Sybase ASA to SQL Server
HEX constants conversion from Sybase ASA to Oracle
Option to export table constraints when SELECT statement is specified for data export
CHAR_LENGTH from Sybase ASE to Oracle
TO_DATE function conversion from Oracle to SQL Server
DELETE statement with several FROM clauses from Sybase ASA
Raiserror conversion from Sybase ASE
@@FETCH_STATUS to @@SQLSTATUS conversion from SQL Server to Sybase ASE
LPAD function conversion from Informix to SQL Server
Identity and primary conversion from Access to Pervasive.SQL
NO_DATA_FOUND exception from Oracle to SQL Server
RECORD conversion from Oracle
Option to specify CASE Attribute for Pervasive.SQL character columns
Option to automatically remove columns with special data types (ROWID e.g.)
Converting year values before 1753 to SQL Server
Option to specify batch size for SQL Server BCP utility
@@ROWCOUNT conversion from SQL Server to DB2
SQL Server REPLICATE function conversion the REPEAT function in DB2