Visual SQL-Designer is a user-friendly software that simplifies the creation of complex SQL-queries for various databases such as ORACLE, MSSQL, MySQL, and more. It features a union query builder, OLAP integration, and stored procedure support.
Visual SQL-Designer is a software program designed for easy visual construction of complex SQL queries for any database, including ORACLE, MS-SQL server 6.5-7.0-2000, MySQL, SyBase, Teradata, Db2 for NT, MSAccess, and other ODBC databases. The program allows for the update of selected data, has a Union query builder, and includes OLAP functionality.
One of the key features of Visual SQL-Designer is its ability to create queries for diverse sources of information, for example, to ORACLE and SYBASE simultaneously. The program also allows for quick and visual creation of queries with calculated fields that take into account the language specific to each database. Users can save created queries as representations (VIEW) in a database for future use.
In addition, Visual SQL-Designer enables external SQL-query loading (reverse engineering) and a feature for showing result sets in print preview by page and printing on selected printers. It also includes a Delete query builder and allows for the export of Query data to files of various formats. Users can extract DDL scripot for some database objects and show stored procedures from a database along with its parameters.
The program includes a stored procedure execute wizard and a Union query builder, and it incorporates OLAP functionality, making multidimensional analysis more affordable and accessible to a wider audience. Users can analyze external cube files and create their own cube files from various database sources. Overall, Visual SQL-Designer is a comprehensive software program that offers a range of features for creating and managing SQL queries across multiple databases.
One of the key features of Visual SQL-Designer is its ability to create queries for diverse sources of information, for example, to ORACLE and SYBASE simultaneously. The program also allows for quick and visual creation of queries with calculated fields that take into account the language specific to each database. Users can save created queries as representations (VIEW) in a database for future use.
In addition, Visual SQL-Designer enables external SQL-query loading (reverse engineering) and a feature for showing result sets in print preview by page and printing on selected printers. It also includes a Delete query builder and allows for the export of Query data to files of various formats. Users can extract DDL scripot for some database objects and show stored procedures from a database along with its parameters.
The program includes a stored procedure execute wizard and a Union query builder, and it incorporates OLAP functionality, making multidimensional analysis more affordable and accessible to a wider audience. Users can analyze external cube files and create their own cube files from various database sources. Overall, Visual SQL-Designer is a comprehensive software program that offers a range of features for creating and managing SQL queries across multiple databases.
What's New
Version 4.01: N/A