SQLWays version 3.8

Copyright (C) 1999-2004 Ispirer Systems.
All Rights Reserved.

---------------------------

+ improvement/modification
! bug fixed

---------------------------

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


  
Version 3.7 
-----------

[+] Converting Oracle multicolumn outer join (+) to SQL Server, DB2 (ANSI join)  
[+] Transferring the Microsoft Access OLE Object column containing BMP images
to other databases.
Build 45
[+] Exporting procedures, triggers and functions from Interbase
[+] DB2 Parser Enhancement (GET DIAGNOSTICS)
[+] Converting Oracle, Microsoft SQL Server, Sybase stored procedures to MySQL.
[+] Transferring Oracle Spatial data between Oracle 9i databases.
[+] Report on conversion process.
[+] Microsoft SQL Server parsers enhancements: Function name in FROM clause,
SET ROWCOUNT, UPDATE SET col= (SELECT)-(SELECT), () in FROM, 
INSERT INTO () EXEC function_name [parameters], CREATE INDEX, COMPUTE in SELECT
statement, string constant as alias,
[+] Sybase ASA parsers enhancements: GETDATE(*), INOUT parameter in procedures,
GRANT EXECUTE statement, SUBSTRING(), BEGIN ATOMIC, SELECT statement in 
expressions, LONG VARCHAR data type, FOR statement (for cursor), parameters in
the DECLARE LOCAL TEMPORARY TABLE  statement, parameters in DECLARE EXCEPTION 
statement, MESSAGE statement, parameters in DECLARE CURSOR statement, 
parameters in OPEN CURSOR, UPDATE statement for set of tables, CREATE INDEX 
statement, DOUBLE data type, subselect in INSERT statement, CURRENT DATE,
row limits in SELECT, string constant as alias, multiple double quotes, 
// comments, aggregate functions (MAX, MIN and AVG)
[+] Installation package is provided
[+] Added the option to specify codepage for Microsoft SQL Server BCP utility
[+] Not exporting Sybase Adaptive Server Anywhere system objects
[+] Oracle reserved words extended
[+] By default map datetime data types to Oracle DATE or TIMESTAMP depending 
on Oracle version (9i or 8i)
[+] Extract column aliases for Oracle views
[+] Extracting comments and defaults from DB2 OS/390
[+] Extracting primary keys from DB2 AS/400
[+] Exporting relationships from Access



Version 3.6 
-----------

[+] Converting Oracle stored procedures and functions to SQL Server.
(variable initialization, %ROWTYPE, default values dbms_output.put_line).
[+] Converting Oracle stored procedures to IBM DB2
(PL/SQL exceptions, %ROWTYPE, default values, FOR loop).
[+] Converting Oracle packages to SQL Server and IBM DB2
[+] Converting SQL Server and Sybase Transact-SQL stored procedures to Oracle
(parameters, print, exec, cursors, cursors attributes, temporary tables,
outer joins (*), % operator).
[+] Converting SQL Server stored procedures to Pervasive.SQL (parameters, 
data types, variables, select into, set, convert and dateadd functions)
[+] Converting Sybase ASA Watcom-SQL stored procedures to SQL Server.
(procedure header, parameters, execute immediate, local temporary tables,
loop, while, cursors, if, case, today(*) and now(*))
[+] SQLWays now allows users to modify table and column names for each table.
[+] Options to automatically resolve identificators conflicts (reserved words,
not allowed characters).
[+] Extporting DEFAULT values and unique constraints from DB2 OS/390.

Version 3.5 
-----------

[+] Converting Oracle stored procedures, functions and triggers to IBM DB2
(parameters, variables, cursors, conditions, loops and error handling).
[+] Migrating to Pervasive.SQL v8. SQLWays supports all data types (except
legacy) including LONGVARCHAR and LONGVARBINARY. SQLWays allows using the BUTIL 
utility or SQL INSERT statements to load data Pervasive.SQL.
[+] Converting Oracle stored procedures and functions to SQL Server.
(outer joins without table aliases, parameter datatype length, 
raise_application_error, cursor attributes, execute immediate, for cursor loops,
%TYPE and return statement).
[+] Converting the Informix DATETIME data type with various precisions.
[+] Converting the SQL Server and Sybase CONVERT functions to IBM DB2 and 
Oracle.
[+] Extporting CHECK constraints and object comments from DB2 OS/390.
[+] Extporting stored procedures and triggers from Ingres.
[+] Supporting MySQL table types - BDB, HEAP, ISAM, InnoDB, MERGE and MYISAM.

Version 3.4 
-----------

[+] Converting stored procedures from Oracle to SQL Server.
[+] Improvements of stored procedure conversion from SQL Server to Oracle
(queries and error handling).
[+] Extended data type mapping that allows you to map data types for all tables
and each individual table as well.
[+] Importing views in the order of their dependency on each other.
[+] Extracting views and triggers from DB2 z/OS and OS/390.
[+] Extracting indexes, constraints, primary and foreign key, views, 
stored procedures, functions and triggers from Informix.
[+] Extracting views, stored procedures and triggers from Microsoft 
SQL Server 6.5 and Sybase SQL Anywhere 5.5
[+] Extracting functions from Oracle, Microsoft SQL Server and Sybase.
[+] Support the NONRECOVERABLE option for the DB2 LOAD command.
[!] Converting datetime data types to the MySQL DATETIME by default.

Version 3.3 
-----------

