Extract database schemas, build and run SQL queries, visualize data relationships in your databases, all with a single software package.
- Aglowsoft SQL Query Tools
- Version : 8.8
- License :Trial
- OS :Windows All
- Publisher :Aglowsoft
Aglowsoft SQL Query Tools Description
Aglowsoft SQL Query Tools deploys a collection of database applications that provide a simple means of creating and executing SQL scripts, drawing ER diagrams, and check out relationships between tables in databases, all without previous experience in working with database systems.
Extract OLE DB and ODBC-compliant database schemas
Aglowsoft Schema Tool is the first you must open, since it can connect to the target database and capture data. It ensures compatibility with OLE DB and ODBC-compliant databases, working with SQL Server, SQL Anywhere, Oracle, IBM DC2, Sybase, MySQL, Access, FoxPro, PostgreSQL, and more. The database schema is saved and displayed, enabling you to tamper with data relationships, table columns, primary keys, and so on.
Based on the extracted schema, Aglowsoft Designer can create view definition files, defining label (static), tree and table nodes. Tree nodes include SQL queries and can have descendants, whereas table nodes cannot.
View SQL query results in tree view
Unlike other database viewers and script builders, the approach this particular application adopts is quite different. The results of executed SQL queries and VDF files are displayed in the Aglowsoft Browser as view trees and tables, enabling you to explore the database properties and view relationships between tables.
Tables or individual rows can be saved in various formats, such as HTML, XML, CSV, Access 2000 database, ODBC database, or an INSERT SQL statement, while tree views can be printed or exported as XML or LDIF files.
Explore the structure of your database and execute queries
Aglowsoft SQL Query Tools makes it possible for you to extract and explore database schemas, create and execute SQL queries, and view the results in a slightly different manner. It can show you data relationships and enables you to browse the database structure while working in a user-friendly environment.