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-9.x
- MS-SQL server 6.5-7.0-2000
- SyBase System 10-11
- Db2 for NT
- MSAccess 97-2002
- MySQL
- Teradata
- ODBC datasources
Some functionality:
- Allow update opened resultsets.
- Delete query builder.
- 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.
- Export of the data of Query to files of various formats.
- Support Oracle Object Types in SQL-query
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
