SwisSQL - End of Life Notice Thanks for your interest inSwisSQL
Regret to inform you that we have decided to discontinue any development and investments on this product to best align with our business goals and direction. Existing customers of SwisSQL can avail product support from us till their current support contract expires. For further queries, do email us at support@swissql.com and we'll be happy to assist you.
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.
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.
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 ZOHO Corp. after paying the required license fee. Contact sales@swissql.com for pricing and licensing details for SwisSQL Console 5.5
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
Teradata : 13.x - Note: Currently supports migration only from Oracle SQL to Teradata SQL