Release Notes |

### Features added in SwisSQL Console 5.5 SwisSQL Console now requires Java 1.6 or later versions in order to run. Conversion of Sybase's HASBYTES function to SQL Server is supported. Conversion of Oracle's "COMMENT ON" SQL is supported. Conversion of Mysql's SYSDATE function is supported. Conversion of substring to ANSI SQL is supported. Conversion of SQL Server's SYSDATETIME, SYSUTDATETIME, SYSDATETIMEOFFSET fucntions are supported to Oracle. Several bug fixes over 5.0 version ### Features added in SwisSQL Console 5.0 SwisSQL Console now supports the conversion of Oracle SQL statements to Teradata SQL. List of supported features is available here. Several other bug fixes over version 4.3. ### Features added in SwisSQL Console 4.3 Several bug fixes over 4.2 version. ### Features added in SwisSQL Console 4.2 Sub Query conversion to MySQL is supported Support for conversion of Oracle Hierarchical queries (START WITH .. CONNECT BY) to SQL Server 2000. For examples please refer here . Identity Mapping to SQL Server is supported .For more details refer here. Several other bug-fixes over 4.1 Version. ### Features added in SwisSQL Console 4.1 Sub Query conversion to MySQL is supported GUI based data type mapping across databases is added. For more details refer here. Support for conversion of Oracle Hierarchical queries (START WITH .. CONNECT BY) to Common table expression (WITH clause) in DB2 and SQL Server 2005. For more details refer here. Configurable option is added for conversion of Sybase IS NOT NULL clause to SQL Server. For more details refer here. Several other bug-fixes over 4.0 Version. ### Features added in SwisSQL Console 4.0 The product is renamed to SwisSQL Console. Support for the conversion of Oracle SQL to Netezza SQL. The GUI has been enhanced and the database connections are handled based on connection names making it easier to maintain the various database connections. Support for changing the Configuration options (conversion settings) from the GUI. Support for mapping of datatypes across all the databases. Support for conversion of Common table expressions (WITH statement) to all the databases. JDBC driver for Oracle (ojdbc14.jar) is bundled with the tool. This will be used by default by the tool to connect to Oracle. jTDS JDBC Driver is now packaged with the tool. This driver will be used for connecting to SQL Server and Sybase, hence there is no need to load a JDBC driver for connecting to Sybase or SQL Server database. MySQL JDBC Driver is now packaged with the tool. This driver will be used for connecting to MySQL, hence there is no need to load a JDBC driver for connecting to MySQL. Several other bug-fixes over 3.0 Version. ### Features added in SwisSQL - SQLOne Console 3.0 Completely redesigned Graphical User Interface offering enhanced usability Support for executing queries against multiple databases and comparing the result Support for fetching and storing table information (metadata) and other details from multiple source database. The information fetched from the source database would be used for accurate migration of SQLs. Fetching metadata is recommended for accurate migration. Support for conversion of Oracle MERGE statement to ANSI SQL Support for converting DATEPART, DATEADD, DATEDIFF and DATENAME Sybase functions to DB2 Support for converting DATE_TRUNC PostgreSQL function to SQL Server Support for converting NOW function of PostgreSQL Several other bug-fixes over 2.0 Version. ### Features added in SwisSQL - SQLOne Console 2.0 SQL keyword highlighting is provided for the editors available in the tool. Configuration options provided for customizing the converted SQL queries. Support for conversion of Sybase SELECT queries where all the select columns are not listed in the GROUP BY clause. This is handled for the target databases Oracle, SQL Server and DB2. Conversion of various IDENTITY options like MAXVALUE, MINVALUE, ORDER, CYCLE etc are supported in DB2 to Oracle. Also BEFORE INSERT TRIGGER is generated for updating the column using the SEQUENCE value in Oracle. Support for conversion of SQL statements(DDL and DML) containing Oracle reserved words as object names for any database to Oracle database migration. Support for conversion of ALTER statements with MODIFY clause from Oracle to DB2. Improved support for truncating object names in conversion to Oracle. Conversion of the Oracle queries containing THETA outer join and the columns without qualifiers (table (or) alias name Eg : test.column1) are handled with the help of metadata. It is essential to have the metadata of the source Oracle database. Support for conversion of Common Table Expression syntax in INSERT statements from DB2 to Oracle. Conversion of SQL Server's wild card characters '[' and '^' in LIKE clause are supported in Oracle. Conversion of single line and multiline comments existing within SQL Statements are handled in SQL Server to Oracle migration. Conversion of the literal date values(with formats which are not accepted in Oracle) from any database to Oracle is supported. Date formats are handled in SELECT, INSERT, UPDATE, DELETE statements and SQL Server DATE functions. Support for conversion of SQL Server built-in functions RADIANS and DEGREES to all other databases. Support for conversion of SQLServer built-in functions GETUTCDATE, RAND, DB_ID, DB_NAME, SESSION_USER, HOST_ID, HOST_NAME, IS_SRVROLEMEMBER, serverproperty('servername'), OBJECT_ID, USER_ID, UNICODE and QUOTENAME to Oracle. Oracle's FLOOR function containing DATE arithmetic expressions as argument is handled with the help of metadata in SQL Server and Sybase. It is essential to have metadata of Oracle database for proper migration. Support for conversion of Oracle's TRUNC function with DATE datatype columns to Sybase. Support for conversion of date arithemtic expressions from Oracle to DB2. Support for conversion of Oracle's USERENV function to SQL Server and Sybase. Improved support for conversion of SQL Server's DATEPART and DATENAME functions to Oracle. The dateparts 'second', 'millisecond' and 'ms' are handled. Improved support for MySQL Limit clause. The offset value specified in the LIMIT clause is converted in SQL Server. Option to fetch the metadata(table information) for accurate conversion of SQL queries. Several other bug-fixes over 1.9.6 Version ### Features added in SwisSQL - SQLOne Console 1.9.6 JOINs with literal comparisons and JOINs within subqueries are supported. MS SQLServer's 'Table Hints' such as UPD LOCK, TAB LOCK, TAB LOCKX conversion supported for Oracle. Conversion of Oracle function NEXT_DAY supported in Sybase. Conversion of Oracle function LAST_DAY supported in DB2. MySQL 'ENUM' datatype supported in all other databases. Several other bug-fixes over 1.9.4 Version ### Features added in SwisSQL - SQLOne Console 1.9.4 Conversion of Grant statement supported in all databases. Conversion of COMMIT and AUTOCOMMIT statement supported in all databases. Conversion of MySQL LOAD statement is supported in DB2 and SQL Server. Conversion of Oracle's 'CREATE SYNONYM' statement to DB2 is supported. Conversion of Oracle's Update statement with table alias name to SQL Server and Sybase is supported. Oracle's SELECT...FOR UPDATE statement converted to SQL Server and Sybase. Conversion of the following functions are supported in this release : SQUARE function supported in all databases. Oracle function ROW_NUMBER OVER is supported in DB2. DB2 function MONTHNAME is supported in SQL Server. SQL Server functions USER_NAME is supported in Oracle Extended support for various date formats in functions like TO_DATE and TO_CHAR. ASCII function supported in Oracle, SQL Server, Sybase and DB2 Conversion of OR Conditions in ANSI JOIN to THETA JOIN is supported in Oracle. Several other bug-fixes over 1.9.3 Version ### Features added in SwisSQL - SQLOne Console 1.9.3 Support for converting multiple queries simultaneously. The queries could also be loaded from a file and converted in one stroke. The converted queries could also be saved into files. Support for conversion of datatypes BLOB,CLOB,SQL_VARIANT and UNIQUEIDENTIFIER in Oracle, SQL Server and DB2. Several other bug-fixes over 1.9.2 Version ### Features added in SwisSQL - SQLOne Console 1.9.2 Support for 'DATENAME', 'RAWTOHEX', 'DAY', 'MONTH', 'DATEPART', 'YEAR', 'LAST_DAY' and 'SPACE' function Conversion. Support for BITWISE operators like '&', '|', '^'. Several other bug-fixes over 1.9.1 Version ### Features added in SwisSQL - SQLOne Console 1.9.1 Several Enhancements and bug-fixes over 1.9.1 Version ### Features added in SwisSQL - SQLOne Console 1.9 Support for 'STD', 'STDEV', 'STDDEV', 'VAR', 'VARP', 'VAR_POP', 'VAR_SAMP' and 'VARIANCE' function Conversion Support for 'NEWID' and 'BITAND' function Conversion Several other enhancements and bug-fixes over 1.8 Version ### Features added in SwisSQL - SQLOne Console 1.8 Support for Sybase Database Conversion Support for 'FULL OUTER JOIN' Conversion Support for 'ALTER TABLE' Statement Conversion Enhancement of Conversion of 'THETA JOIN to ANSI JOIN' Support for 'PATINDEX' and 'SUSER_SNAME' function Conversion Several other enhancements and bug-fixes over 1.7 Version ### Features added in SwisSQL - SQLOne Console 1.7 Console Re-sizing option provided for the users Support for 'CREATE INDEX' SQL Statement Conversion Support for 'SYS_GUID' and 'DATEDIFF' function Conversion Enhancement of ORACLE 'TO_DATE' function Conversion Enhancement of 'CREATE TABLE' SQL Statement with support for 'INDEX' Statement Several other enhancements and bug-fixes over 1.6 Version ### Features added in SwisSQL - SQLOne Console 1.6 Support for INFORMIX database SQL Conversion. The support includes SQL Conversion for most of the Syntax and functions from and to Informix database Support for 'CREATE' SQL Statement Conversion for tables and views Support for ORACLE 'TO_DATE' function Conversion Support for Functions like 'MOD' ,'TRUNC' etc. given Several other enhancements and bug-fixes over 1.5 Version ### Features added in SwisSQL - SQLOneConsole 1.5 Multiple Table Outer Joins (ANSI, Theta) are supported. Support for Aggregate functions Support for most Mathematical functions Support for most String functions Support for other miscellaneous functions Support for 'CASE-DECODE' and 'DECODE-CASE' conversion Support for DB2 'GROUPING SETS' conversion Support for SQL Server 'GROUP BY ALL' conversion Support for 'ROLLUP' and 'CUBE' conversion Support for handling complex conditions in 'HAVING' clause Support for ORACLE TO_CHAR function for USA, EUR AND ISO date and time format Support for sub-queries in 'FROM' clause Support for converting remote database alias (DB..TABLE) from SQL-Server to ORACLE syntax Click here to view the list of SQL built-in functions that are supported ### Features in SwisSQL - SQLOne Console Release 1.0 Support for SELECT, UPDATE, INSERT and DELETE statements Support for ORACLE, MSSQL-Server, IBM DB2, MySQL, PostgreSQL and ANSI syntaxes Conversion from one SQL dialect to another 100% java based implementation supports Windows, Solaris, Linux and other OSs with Java virtual machine JavaCC based SQL parser implementation ensures easy enhancement of functionality Supports SQL-89, SQL-92 and SQL-99 standards syntax too Support for executing the converted SQL queries in the target database Support for loading SQL queries from a file Support for saving converted SQL queries in a file Support for Identation of SQL queries Support for enlarged view of the converted SQL query and Result Set ### Limitations in release 4.0 OR Conditions in ANSI JOINS are not supported while converting to other SQL dialects except in Oracle. 'ROLLUP' and 'CUBE' conversion is not completely handled in PostgreSQL. Nested queries are not converted to MySQL syntax as MySQL does not support nested queries. Future releases will attempt to solve this by providing equivalent multiple queries Union of all database specific SQL keywords are not allowed to be used in SQL queries irrespective of underlying database. This is because the SwisSQL-SQLOne parser is a multi-dialect SQL parser In ANSI Outer Join syntax, the columns that are joined in the query must be prefixed by table or alias name. Joins with only column names may be converted incorrectly. Future releases will use meta data information to support this feature. JDBC escape sequences are not supported as there is no need to use escape sequences when using SwisSQL-SQLOne. This feature will be supported based on customer requests Multiple braces are not supported inside CUBE, ROLLUP and GROUPING SETS while converting to other SQL dialects Vendor-Specific Function Conversions are not completely supported. Click here to view the list of functions that are supported Providing Database Link Name in 'FROM' is not supported while converting to other SQL dialects 'ESCAPE' keyword in ORACLE, Informix and DB2 is not supported while converting to other SQL dialects Optimization features are not supported while converting the SQL to different dialects NESTED TABLES are not supported while converting to other SQL dialects Informix OUTER joins are only partially supported in ORACLE Informix DATE and TIME functions are only partially supported Informix Subscripts on Character Columns is not supported ORACLE TO_DATE function is not supported for all formats. Some of them for which the support is not provided are 'MONTH', 'MON' etc TRUNC function is only supported for numbers Conversion of MySQL LOAD statement is supported only in DB2 and SQL Server. Conversion of 'CREATE SYNONYM' statement is supported only in Oracle and DB2. SELECT...FOR UPDATE statement conversion handled only in Oracle, SQL Server and Sybase Click here to view detailed examples on the limitations ### Known Issues in 4.0 Some SQLs may be parsed correctly by the SwisSQL-SQLOne parser but appropriate conversion may not be possible to support the underlying database. Exceptions thrown because of conversion limitations do not provide much of a detail

© 2011 ZOHO Corporation