Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
AQT is a multi-database query and admin tool designed for DBAs, database developers and data analysts.
AQT uses a native ODBC interface that runs reliably and efficiently against databases of all sizes. It has been specifically customized for over 30 dufferent database types and displays more information about your database than any other product on the market.
It is in use in a large number of sites running DB2 z/OS and many customers have commented that it is by far the best product with that database. But not just DB2 z/OS, but also Oracle, SQL Server, MySQL, PostgreSQL and others.
Data analysts will enjoy the SQL editor, SQL history, graphical query builder, table editor, data export and charting features.
DBAs and developers will be delighted with generate DDL, object compare/resync, data compare/resync, data loader, create/alter/manage objects, visual explain and system monitor.
Description
SQL Workbench/J is a versatile and free SQL query tool that operates independently of any specific database management system and is compatible with various operating systems due to its Java foundation. It is designed to execute SQL scripts, whether interactively or in batch mode, while also offering robust import and export functionalities. Although it does not prioritize graphical query building or complex database administration tasks, it includes a powerful export command that allows users to generate text files, XML, HTML, or SQL formats, including support for BLOB data. Users can easily export all tables from a database to a designated directory using a single command, and the export files can be compressed during the process. The tool also supports efficient import of text, XML, and spreadsheet files, enabling users to bring in sets of files, including compressed versions, from a directory with one command. Additionally, it intelligently detects foreign key constraints to ensure proper data insertion order. Users can also compare two database schemas to identify differences, and the tool provides the capability to convert XML output into the appropriate SQL ALTER statements using XSLT, enhancing its functionality even further. Overall, SQL Workbench/J serves as a comprehensive solution for users seeking a straightforward approach to managing SQL queries across various platforms.
API Access
Has API
API Access
Has API
Integrations
CA IDMS
Firebird
IBM Db2
IBM Informix
IBM Netezza Performance Server
IBM z/OS Connect
InterBase
Microsoft Access
Microsoft Excel
MySQL
Integrations
CA IDMS
Firebird
IBM Db2
IBM Informix
IBM Netezza Performance Server
IBM z/OS Connect
InterBase
Microsoft Access
Microsoft Excel
MySQL
Pricing Details
$210 one-time payment
Free Trial
Free Version
Pricing Details
No price information available.
Free Trial
Free Version
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Vendor Details
Company Name
Cardett Associates Ltd
Founded
1999
Country
New Zealand
Website
www.querytool.com/index.html
Vendor Details
Company Name
SQL Workbench
Founded
2020
Website
www.sql-workbench.eu/
Product Features
Database
Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization
Product Features
Database
Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization