Features Sheet

Check it out the Features. Click on the Feature Link to get a full Description and a screenshot (if available).

  DBManager Professional Features Freeware Enterprise
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  

Direitos de Cópia © 2001-2005. DBTools Software.