Buy Online or call : +91 8025203918/ +91 9900195265

SELECT SOFTWARES ONLINE STORE

Your One Stop Software Shop for IT Requirement!!
you Name IT We Provide IT



AQT provides a simple and easy-to-use interface to your many different databases. With a feature-rich query environment and a wide range of DBA and developer tools, it is the ideal database product irrespective of whether you are a data analyst, DBA or developer.
Pricing
Price per unit is shown below.Price in:
PublisherPartNo Description Rate Download Size
AQT v10 Standard Edition New license 1 to 9 licenses   180.00 AddtoCart
AQT v10 Standard Edition New license 10 to 19 licenses   160.00 AddtoCart
AQT v10 Standard Edition New license 20 to 49 licenses   140.00 AddtoCart
AQT v10 Standard Edition New license 50 to 99 licenses   120.00 AddtoCart
AQT v10 Standard Edition New license 100 to 199 licenses   110.00 AddtoCart
AQT v10 Extended Edition New license 1 to 9 licenses   360.00 AddtoCart
AQT v10 Extended Edition New license 10 to 19 licenses   320.00 AddtoCart
AQT v10 Extended Edition New license 20 to 49 licenses   280.00 AddtoCart
AQT v10 Extended Edition New license 50 to 99 licenses   240.00 AddtoCart
AQT v10 Extended Edition New license 100 to 199 licenses   220.00 AddtoCart
AQT Standard Edition license to v10 Extended Edition license Upgrade1 to 9 licenses Verify   180.00 AddtoCart
AQT Standard Edition license to v10 Extended Edition license Upgrade10 to 19 licenses Verify   160.00 AddtoCart
AQT Standard Edition license to v10 Extended Edition license Upgrade 20 to 49 licenses Verify   140.00 AddtoCart
AQT Standard Edition license to v10 Extended Edition license Upgrade 50 to 99 licenses Verify   120.00 AddtoCart
AQT Standard Edition license to v10 Extended Edition license Upgrade 100 to 199 licenses Verify   110.00 AddtoCart
AQT Standard Edition to v10 Standard Upgrade 1 to 9 licenses Verify   45.00 AddtoCart
AQT Standard Edition to v10 Standard Upgrade 10 to 19 licenses Verify   40.00 AddtoCart
AQT Standard Edition to v10 Standard Upgrade 20 to 49 licenses Verify   35.00 AddtoCart
AQT Standard Edition to v10 Standard Upgrade 50 to 99 licenses Verify   30.00 AddtoCart
AQT Standard Edition to v10 Standard Upgrade 100 to 199 licenses Verify   28.00 AddtoCart
Extended AQT Edition to v10 Extended Upgrade 1 to 9 licenses Verify   45.00 AddtoCart
Extended AQT Edition to v10 Extended Upgrade 10 to 19 licenses Verify   40.00 AddtoCart
Extended AQT Edition to v10 Extended Upgrade 20 to 49 licenses Verify   35.00 AddtoCart
Extended AQT Edition to v10 Extended Upgrade 50 to 99 licenses Verify   30.00 AddtoCart
Extended AQT Edition to v10 Extended Upgrade 100 to 199 licenses Verify   28.00 AddtoCart
Advanced Query Tool features

