Introduction

Working with relational databases, the developer spends the most part of time for a creating of the SQL queries. The existing tools of their construction not always enable to automate process, show by sight the circuit of the tables and, frequently, simply there is no toolkit of creation of more specific features of languages SQL.

Other important problem while works with RDBMS is the processes replication of the data (or part of the data) from one RDBMS to another. Let's note, in this case are considered (examined) as replication in the same information storehouses, and carry given from different storehouses (for example, from MS-SQL Server to Oracle). Certainly, in most cases similar problems do not arise daily, but, if they are, on their decision the significant time is required.

With the help Visual SQL-Designer (VSD) you can quickly construct the most part of necessary queries, using only visual interface of the user. Using practically one mouse pointer, you can be connected to the circuit given, include the tables and fields in query, to group, to put conditions and to execute operation of sorting. Besides there is an opportunity visually to create so-called fields with conditions (CF) - logic designs of a kind:

If = 'the director' and = 'the chief of a department' to give out 'the Chief'
If = 'manager' to give out 'an Average part'
In other cases to give out 'the Ordinary the employee'.

The data of any of the made queries it is possible replicate. Thus the table in same RDBMS is automatically created which you will specify, same fairly and for representations of the data (Views).

The important feature VSD is that SQL the offer is designed in "native" language of RDBMS at uniformity of a source of the tables. If the tables belong different RDBMS- SQL query is under construction by rules RDBMS Access. In both cases the result of performance occurs on the monitor as the table.

In VSD the designer SQL most widely widespread (distributed) RDBMS is realized: Oracle, MS-SQL Server 6.X, MS-SQL Server 7.0, Sybase, DB2, Access and other ODBC databases.