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.
 |
|
Product Features
|
|
| |
| 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 |
| 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 |
|
|
| |
|
|
