Aglowsoft SQL Query Tools 5.3.4

Aglowsoft SQL Query Tools 5.3.4 offers an effective tool which consists of three database tools. They are Aglowsoft Schema Tool, Aglowsoft Designer, and Aglowsoft Browser. The tools are designed to allow building of SQL queries with basic knowledge of SQL using user-friendly interface. Result sets from SQL queries are presented in a combination form of view trees and table views. View tree can be printed or exported to an XML file or an LDIF file, and table view can be exported to ODBC database table, Access 2000 database, XML or HTML format.

A key feature of Aglowsoft SQL Query Tools is the ability to build SQL queries in the form of view definition tree, where a path in the view definition tree discloses relationships between data from different tables. Aglowsoft SQL Query Tools works with any OLE DB and ODBC-compliant database. SQL statements supported include SELECT, INSERT, UPDATE, and DELETE. The program includes Unicode support, support for ANSI inner and outer joins, entity relationship diagram, and DDL Generation for relationships.

Major Features:

1. Aglowsoft Schema Tool:

• Capture the meta data from OLE DB or ODBC database.
• Have the extracted schema which is saved to a file which is called SHM (Schema ) file.
• Refine the captured meta data by defining primary keys, entity relationships, and column aliases.
  
• Use the table columns, primary keys, relationships, and column aliases to build SQL queries.

• Create view definition tree using schema information contained in SHM file.
• Have the view definition tree which is a collection of view definition nodes.
• Have each view definition node may have a SQL query associated with it.
• Save the results of the view definition tree to a View Definition File (VDF).

• Navigate the View Definition File (VDF).
• Browse the tree view through point-and-click interface.
• Show the resulting SQL queries in the Properties tab of the Aglowsoft Browser.
• Be used for navigating OLE DB and ODBC database tables/views.

Requirements: Microsoft Internet Explorer 6.0 or higher