 |
TotalQuery v 2.5 - The database query and development tool for Microsoft SQL Server, Oracle, MySQL and more
|
|
|
Key Features:
| » | Connect to almost any database |
| » | Easy to use Connection Wizard |
| » | Database Browser |
| » | Project File Browser |
| » | Generate SQL code from your existing database |
| » | Auto-complete for common SQL commands |
| » | Code Folding to help edit your SQL |
|
|
 |
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 |
| Export selected data to a user-defined delimited text file |
| Project Browser to manage your SQL files without needing to access Windows Explorer |
| Switch quickly and easily between databases using a toolbar mounted drop down list |
|
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 |
| 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
|
| Export any selected data as a delimited text file, which can be understood by applications like a Spreadsheet.
Simply selecting "Export..." from the result table and then
chosing a file name along-with a delimited will allow you to export all selected data into a new 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, keys, triggers, 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, triggers, procedures and functions. You can
also create Select and Insert SQL of your tables and views |
| Review the properties of different database objects including the rules that are modelled inside of constraints and foreign keys |
|
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 (with the option to include database column names) 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 |
| Export any selected data into a delimited file |
| Change the font used to present results |
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 |
|
|