Toll Free US: +1 888 720 9500  |  Intl: +1 925 924 9500
+1 800 443 6694 (alternative number)
Reseller
  • Support & Services
  • |
  • Products
  • |
  • Downloads
  • |
  • News
  • |
  • About Us
  • |
  • Contact Us
  • |
  • Feedback
All Products
Database Migration Tools
Data & Schema Migration Tool
SwisSQL Data Migration
SQL Migration Tools
SwisSQL Console
SwisSQL API (Java Edition)

Stored Procedure Migration Tools
SwisSQL SQL Server To Oracle
SwisSQL Sybase To Oracle
SwisSQL DB2 To Oracle
SwisSQL Sybase To SQL Server
SwisSQL DB2 To SQL Server
SwisSQL Oracle To SQL Server
SwisSQL Oracle To DB2
SwisSQL SQL Server To DB2
SwisSQL Sybase To DB2
SwisSQL Oracle to Sybase
Home > Products > SwisSQL Console
 

SwisSQL Console 5.5

SwisSQL - End of Life Notice
Thanks for your interest in SwisSQL

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

Newly added features in SwisSQL Console 5.5 version

  • Support for the conversion of Oracle SQL to Teradata SQL dialect.
  • Several bug-fixes over 4.3 Version.

SwisSQL SQL Migration Tool

SwisSQL Console Supported Databases

On-the-fly SQL
Conversion Plugin
SwisSQL API
Translates SQL from one database dialect to another on-the-fly
More Info SwisSQL API More Info
Download SwisSQL API Download

Other SwisSQL Console Features:

  • 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
  • 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.

        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

Download SwisSQL Console SQL Query Converter / Translator Tool
 
Quick Links
  • SwisSQL Home
  • Key Features and Benefits
  • Support
  • SwisSQL Migration Solution
  • Product Review
  • Customers
  • Customer Testimonials
  • Migration Services
  • Partners
 
 
Related products
    Data Migration
    • SwisSQL Data Migration Tool
    SQL Query Migration
    • SwisSQL Console
    • SwisSQL API (Java)
    Stored Procedure Migration
    • SQL Server to Oracle Migration Tool
    • DB2 to Oracle Migration Tool
    • Sybase to Oracle Migration Tool
    • Oracle to SQL Server Migration Tool
    • DB2 to SQL Server Migration Tool
    • Sybase to SQL Server Migration Tool
    • Oracle to DB2 Migration Tool
    • SQL Server to DB2 Migration Tool
    • Sybase to DB2 Migration Tool
    • Oracle to Sybase Migration Tool
 
Forums
View All Forums
Zoho Corporation Pvt. Ltd. All rights reserved. Trademarks | Privacy Policy | Site Map | Contact Us | Careers | Tell Us