| User Interface |
| Multiple Document Interface (MDI TAB) compatible with .NET Highly Configurable |
 |
 |
User Interface with tabbed windows. MDI allows multiple document frame windows to be open in the same instance of an application.
MDI has a Window within which multiple MDI child Windows, which are frame windows themselves, ca be opened, each containing a separate document.
The success of tabbed windows is because it strongly binds the document to the application and the user is confidently in control.
Screenshot
|
| Metadata Output Bar |
|
 |
The Metadata Output Bar shows the DDL/SQL commands to create a selected object. For instance: if a table is selected in the Objects Views
it will show you the DDL command that creates such object.
|
| Multiple Database Engine Support |
| MySQL and MySQL Through Webservices, PostgreSQL, Interbase, Firebird, SQLite, Xbase Tables |
 |
 |
The DBManager supports most of the open Sourced Engines. MySQL which is one of the most popular, may also be connected through HTTP protocol.
This feature, called MySQL Webservice, allows you to manage your MySQL database if it is hosted on an ISP which doesn't allow remote connections,
due to security reasons (which is very common nowadays).
|
| MSSQL Server and MSDE (7.0, 2000, 2003) |
|
 |
| Sybase (11.9, 12.5) |
|
 |
| MSAccess (97, 2000, XP, 2003) |
|
 |
| Oracle (8i) |
|
 |
| ODBC (3.51) |
|
 |
| Object Maintenance |
| Databases, Tables, Domains, User Types, Functions, Stored Procedures |
 |
 |
| Columns, Triggers, Foreign Keys, Check Constraints, Indexes |
 |
 |
| User and Group Management |
 |
 |
| Privilege Manager |
 |
 |
| Load and Save Binary Data (BLOB) |
 |
 |
With this feature you are able to Load and Export Binary Data from and to disk files. As BLOB columns type allow any binary data, you are able
to save any kind of disk file in your database.
|
| Common User Tools |
| Table Designer |
 |
 |
The Table Builder is the tool responsible for managing tables on a database. It allows to create a new table and edit its properties, like columns,
indexes, triggers, check and foreign key constraints.
Screenshot
|
| Query Builder and Query Designer |
 |
 |
The Query Builder is a powerfull tool to create your own queries. With features like: possibity to execute selected queries, use the Query Designer to
visually create your query makes it an important feature in any database management application.
Screenshot
|
| Datasheet Viewer (Table Data Editing) |
 |
 |
When editing data from your tables this feature makes the process much simpler. It supports navigating through the records with simple clicks,
and load data from tables with large ammount of records without slowing down your computer. When vieweing a table content it is possible to copy and paste
your data to/from clipboard. Also you can load and save binary data, and edit memo fields with its powerful editor. It also allows you to export the results to the following formats:
- Text Delimited or Formatted Files
- HTML Pages
- XML Files
- Xbase Tables
- MSExcel Worksheets
- MSAccess databases
Screenshot
|
| - Picture Viewer for Blob Content |
|
 |
If your table has binary data, let's say images, you can easily view the pictures by using the Image Viewer on the bottom output bar.
This is very usefull when loading and exporting binary data. The formats supported are: GIF, BMP and JPG images.
Screenshot
|
| Server Console |
 |
 |
As most DBA's are used to execute commands in the database console, the DBManager has a builtin console which can be used for all supported engines.
It works just the same as the console distributed with the database server application with a few extra capabilities.
Screenshot
|
| Advanced Tools |
| Query Builder IDE (Debugger, Planner and Multiple Result Sets) |
|
 |
Create and execute multiple statements queries, exibiting all the results in one window. This tool allows you to debug your queries with multiple statements to find which is one
is causing errors or problems, or generating the correct results. With the Query Planner feature you will be able to see how the database engine will handle it, allowing you to
take actions to speed up the execution and fetching the results.
|
| Diagram Designer |
|
 |
This tool speeds up the creation of the Database structure. You can graphically, create tables, columns and foreign keys
by just dragging and dropping fields from one table to another. using the dragand drop feature the Diagram Designer will deal
with creation of the column, index and all information required to create a foreign key. If you require database documentation,
this tool allows you to save and print the diagrams in any moment.
Screenshot
|
| Database Comparer |
|
 |
Have different database versions and need to update them all? That's an easy task with this wizard.
After comparing two distinct database you can edit the changes and select those you really want to be implemented.
This wizard allows you to create a DDL text file to update a remote database, or execute the process automatically.
Screenshot
|
| Form Designer |
|
 |
Entering data into tables can be a hard work, specially if this requires that your final users do the process.
DBManager Professional has a builtin Form Builder which can enable you to design your own forms and make the process
simpler.
Screenshot
|
| Task Builder |
|
 |
This feature enables you to automate import and export processes, and to manipulate data. A saved task can be executed
without loading the DBManager application, by using the startup parameters. This enables you to execute the task whenever you want.
Screenshot
|
| Server Monitoring (server, database and table) |
|
 |
Database Monitoring is an important task for every DBA planning to execute database tunning.
DBManager can monitor special activities showing important information about the status of your server, a single database, or a single table.
When monitoring a database you can graphically visualize the status of the most important resources and take actions required when a problem occurs.
Screenshot
|
| Report Builder |
|
 |
Creating reports is an import part of the process of managing database data. This tool allows you to create DrillDown HTML
reports based on a query and groupping information as required.
Screenshot
|
| Web Script Generator Wizard |
 |
 |
This tool allows you to create PHP and ASP scripts for the WEB. The generated scripts can then be used to create your website for the Internet and Intranet.
|
| - Support for PHP Scripts |
 |
 |
| - Support for ASP Scripts |
|
 |
| - Generate Scripts for Different Database Engines |
|
 |
| Database Versioning System |
|
 |
Keeping track of database version is a difficult task, specially if you are a consultanting company deploying your application to your clients.
This tool is aimmed to control the database version, allowing to generate DDL/SQL scripts to update or downgrade your database.
|
| Object Dependencies Browser |
|
 |
| Procedure Builder (Stored Procedure IDE) |
|
 |
Developing a Stored Procedure is a very difficult process. This tool make the process much simpler with builtin features like pre compilation in order to test
your procedure for failures before writting it to the database. The testing fase allows you to execute the procedure to find out if the results are the same as expected.
|
| Workgroup Support |
|
 |
Do you need power to use DBManager among a workgroup of DBAs or developers? This feature enables you to do that.
You can share Database connections, queries, structures, diagrams, documentation, and much more.
|
| Data Wizards |
| Text Import Wizard |
 |
 |
Imports Data from text Files: Delimited, Fixed ou Formatted. This wizard makes the process of loading data into your database much easier.
This is a highly configurable tool.
|
| Dao Import and Export Wizards |
 |
 |
Imports Data from MSAccess, MSExcel, Dbase III, Clipper, FoxPro, Paradox and ODBC datasources. Allows also to export an entire Database into MSAccess format.
|
| Dump Wizard |
 |
 |
Backups your database structure and data into DDL/SQL files which can be used to rebuild the database with very little effort. Allows to separate data and structure.
|
| XML Web Import Wizard |
 |
 |
XML is one of the most popular format for data exchange on the Internet. This wizard allows you to import data from XML files locally or remotelly through HTTP protocol.
|
| Data Migration Wizard |
|
 |