Free AdventNet SwisSQL - SQLOne Console 4.2 Download
Current Page: Home > Business > Database Management >

AdventNet SwisSQL - SQLOne Console 4.2 Download

AdventNet SwisSQL - SQLOne Console 4.2

License: Shareware $395
Downloads:
Publisher: ZOHO Corp
File size: 21.4MB
OS: Windows XP, 2000, 98, NT,Linux
Date added: 2009-10-27
Homepage: http://www.adventnet.com
Category: Business

AdventNet SwisSQL - SQLOne Console 4.2 Description

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


BSEditor: * 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. you can free download AdventNet SwisSQL - SQLOne Console 4.2 now.

AdventNet SwisSQL - SQLOne Console 4.2 Keywords

adventnet, NT console

AdventNet SwisSQL - SQLOne Console 4.2 Related Software

AdventNet SwisSQL - SQLOne Console 4.2 Publisher's Software

    Software by Letter

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Others

    New Release Software