Product Information
Product Resources
Features Sheet

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

  DBManager Features Standard 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.

    - Standard Scheme (MSOffice 97 compatible)
    - Windows 2000, MSOffice 2000 Scheme
    - Windows XP
    - MSOffice XP/2003 Scheme
    - MSOffice 2003 AutoColors TAB
    - Visual Studio .NET Scheme
Metadata Output Bar Registered Only
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
The Freeware Edition supports only one server at a time. The Standard Edition can manage all Open Sourced Databases and the Enterprise Edition can manage all engines at the same time, maximizing speed and usualibity.
MySQL, PostgreSQL, Interbase, Firebird, SQLite, DBF Tables
MySQL WebServices (Connect to MySQL using HTTP protocol) Registered Only
Execute Queries on DBF Tables Registered Only
MSSQL Server and MSDE (7.0, 2000, 2003)  
Sybase (11.9, 12.5)  
MSAccess (97, 2000, XP, 2003)  
Oracle (8i, 9i, 10g)  
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.

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.

    - Query Debugger Registered Only
    - Query Planner Registered Only
    - Picture Viewer Registered Only
    - Multiple Result Set Registered Only
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 (Enterprise Edition only):
  • Text Delimited or Formatted Files
  • HTML Pages
  • XML Files
  • DBF Tables
  • MSExcel Worksheets
  • MSAccess databases

    - Picture Viewer for Blob Content Registered Only
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.

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.

Advanced Tools
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.

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.

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.

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.

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.

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.

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 Registered Only
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