What's New in This Release:

· 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
· OWCOUNT 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... [ read full changelog ]