Advertisement

Extracting and Exploring Database Schemas Made Easy

Aglowsoft SQL Query Tools comprises three database applications – Aglowsoft Schema Tool, Aglowsoft Browser, and Aglowsoft Designer – that let you easily create and execute SQL scripts, draw ER diagrams, and ascertain the relationship between database tables, without any prior working experience in database systems. The SQL queries result sets are presented as both table views and tree views. Tree view could be printed or you may export it to an LDIF or XML file. Table view could be exported to the Access 2000 database, ODBC database table, HTML or XML formats.

Aglowsoft SQL Query Tools includes 3 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.

PROS

  • Works with any ODBC and OLE DB-compliant database
  • Basic SQL knowledge would suffice
  • User-friendly interface
  • Multiple SQL statements supported

CONS

  • Documentation needs some work
  • Small bugs
  • Not updated frequently enough
  • Support could be better

Program available in other languages



User reviews about Aglowsoft SQL Query Tools

Have you tried Aglowsoft SQL Query Tools? Be the first to leave your opinion!


Advertisement

Explore More

Advertisement

Advertisement

Laws concerning the use of this software vary from country to country. We do not encourage or condone the use of this program if it is in violation of these laws. Softonic may receive a referral fee if you click or buy any of the products featured here.