Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any Datenbank and write it. Support ORACLE, MS-SQL server 6.5-7.0-2000, MySQL,SyBase,Teradata, Db2 for NT, MSAccess and other ODBC databases.
Allow update selected data.
Union query builder.
OLAP inside.
Make Table SQL-query builder.
Delete query builder.
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 ORACLE and SYBASE simultaneously. Besides it is possible quickly and visually to create query with calculated fields in view of specificity of Sprache of queries of a separate Datenbank. There is an opportunity of preservation of the created query as representation (VIEW) in a Datenbank for its further use.
Load external SQL-query (reverse engineering).
Show result sets in Print Preview by page and print on selected printer.
Union query builder.
Extract DDL scripot for some Datenbank objects.
Show stored procedures from Datenbank and its parameters. Stored Procedure execute wizard.
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 Datenbank sources.