Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and write it.
Supported databases:
ORACLE 7.2-8.x
MS-SQL server 6.5-7.0-2000
SyBase System 11
Db2 for NT
MSAccess 97-2002
MySQL
ODBC datasources
Some functionality:
Union query builder.
Make table query builder.
OLAP inside.
Load external SQL-query (reverse engineering).
Show result sets in Print Preview by page and print on selected printer.
Show stored procedures from database and its parameters.
Stored Procedure execute wizard.
Feature of the given program is the opportunity of creation of query to diverse sources of the information, for example, to ORACLE and SYBASE simultaneously. Besides it is possible quickly and visually to create query with calculated fields in view of specificity of language of queries of a separate database. There is an opportunity of preservation of the created query as representation (VIEW) in a database for its further use.
The inclusion of OLAP functionality within Visual SQL-Designer helps make multidimensional analysis more affordable and brings the benefits of OLAP to a wider audience. Analyse external cube files and create Your own cube files from various database sources.
Your also needed some public library for correct setup:
Visual Basic 6.0 RunTime Library
Microsoft ADO 2.5 Library (MDAC_TYPE.EXE)
Microsoft DAO 3.60 Library
