SwisSQL Console 4.2

SQL Query Translation / Conversion Tool

SwisSQL Console SQL query translation / conversion tool converts SQL queries from one database dialect to another. It has a simple and user friendly GUI. DBAs and developers who work with multiple databases or on database migration projects need not spend unproductive hours trying to learn the differences in SQL dialects. SwisSQL Console lets you type in a SQL query and quickly see how the query is translated to other SQL dialects.

Console offers an instant solution providing quick and reliable SQL query conversion utility that accelerates migration. Console supports migration across Oracle, SQL Server, IBM DB2, MySQL, Sybase, PostgreSQL, Informix and Netezza databases. This software also has features to test the converted SQLs in target databases.

Developers who want to build portable database applications by embedding SQL Conversion functionality should look at the SwisSQL API product.

Benefits:

• 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.
• Affordable price. More Benefits >>

Newly added features in SwisSQL Console 4.2 version

• Sub Query conversion to MySQL is supported
• Support for conversion of Oracle Hierarchical queries (START WITH .. CONNECT BY) to SQL Server 2000.
• Identity Mapping to SQL Server is supported .
• Several other bug-fixes over 4.1 Version.

Other SwisSQL Console Features:

• Support for conversion of Oracle Hierarchical queries (START WITH .. CONNECT BY) to equivalent queries in DB2 and SQL Server 2005
• GUI based data type mapping across databases.
• Configurable option to handle the conversion of Sybase IS NOT NULL construct to SQL Server.
• 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.
• 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., )

        And many more features...

How it works

The SwisSQL Console SQL query translation / conversion tool uses the underlying SwisSQL API multi-dialect SQL parser and a SQL conversion engine 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. To use the API from your J2EE/Java application, please look at SwisSQL API product.

Note : The evaluation version is a full version of the SwisSQL Console. But it will only allow the user to type in up to 50 SQL queries for conversion during the 30 day evaluation period. A list of 50 hard coded SQL queries are provided for users to verify the features in the Console during evaluation. To enable the full features of the SwisSQL Console, you need to obtain a license key from AdventNet, Inc. after paying the required license fee. Contact sales@adventnet.com for pricing and licensing details for SwisSQL Console 4.2