CoderTools Independence Software LLP
   
 
TotalQuery v 2.0 - The multi-database query and design tool
Download TotalQuery (30 day trial) Download TotalQuery (30 day trial)
Buy TotalQuery Buy Now
bullet Free Product Upgrades
bullet Comprehensive Technical Support
bullet Secure Online Payment with Paypal
bullet 30 Day Money-back Guarantee
Volume Discounts Corporate discounts are available
Email sales@codertools.com for more information
Key Features:
Key selling pointConnect to almost any database
Key selling pointEasy to use Connection Wizard View example
Key selling pointDatabase Browser View example
Key selling pointProject File Browser View example
Key selling pointGenerate SQL code from your existing View example
database
Key selling pointAuto-complete for common SQL commands View example
Key selling pointCode Folding to help edit your SQL View example
TotalQuery
TotalQuery is a quality multi-database query, SQL editing and design tool. It makes it easier for you to read and write data to all of your databases*.

Through the built-in connection wizard you can quickly and easily connect to the following databases:

  • Microsoft® Access™ 2003 and 2007
  • Microsoft® SQL Server® 2000, 2005 and 2008
  • Microsoft® SQL Server Express® 2005
  • Oracle® 8, 9, 10 and 11
  • Oracle® XE (Express)
  • MySQL®
  • Any OLEDB/ODBC accessible database

It has a broad range of built-in features that will help you to run multiple queries at the same time whilst being kept informed of what the connected databases are doing.  Navigating the results is easy through an Excel styled report, which enables you to sort results without requerying the database and copying results to the clipboard for use in TotalQuery and other applications.

The transaction manager** helps you to control the updates you command of your databases through the press of a button and is just one of many features built into the tool available to help you complete your work as quickly as possible.

* Connectivity is dependent on the OLEDB database connection technology built into Microsoft® Windows®.  Additional manufacturers drivers (also known as providers) may be needed to connect to your chosen database server.

** Push button management of database transactions in dependent on support offered in the database driver/provider used.

spacer
Page Options
spacer
 
bullet Product Features    
bullet Screen Shots    
 
     
spacer
Product Features
spacer
 
Feature Overview Feature Database Explorer
Feature Save Connection Details Feature Database Connection Wizard
Feature SQL Code Generation Feature Export Database Results to XML
Feature Database Results Feature File Editing and Style
Feature Customization and Configuration Feature Search and Replace
Feature Printing and Print Preview Feature Project Browser
Feature SQL Code Folding  
Overview
Feature
Connect to most databases. An OLEDB or ODBC driver supplied by the database manufacturer may be required
Multi-tasking - Run many queries at the same time
Cancel running queries easily through a menu option
Generate the DDL/SQL of your tables, views and procedures. Plus create the Select and Insert SQL needed to use your tables and view with a mouse click
Export selected data to an XML file
Project Browser to manage your SQL files without needing to access Windows Explorer
Back to Feature Menu
Saved Connection Manager
Feature
TotalQuery will remember the connection details of any database that you connected. Provide your connection details once and in the future access your database through a single click of the mouse
Through the Saved Connection Manager you can:
  • Connect to your database ready to execute an SQL Query
  • Connect to your database to view it inside of the Database Explorer
  • Copy the connection string to the clipboard
  • Remove the connection when it is nolonger required
Back to Feature Menu
Connection Wizard
Feature
Takes the complication out of connecting to your databases
Allows you to save your connections to the Saved Connection Manager
Test your connection details before writing any queries or explorer the database
Built-in connection support for:
  • Microsoft® Access™ 2003 and 2007
  • Microsoft® SQL Server® 2000, 2005 and 2008
  • Microsoft® SQL Server Express® 2005
  • Oracle® 8, 9, 10 and 11
  • Oracle® XE (Express)
  • MySQL®
  • Any OLEDB/ODBC accessible database
