Database Workbench learn how it's useful for you

Unicode Enabled

Database Workbench is fully Unicode enabled, it can create, display and edit Unicode data and even meta data.

Exporting Unicode data, importing Unicode text files or transferring Unicode data between database systems: it's all available in Database Workbench.

Work Space and Tools Features

There's more "work space" features in Database Workbench and it's easier to stay in control with these tools:

• Object Editors include a To-Do list and there's an overview of all To-Do items
• The SQL History, a list of SQL statements executed in the past, is now persistent across sessions
• There is now a "project"-based SQL/Code Catalog, to store SQL/Code snippets specific to that database
• The new object filter in the Database Navigator let's you find objects more easily
• "Search Database" now has the possibility to search for a data type, including domains and object types
• The Grant Manager tool includes column based privileges
• The Data Pump can be started directly from a session, with a source or destination database connected
• The Package Editor includes a Package Explorer, a list with all methods and statements in the package

Advanced Code Editor Features

Writing code should be easy

There are several new features in the SQL and Stored Code Editor control:

• Code Folding:
  "collapse" comments or known blocks to save space and get a better overview of your code.
• Block Staples:
  these colored staples clarify the code flow as they show instantly where a code block starts end ends.
• Current Block Highlighting:
  when moving the cursor up and down, the nearest block is highlighted for clarity.
• Differently Colored Data Dictionary Tables:
  System tables, also called "Data Dictionary Tables" now have their own coloring.
• Object Linking:
  Press the Ctrl-key and move over an object name to highlight it, click to open up an editor with the given object.

Consistency across different DBMS versions

If you use multiple database systems or multiple versions of those systems, you know that the vendor tools often differ between versions, are incompatible with each other and differ a lot between vendors.

Database Workbench offers a consistent user interface across database system versions and across the different database systems from vendors.

Using a single familiar tool to do your work saves time and money and increases your working pleasure.

MySQL, MariaDB and PostgreSQL Tunneling

New features and improvements to access 3rd party servers

For secure access to remote servers, Database Workbench has improved it's SSL access and includes SSH Tunnel technology. A custom PHP-script is available to use a HTTP tunnel (MySQL/MariaDB only).

The new embedded SSH client makes it easier to create a secure tunnel to a MySQL or PostgreSQL database running on a webhoster server, for example.

Other improvements for this scenario include support for restricted access to server commands, like no SHOW DATABASES support.

Data Model Design

Design and develop from a single conceptual data model to the different DBMS specific physical models.

Reverse engineer existing databases to print graphical overviews.

Create sub-diagrams for clarity in complex databases, to group tables related to specific functionality.

Visual Object Editors and Modern Code Editors

Create and modify databases objects in graphical editors, no need to remember specific SQL syntax.

The editors allow you to easily create database objects, copy DDL statements, duplicate objects, browse data and much more.

Across different DBMS-modules, Database Workbench has a consistent user interface and offers modern code editor features.

Stored Routine Debugging

Debug Stored Procedures, Stored Functions, Packages and Triggers in your database.

Execute a routine step by step and use "trace into" to see what's going on.

(available for InterBase, Firebird, MySQL, SAP SQL Anywhere and Oracle)

Productivity Tools

Many productivity tools are available:

• Two-Way Visual Query Builder
• SQL and Parameter Insight
• Code and SQL Catalogs
• Object and Code Templates
• Drag and Drop Objects

Database Compare and Migration

Compare development with production databases and get a "change script".

Compare databases, even across different database systems, with automatic data type and default function mapping.

Migrate meta data structures from one database system to another.

Transfer, import and export data

Database Workbench includes a datapump tool to quickly transfer data between databases and even any ODBC or ADO data source.

You can also import and export data, including but not limited to, CSV files. Large files (over 2GB) are supported.

Report Editor

A custom report writer is included:

• Create (re-usable) reports based on your data
• Use labels, lines, shapes, to design your reports
• Store reports in files or in your Workspace Project
• Sample reports included

SQL Insight and Join Completion

This video shows in detail how SQL Insight works in Database Workbench.

This includes filtering and Join Completion, a feature that uses existing foreign key constraints to help you to write your SQL statements.

Visual Query Builder

The Two-Way Visual Query Builder is a helpful tool when building complex queries.

You can easily create JOINs, UNIONs, grouping, use derived tables, sub-queries and much more.