Visual SQL-Designer Light is a program for easy visual constructing hard SQL-query for any database and write it.
Supported databases:
MS-SQL server 6.5-7.0-2000
MSAccess 97-2002
MS Excel
Dbase or Paradox tables
ODBC datasources
Some functionality:
Allow update opened resultsets.
Delete query builder.
Union query builder.
Make table query builder.
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.
Feature of the given program is the opportunity of creation of query to diverse sources of the information, for example, to DBase and Excel 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.
Your also needed some public library for correct setup:
Visual Basic 6.0 RunTime Library
Microsoft ADO 2.5 Library SP2 (MDACTYPE.EXE)
Microsoft DAO 3.60 Library
Visual development system for MySQL database design, modeling, and creation.
You can perform database structure modeling, generation and modification.
Comments