Database Explorer
  • shows you comprehensive information about the objects in your databases
  • not just tables, but also views, aliases, indexes, tablespaces, triggers, procedures, functions,  users, authorities
  • unique 3-pane displays makes it easy to deal with thousands of objects
  • can sign onto multiple databases
  • configured individually for Oracle, DB2/UDB, DB2 z/OS, DB2 for iSeries, Sybase  Anywhere, Sybase ASE, Sybase IQ, MS SQL Server, Informix, MySQL, Pervasive.SQL, SQLBase, PostgreSQL, Interbase/Firebird, Netezza, Progress, MAXDB/SAPDB, IDMS, RedBrick, NonStop SQL/MX, NonStop SQL/MP, EXASolution, Teradata
  • configuration-driven system; displays can be amended or altered
  • can define and display Favorites
  • display your Saved Queries - useful for those who run pre-build queries

  • Run SQL

  • syntax highlighting of SQL
  • "intellisense" giving you a popup list of schema, tables, columns and column functions
  • save / retrieve queries
  • SQL can contain substitutional parameters (values are prompted when SQL is run)
  • SQL History (saved to disk between sessions)
  • single-click table and column analysis
  • format SQL
  • Search Table window to easily build simple searches (screenshot)
  • long-running queries can be cancelled
  • run scripts containing thousands of SQL statements. Scripts can be paused, amended, restarted
  • run Stored Procedures. These can contain INOUT and OUT parameters, and produce multiple result-sets
  • explain plan (for DB2/UDB, DB2 z/OS, Oracle, SQL Server, Sybase, MySQL)

  • Displaying Data
  • display large values and multi-line text
  • group query results
  • display row detail
  • display LOB columns. LOB values can be displayed in an external application
  • display Unicode data
  • display XML values with AQT's XML Viewer
  • sort, copy, print, save, compare query results; move, freeze, hide columns
  • display totals and subtotals, save/load display layouts
  • display data from related tables
  • pivot a column for data summarization

  • Updating Data

  • build and run update / delete / insert statements
  • build either single-row update/deletes or mass update/deletes
  • updates can run under transactional control
  • inline-editing of table data
  • has safe update mode to prevent inadvertent mass updates/deletes
  • insert / update LOB values

  • Graphical Query Builder

  • many users have said that this is the best query builder on the market
  • quickly build multi-table queries
  • auto-detect table relationships
  • reverse-engineering capability - take an existing SQL query and display it as a graphical query
  • support for table expressions / inline views
  • build complex Where clauses and Column expressions
  • use native or ansi join syntax
  • many options for formatting the SQL
  • has a sophisticated window for building Where clauses

  • Data Export

  • export to csv, HTML, Excel, fixed format, XML
  • export to HTML has full options for HTML formatting and use of style sheets (example)
  • export to XML follows dbunit specifications
  • can export data as a series of Insert statements
  • export to HTML and Excel can hyperlink to LOB files (example)
  • has native interface to Excel (you do not need Excel installed on your PC)

  • Charting

  • you can create Charts from your data
  • once you have defined a Chart, you can save it to disk (as a file). It will appear in the Queries display of the Database Explorer window, and can be defined as a Favorite
  • the Chart can be refreshed with current data with a couple of clicks
  • charts can be created in batch (unattended) mode

  • Database Administration (Extended Edition only)
  • create / alter / drop objects
  • not just tables, but also indexes, foreign keys, tablespaces, triggers, procedures, functions, users
  • admin module has been developed for Oracle, DB2/UDB, DB2 z/OS, DB2/400, Sybase Anywhere, Sybase ASE, MS SQL Server, Informix, MySQL, Pervasive.SQL, SQLBase, PostgreSQL, MS Access, Interbase/Firebird
  • generate full DDL for objects
  • security administration
  • full compare of table definitions (including indexes, keys, constraints)
  • excellent cross-database support - copy/compare objects definitions between databases of different types

  • Data Loader (Extended Edition only)
  • load data from delimited files, Excel files, tables, queries
  • load data from one database to another database type (eg. Oracle to DB2)
  • copy LOBs between databases
  • graphical mapping of target columns from source
  • transform data from source to target
  • preview data before loading
  • comprehensive options for transactional control and error handling
  • restart the load after failure
  • can be run in batch mode
  • has native interface to Excel (you do not need Excel installed on your PC)

  • Data Compare (Extended Edition only)
  • compare data in tables, views, or results of queries
  • compare data across databases of different types
  • generate a script to resync table contents
  • compare full LOB values
  • can be run in batch mode

  • Object Compare (Extended Edition only)
  • compare the definition of objects from one system to another
  • compare across databases of different types
  • compare not just tables but also indexes, keys and other objects
  • compare all the objects in a schema
  • can specify what parameters of an object are compared

  • System Monitor (Extended Edition only)
  • configured for DB2/UDB, Oracle, Sybase, SQL Server
  • monitor many different parts of your system
  • displays can be customized
  • critical conditions can be highlighted
  • has auto-refresh