Database Workbench is a complete database development environment offering you many features and tools, we have grouped the most important areas together. For the differences between the "Pro" and "Lite" editions, see the feature matrix.
In addition to these groups, Database Workbench comes with many small features and productivity tools. It is also well documented with an Online Help system.
Database Workbench is developed to support different database engines on a per module basis and is licensed per module, you need the "base" module and you can add additional modules to support different database engines.
Available modules for database engines are:
- Oracle Database® ( see Database Workbench for Oracle )
Versions: 8i, 9i, 10g and 11g - Microsoft SQL Servertm ( see Database Workbench for Microsoft SQL Server )
Versions: 7, 2000, 2005, 2008, including the MSDE/Express Editions - Sybase SQL Anywhere ( see Database Workbench for Sybase SQL Anywhere )
Versions: 9, 10 and 11 - Borland/CodeGear InterBase® ( see Database Workbench for InterBase )
Versions: 4.x, 5.x, 6.x, 7.x, 8.x (2007) and 9.x (2009) - Firebirdtm ( see Database Workbench for Firebird )
Versions: 1, 1.5, 2.0, 2.1 - MySQL® ( see Database Workbench for MySQL )
Versions: 4, 4.1, 5 and 5.1 - NexusDB ( see Database Workbench for NexusDB )
Versions: 3.0.x
License price depends on the modules you would like to include with your license. There's pricing information on our purchase page.
Diagramming is a key requirement when it comes to design and documentation.
Database Workbench includes a diagramming tool that supports both Conceptual Data Modeling and Physical Data Modeling. A Conceptual Model (CDM) is database system agnostic type of model and applies to business rules without going into the underlying physical representation in a database while a Physical Data Model (PDM) is the exact model for a database. From a CDM you can generate a PDM for a given database system including any database system specific datatypes or database objects like "domains".
The Diagram Editor supports sub-diagrams, object grouping, custom coloring, printing, comments and special "documentation link"-objects. It also supports Model Validation, Reverse Engineering of your existing database and Reverse Engineering of a selection of objects.
Maintaining your databases becomes easier with proper documentation, by printing a physical data model of your database or exporting the model as an image you can easily increase the usability of your developer documentation and make it easier for others to understand your database.
- Visually design your database
- Use Conceptual Data Modeling or Physical Data Modeling
- Sub-diagrams, coloring and object grouping for clarity
- Reverse engineer your database, validate your models
- Document your database or use the exported diagrams in your documentation
After design comes database development, by having the same user interface for different database systems and using visual editors, the developers don't have to switch between vendor tools and don't have to remember the exact SQL dialect differences. This makes it easier to develop your database and saves both time and money.
Database development is an endless cycle of design, implementation, testing and modification.
The Database Navigator tool and the object editor tools list object dependencies, allow you to browse your existing database structure recursively and use the context sensitive menus for quick access to all sorts of useful tools. You can easily count the table rows, create SUID Procedures, browse, delete or update table data or export the data to different formats including INSERT scripts. Use the "Workspace" to group objects that are of importance to you, keep Notes and To-Do Lists as reminders during your development process.
Use the Visual Query Builder to create SQL statements and the "Special Copy & Paste" tools to put SQL statements to and from your Delphi, C++ or ASP source code, archive Code or SQL Snippets for later usage.
- Browse, create and modify database objects
- Visual tools avoid the need to remember vendor specific SQL dialects
- Many tools available in an easy-to-use user interface
- Many productivity increasing database developer tools available
- Sophisticated Visual Query Builder to easily create complex SQL statements
You can run queries, import existing data using scripts, CSV files or you can use the DataPump tool to directly transfer data from other data sources, including ADO and ODBC.
You cannot test without a properly filled database.
A simple Test Data Generator tool is included so you can quickly generate thousands of rows of data to get a filled database (also see our Advanced Data Generator tool) to test your queries on.
If you use Stored Procedures, Functions and Triggers, you can use the Debugger tool to step through your source code and check your application logic, evaluate variables and parameters or modify variable to change the flow of your routines. You can always test output parameters by testing the Procedure and Functions without having to go through your application.
- Run queries
- Import and export data
- Generate test data
- Debug Stored Procedures, Functions and Triggers
Performance monitoring, managing user privileges, backup and restore: typical DBA tasks.
Database Workbench is useful to Database Administrators too. It comes with GUI functionality for both server administration and database administration tasks. You can monitor server performance, create user accounts, watch the server log or modify storage areas on your server. These windows and dialogs make it possible to get to the problem areas fast and easy.
With its Grant Manager tool and graphical grid-views of user, role and group privileges, user administration becomes a breeze.
- A graphical interface to database and server administration tasks
- Performance monitoring
- User, role and group administration
- Privilege overviews and modifications via visual Grant Manager tool
Sr Software Developer
vaxxin BV