Database Workbench Pro versions

v5.1 [Jul 27, 2015]
New Database System Support
Database Workbench 5 offers support for the latest versions of database systems and offers new support for MariaDB.
Support for MariaDB 10
Support for MySQL 5.6 and 5.7
Support for Oracle 12
Support for SQL Anywhere 16
Support for InterBase XE3
Support for SQL Server 2012 and SQL Azure
Support for Firebird 3
And what's more, work to support PostgreSQL has already started!
New User Interface Features
There are many new user interface features in Database Workbench.
HiDPI aware: tested with scaled fonts and includes a set of large toolbar images and object icons
New, more clear and more consistent toolbar, menu and database object images
Improved visual feedback and more consistent look and feel
Increased keyboard usage in data grids for improved data editing
Configuration changes to support longer server aliases, user names etc
Many small changes and features added...
New 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.
New Diagramming Features
Our customers gave us plenty of feedback on the diagramming tools in Database Workbench, we implemented several requests:
Ability to create a physical database directly from the Diagram Editor
A "Diagram Navigator", an overview of the diagram so you can easily move through the diagram
Updating a diagram from the database has become much easier
Easily create a "link table" between two tables for n/n relationships
Ability to print on A3
Ability to create indices and constraints in the diagram Table Editor
Entity Identifiers, Primary or Foreign Key columns clearly marked with an icon
Different editions for different needs
Not everyone needs a complete professional database development tool: we now offer a Basic Edition at a reduced price, with an upgrade path if you happen to need more features later on.
Our even-more-fully-featured-than-before Pro Edition is available at the price you're used to.
You can check the feature matrix to see which edition fits you best.
New Work Space and Tools Features
There's more "work space" features in Database Workbench 5 and it's easier to stay in control with these new 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
MySQL and MariaDB 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 and HTTP Tunnel options. A custom PHP-script is available to complete the HTTP tunnel.
The new embedded SSH client makes it easier to create a secure tunnel to a MySQL 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.
Even More New Tools and Features!
Based on customer suggestions, we've created new tools and features
New Script Runner tool, for large non-interactive script execution
New Data Compare tool, to compare the data in tables and databases
We've added "copy object" functionality to all object editors
Ability to export BLOB values to a folder
Ability to print on A3
Ability to create indices and constraints in the diagram Table Editor
New, faster "server output" window for Script results, with filter for errors

v5.0 [Sep 16, 2014]
New Database System Support:
- Support for MariaDB 10.
- Support for MySQL 5.6 and 5.7.
- Support for Oracle 12.
- Support for SQL Anywhere 16.
- Support for InterBase XE3.
- Support for SQL Server 2012.
- Support for Firebird 3.
New User Interface Features:
- HiDPI aware: tested with scaled fonts and includes a set of large toolbar images and object icons.
- New, more clear and more consistent toolbar, menu and database object images.
- Improved visual feedback and more consistent look and feel.
- Increased keyboard usage in data grids for improved data editing.
- Configuration changes to support longer server aliases, user names etc.
- Many small changes and features added.
New Code Editor Features:
- Several new features in the SQL and Stored Code Editor control: Code Folding, Block Staples, Current Block Highlighting, Differently Colored Data Dictionary Tables, Object Linking.
New Diagramming Features:
- A "Diagram Navigator", an overview of the diagram so you can easily move through the diagram.
- Updating a diagram from the database has become much easier.
- Easily create a "link table" between two tables for n/n relationships.
- Ability to print on A3.
- Ability to create indices and constraints in the diagram Table Editor.
New Work Space and Tools Features:
- 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.
MySQL and MariaDB Tunneling:
- New features and improvements to access 3rd party servers.
Even More New Tools and Features:
- New Script Runner tool, for large non-interactive script execution.
- We've added "copy object" functionality to all object editors.
- Ability to export BLOB values to a folder.
- Ability to print on A3.
- Ability to create indices and constraints in the diagram Table Editor.
- New, faster "server output" window for Script results, with filter for errors.
- Each object editor has a "Privileges" tab to modify object grants.
- The File Compare tool can now be used to compare text on the fly.
- SQL Insight improvements.
- Faster meta data loading.
- Ability to group databases for a server in custom folders.
- Dependency browsing improvements.

v4.1 [Aug 9, 2011]
This release of Database Workbench brings you bugfixes and small enhancements and includes the FREE Lite versions for InterBase, Firebird and MySQL. This release fixes several issues and has usuability improvements to SQL Insight. Version included the heavily improved SQL Insight, it works fully for additional SQL statements: INSERT, UPDATE, DELETE, MERGE and has re-written parsers and context sensitive pop-up lists and works in the View Editor. SQL Insight also includes support for Microsoft SQL Server "table functions", InterBase & Firebird system tables and Oracle "parameter insight" for Type Constructors.
Support for Oracle Types in type attributes. Exception Text Limited to 78 Characters. Procedure Editor Does Not Understand Autonomous Transactions. Export Data Dialog - Select No Columns does not work. Possible issue with unicode display if "use unicode client" is selected. Possible access violation when scrolling to end of result SQL Editor embedded blob editor. Column header (sorting data) in SQL Editor can be clicked while statement is running, resulting in weird issues. Server Output, larger buffer needed & Save Output not working. Misc small user interface fixes and enhancements. Query Prepare takes a lot of time and seems to fetch all rows. ShortString cannot be used in Data Generator. Complex queries can result in "list index out of bounds" during export of data. Issue when creating new types and name replacement in source. DBW4 after opening User Manager no status icons are displayed. SQL Insight errors when selecting items. SQL Insight failure on IN (... value list ...).