Note: A manufacturer's driver may be required to connect to your database. See the TotalQuery help for more information
Automatically provides most connection details using the manufacturer's default values to help speed up the connection process
Back to Feature Menu
SQL Code Generation
Feature
Generate the DDL/SQL code used to create you database objects with a single mouse-click. This feature is supported on:
  • Microsoft® SQL Server®
  • Microsoft® SQL Server Express®
  • Oracle®
  • Oracle® XE (Express)
Generate the SQL needed to select from your tables and views with a single mouse-click
Generate the SQL needed to insert into your tables and views with a single mouse-click
Back to Feature Menu
Export All Selected Data As XML
Feature
Export any selected data as XML. Simply selecting "Export As Xml..." from the result table and then chosing a file name will allow you to export all selected data into an XML file
Back to Feature Menu
Code Folding
Feature
Hide portions of your SQL code with a single click of the mouse. Collapse and expand different parts of the active document to help you see all of your code
Back to Feature Menu
Database Explorer
Feature
Easily navigate the different objects of your database including tables, view, stored procedures, and indexes
Multi-tasking. Navigate remote databases and continue with other tasks whilst information is being retrieved
Refresh any part of the tree it view new objects
Create new query documents using the same connection as the selected database or server
Drag and drop object labels from the explorer and onto your query documents. For example add the name of a table to your query
Connect to as many servers as needed and all at the same time. Each server is presented as a unique folder
Easily generate the DDL/SQL used to create your tables, views, procedures and functions. You can also create Select and Insert SQL of your tables and views
Back to Feature Menu
Database Results and Notifications
Feature
Query results are presented in an Microsoft Excel style view
Sort table data without needing to requery the database. With a click of the mouse ascending or descending sort any result column
Select All, rows, columns or a block of data
Copy any selected data to the clipboard for use in other queries or applications
View database notifications and notices through a dedicated message window. The message window is available to help understand when queries went well or errored and what information the database supplied in each situation
Export any selected data into an XML file
Database dependent each query document presents different information on its status bar including
  • User name
  • Current database that queries will run against
  • Server name
  • Number of rows returned by a query
  • Elapsed and completed query time
  • Clear labelling for when queries succeeded, completed with errors or cancelled by the user
Back to Feature Menu
File Editing and Style
Feature
Cut, copy, and paste plus all other text formatting features to help with query development
Syntax coloring to improve the readability of your queries. This can be enabled or disabled too
Edit the colors used to markup your text
Change the font style and size plus the colors used for marking up selected text
Back to Feature Menu
Customization & Configuration
Feature
Customize the application including
  • Keyboard shortcuts
  • Toolbars and their buttons
  • Menu items
  • Toolbar button size
Configuration editor options
  • Control how tabs should be added to your files.  Either as Spaces or tab characters
  • Control how large a tab show be displayed in the editor
  • Enable or disable the automatic reloading of documents that we modified outside of the tool
  • Edit the colors used by the syntax highlighting
  • Enable large or small icons on the toolbar
Back to Feature Menu
Search & Replace
Feature
Select between searching upward or downward through your document
Replace All.  Change all found copies of your search text with a new value
Filter a search such that it only matches the same case as your query text
Apply a filter a such that it only matches the whole word being searched
Back to Feature Menu
Printing & Preview
Feature
Full color print preview
Full color printing
Back to Feature Menu
Project Browser
Feature
The Project Management Browse allows you to view a single directory on your computer. You can organize, create, delete files and folders, which is immediately reflected on your computer
Quickly switch between any number of folders setup in the project explorer
Use folders to aid with the organization of your files
Add and remove files from the Project Management Explorer
Drag and drop any file or subfolder inside of the project explorer
Quickly open any file by double-clicking on it
Back to Feature Menu
 
     
spacer
Screen Shots
spacer
 
TotalQuery
TotalQuery
Application
TotalQuery Connection Wizard
TotalQuery
New Connection
Database Browser
Database
Browser
Project Browser
Project
Browser
SQL Generation
SQL Code
Generation
SQL Command Auto Complete
SQL Command
Auto Complete
Back to Top