You are here: Home » Web Developer » Servers » SwisSQL SQLOne Console

SwisSQL SQLOne Console

A DBA/Developer tool to convert SQL queries from one SQL dialect to another



  • Downloads:18
  • Last update:Jan 15, 2008
  • Version:
  • License:Shareware
  • Publisher:AdventNet
  • System Requirements Windows All

Free Download ( 21.4 MB )

SwisSQL SQLOne Console

A DBA/Developer tool to convert SQL queries from one SQL dialect to another 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

    • Free Download ( Evaluation | 21.4 MB )

    Rating & Reviews for SwisSQL SQLOne Console

    Eidtor's rating:
    		(0/5)
    DownloadAtoZ.com Awards
    Editor's Reviews
    User rating:
    		(0/5)

    Rate it

    Read User's reviews

    Add your opinion




    Tips & Guides Related to SwisSQL SQLOne Console

    Related Software to SwisSQL SQLOne Console

    For Publisher of SwisSQL SQLOne Console

    Searches Related to SwisSQL SQLOne Console

    acuteapplets - web developer license firefox 3.5 vs ie 8 vs google chrome 3 internet explorer 8 opera 10 vs opera 9 queries converter skype for blackberry storm SQL dialect SQL queries web developer web page developer

    Free Download SwisSQL SQLOne Console

    Free Download ( Evaluation | 21.4 MB )