The SwisSQL Console SQL query conversion/translation tool uses the underlying SQLOne multi-dialect SQL parser and a SQL conversion engine to be able to convert SQL queries from one database dialect to another.

The multi-dialect SQL parser builds an SQL object model and the SQL conversion engine transforms the SQL object model so that the original SQL query can be converted to different databases dialect.

AdventNet SwisSQL offers SQLOne Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another.

DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases’ dialects.

Supported Databases:
· Oracle: 8.1.7, 9i, and 10g
· SQL Server: 2000, 2005
· IBM DB2 UDB - 8.x
· Informix: 4.x
· Sybase ASE: 12.x, 15.x
· MySQL: 4.X, 5.x
· PostgreSQL: 7.x
· ANSI-SQL: SQL 92 and SQL 99
· Netezza : 3.1 - Note: Currently supports migration only from Oracle SQL to Netezza SQL

Here are some key features of "SwisSQL SQLOne Console":

· Zero learning-curve, get started with SQL conversion immediately. No SQL knowledge required.
· Complete SQL Migration Life cycle: Load, Migrate, Execute and Verify Results all within the same console.
· Increase productivity in database migration projects and in handling multiple databases environment.
· Handle migration of Embedded SQLs within Application code easily.
· Know one SQL Dialect, learn other SQL Dialects easily.
· Comprehensive SQL Query conversion covering DDL (Create, Alter, Drop), DML (Insert, Update, Delete), Select Query and DCL (Grant statements) statements.
· Supports either direct typing or loading of SQL queries from file. Also supports Bulk conversion and saving of converted SQLs into a file.
· Supports testing of converted SQLs through execution and comparison of results.
· Supports migration across Oracle, SQL Server, IBM DB2, MySQL, Sybase, PostgreSQL, Informix and ANSI SQL database SQL dialects.
· Supports migration from Oracle SQL to Netezza SQL dialect.
· Supports converting SQLs in any database specific dialect to industry standard ANSI SQL dialect.
· Supports conversion of ANSI JOIN and THETA JOIN syntaxes. Supports conversion of complex join statements consisting of INNER JOIN, LEFT OUTER JOIN or LEFT JOIN, RIGHT OUTER JOIN or RIGHT JOIN, FULL OUTER JOINs.
· Comprehensive Datatype conversion support across multiple databases.
· Supports conversion of TOP, LIMIT, ROWNUM clauses.
· Supports conversion of all the database vendor specific built-in functions like DECODE, TO_CHAR, TO_DATE, TO_NUMBER, DATEPART, DATEADD, DATENAME, LAST_DAY, NEXT_DAY, DATEDIFF, ADD_MONTHS, CONCAT, INSTR, STUFF, SUBSTRING, REVERSE, TRUNC, RADIANS, DEGRESS, FLOOR, CONVERT, ISNULL, COALESCE, NULLIF, CAST, BITAND, CASE statement etc.
· Supports automatic handling of object names having SQL keywords/reserved words.
· Supports truncation of object names when its length exceeds the limit specified by the target database.
· Supports migration of Embedded SQLs present within Application Code (viz Java, C#, VB, PB, VC++ etc., )

SwisSQL SQLOne Console description
A DBA/Developer tool to convert SQL queries from one SQL dialect to another The SwisSQL Console SQL query conversion/translation tool uses the underlying SQLOne multi-dialect SQL parser and a SQL conversion engine to be able to convert SQL queries from one database dialect to another.

The multi-dialect SQL parser builds an SQL object model and the SQL conversion engine transforms the SQL object model so that the original SQL query can be converted to different databases dialect.

AdventNet SwisSQL offers SQLOne Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another.

DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases’ dialects.

Supported Databases:
· Oracle: 8.1.7, 9i, and 10g
· SQL Server: 2000, 2005
· IBM DB2 UDB - 8.x
· Informix: 4.x
· Sybase ASE: 12.x, 15.x
· MySQL: 4.X, 5.x
· PostgreSQL: 7.x
· ANSI-SQL: SQL 92 and SQL 99
· Netezza : 3.1 - Note: Currently supports migration only from Oracle SQL to Netezza SQL

Here are some key features of "SwisSQL SQLOne Console":

· Zero learning-curve, get started with SQL conversion immediately. No SQL knowledge required.
· Complete SQL Migration Life cycle: Load, Migrate, Execute and Verify Results all within the same console.
· Increase productivity in database migration projects and in handling multiple databases environment.
· Handle migration of Embedded SQLs within Application code easily.
· Know one SQL Dialect, learn other SQL Dialects easily.
· Comprehensive SQL Query conversion covering DDL (Create, Alter, Drop), DML (Insert, Update, Delete), Select Query and DCL (Grant statements) statements.
· Supports either direct typing or loading of SQL queries from file. Also supports Bulk conversion and saving of converted SQLs into a file.
· Supports testing of converted SQLs through execution and comparison of results.
· Supports migration across Oracle, SQL Server, IBM DB2, MySQL, Sybase, PostgreSQL, Informix and ANSI SQL database SQL dialects.
· Supports migration from Oracle SQL to Netezza SQL dialect.
· Supports converting SQLs in any database specific dialect to industry standard ANSI SQL dialect.
· Supports conversion of ANSI JOIN and THETA JOIN syntaxes. Supports conversion of complex join statements consisting of INNER JOIN, LEFT OUTER JOIN or LEFT JOIN, RIGHT OUTER JOIN or RIGHT JOIN, FULL OUTER JOINs.
· Comprehensive Datatype conversion support across multiple databases.
· Supports conversion of TOP, LIMIT, ROWNUM clauses.
· Supports conversion of all the database vendor specific built-in functions like DECODE, TO_CHAR, TO_DATE, TO_NUMBER, DATEPART, DATEADD, DATENAME, LAST_DAY, NEXT_DAY, DATEDIFF, ADD_MONTHS, CONCAT, INSTR, STUFF, SUBSTRING, REVERSE, TRUNC, RADIANS, DEGRESS, FLOOR, CONVERT, ISNULL, COALESCE, NULLIF, CAST, BITAND, CASE statement etc.
· Supports automatic handling of object names having SQL keywords/reserved words.
· Supports truncation of object names when its length exceeds the limit specified by the target database.
· Supports migration of Embedded SQLs present within Application Code (viz Java, C#, VB, PB, VC++ etc., )


Requirements:

· 128 MB RAM
· PIII 800 MHz
· 50 MB hard disk space


Limitations:

· 30 days trial

An international date bug inside VB, to set and get directly the date of the system, to solve part of the Y2K problem, and with a suite of date verifications and calculations that can vary of the year 1000 to the year 9999. We are studing and testing also a method to automatic replace VB code using the Date data type and the VB functions Dateadd and Datediff inside already developed source codes with the BinaryWork Time Machine OCX (the name of the application will be BinaryWork Date Converter)