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 database's 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
What's New in This Release: [ read full changelog ]
· Support for the conversion of Oracle SQL to Netezza SQL dialect.
· Support for mapping of datatypes across all the databases.
· Support for conversion of Common table expressions (WITH statement) to all the databases.
