CIO Research Library

SwisSQL SQLOne Console is a friendly GUI that converts SQL queries from one dialect to another. DBAs and developers who work with multiple databases need not spend unproductive hours trying to learn the differences in SQL dialects. SwisSQL SQLOne Console lets you type in an SQL query and quickly see how the query is translated to other SQL dialects.

SwisSQL SQLOne Console has features to test the converted SQL in different databases. SwisSQL SQLOne Console 1.9.3 version supports Oracle, MS-SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL. Developers who want to build portable database applications by embedding SQLOne should look at the SwisSQL SQLOne API product.

Features and Benefits:

• DBAs and Developers do not have to worry about SQL dialect differences
• SQL Migration in database migration projects made easy
• Support for Select, Update, Insert, Create, Alter and Delete statements
• Supports SQL constructs across databases such as Oracle, MS-SQLServer, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL
• Test SQL queries in different target databases
• Support for Indentation of SQL queries and enlarged view of the converted SQL query and Result Set