Brothersoft.com Windows | Games | Mobile | Wallpapers

Advertisement

AdventNet SwisSQL - SQLOne Console 4.2

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

Advertisement

Last Week downloads: 0
Total downloads: 281
  • Last Updated: Jan 5, 2009
  • License: Shareware $395
  • OS: Windows XP/2000/98/NT/Linux
  • Requirements: No special requirements

User reviews

0 out of 5 based on 0 ratings for AdventNet SwisSQL - SQLOne Console 4.2

For AdventNet SwisSQL - SQLOne Console 4.2Publisher's description

Advertisement

AdventNet SwisSQL - SQLOne Console is a Business software developed by ZOHO Corp. After our trial and test, the software is proved to be official, secure and free. Here is the official description for AdventNet SwisSQL - SQLOne Console:

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.

For AdventNet SwisSQL - SQLOne Console 4.2Related Software

Statement

Please be aware that Brothersoft do not supply any crack, patches, serial numbers or keygen for AdventNet SwisSQL - SQLOne Console,and please consult directly with program authors for any problem with AdventNet SwisSQL - SQLOne Console.