[+] Converting stored procedures from SQL Server to Oracle.
[+] Converting SQL Server LEFT, RIGHT, SUBSTRING, LEN and COALESCE functions
to IBM DB2 and Oracle.
[+] Converting Oracle SUBSTR and LENGTH functions to IBM DB2 and SQL Server.
[+] Converting IBM DB2 LEFT, RIGHT, SUBSTR and LENGTH functions to Oracle and
SQL Server.
[+] Added the option to convert the datetime datatypes to the IBM DB2 DATE
datatype.
[+] Added the option to convert the datetime datatypes to the Oracle
TIMESTAMP datatype.
[+] Added the option to convert the identity properties of columns.
[+] Added the option to specify the CLIENT option in the DB2 LOAD command. 
This allows loading data from a remote client to DB2 using the LOAD command.
[!] Specifying the size of BINARY and VARBINARY columns in the DDL scripts 
for Sybase.

Version 3.2 
-----------

[+] Converting views between Oracle, IBM DB2 and Microsoft SQL Server.
[+] Converting Oracle outer joins (+) to IBM DB2 and SQL Server outer joins
(LEFT OUTER JOIN, RIGHT OUTER JOIN).
[+] Converting Oracle DECODE expressions to IBM DB2 and SQL Server simple
CASE expressions.
[+] Converting Oracle SYSDATE, IBM DB2 CURRENT TIMESTAMP and SQL Server 
GetDate() functions.
[+] Converting Oracle NVL, IBM DB2 COALESCE and SQL Server ISNULL functions.
[+] Added option to generate the CASCADE CONSTRAINTS option in the DROP TABLE
statements for Oracle.
[+] Supports SQL Server and Sybase money data types (MONEY and SMALLMONEY).
[+] Allows you to specify the YY format (last 2 digits of year) for dates in 
text files.
[+] Added option to specify Unix shell location.
[!] Extracting stored procedures from Microsoft SQL Server 7.0

Version 3.1 (Chyfo renamed to SQLWays)
-----------

[+] GUI Wizard provided.
[+] Extracting views, stored procedures and triggers from Sybase Adaptive 
Server.
[+] Generating Windows command files and Unix Bourne shell scripts for
importing views, stored procedures and triggers.
[+] Added option to specify generating the TO_DATE function for DATE columns in
SQL INSERT statements for Oracle.
[+] Added the option to specify directory where import will be executed.
[+] List of Oracle and Microsoft SQL Server reserved words extended.
[+] Added option to convert Oracle LONG RAW to Oracle BLOB.
[+] Set Oracle SQL Loader "str" option when row delimiter differs from the 
default value.
[+] Added option to specify a command that will be executed after importing 
each database object (table, view etc). For import scripts for Windows only.
[+] If the /INI option is not specified, SQLWays looks for sqlways.ini file in 
the current directory, then in the directory from which the SQLWays application
loaded. 
[+] Allow to specify more than one character for SQL statement delimiter.
[!] Fixed specifying date formats in Oracle SQL Loader control files.
[!] Fixed extracting views and triggers from DB2 when schema name is explicitly
specified and its length is less than 8 symbols.
[!] Using isql instead of isql.exe in import scripts for Sybase on Unix.

Version 2.9.7
-------------

[+] Generating Bourne shell scripts to perform import on a Unix system.
[+] Added the options to specify datetime (timestamp), date and time formats in
the text file. Now it is possible to define various datetime representations
using format elements like YYYY, MM, MON, DD, HH, MI and SS.
[+] Extracting stored procedure definitions from Oracle and Microsoft SQL 
Server (Chyfo Enterprise Edition only).
[+] Extracting trigger definitions from Oracle, IBM DB2 and Microsoft SQL
Server (Chyfo Enterprise Edition only).
[+] Extracting identity properties of columns from Sybase (IDENTITY property), 
MySQL (AUTO_INCREMENT property) and Microsoft Access (AutoNumber column).
[+] Added the option to force NOT NULL constraints in the DDL scripts for
columns that make up a primary key.
[+] Importing tables with the IDENTITY columns to Sybase using the Sybase BCP
utility.
[+] Allow using templates like *.* in Chyfo Standard Edition. Chyfo Standard 
Edition can export up to 100 tables at once.
[+] Generating SQL INSERT statements for tables containing CLOB (character 
large object) and NULL BLOB (binary large object) columns.
[+] Added options to replace or remove newline characters from the data.
[+] Set NULL column constraints for Sybase explicitly since the Sybase command
prompt ISQL utility sets NOT NULL by default.
[+] When migrating LOB data from/to IBM DB2 or Oracle Chyfo doesn't create an
empty LOB file if the LOB data is NULL. Chyfo creates a file to place the LOB
data only if the LOB data is not NULL.
[+] If the source database is IBM DB2 or Microsoft Access, do not shift LOB 
columns to the end of column list by default.
[+] Added the option for MySQL to specify whether or not import is performed 
from the client host (the LOCAL keyword in the LOAD DATA INFILE command).
[+] Specifying an error file for the Sybase BCP utility, where BCP stores any
rows that it was unable to import to the Sybase database.
[!] Fixed generating index scripts for Microsoft SQL Server, Sybase and MySQL. 
Specifying the index name only without the owner name.
[!] Fixed using the Sybase BCP utility when the table owner is not specified.
[!] Set the row terminator option (-r) for the Sybase BCP utility.