Database Workbench Pro v5.7.4.342
Database Workbench Pro v5.7.4.342
Database Workbench Pro is a comprehensive software solution that offers a single environment for developing multiple types of database engines. The software allows you to connect to one or multiple database servers at the same time, then create structures, insert tables and fill in the fields with the required data.
User-friendly and powerful set of functions for working with multiple databases
Database Workbench Pro is an intuitive working space that offers a consistent interface and supports editing several types of databases. It allows you to easily transpose information or structure across different database systems or versions. In other words, it allows you to work with a single, user-friendly interface and manipulate the databases regardless of their provenance or version.
The software offers full support for reading and editing Unicode data and even metadata. Moreover, it enables you to import/export Unicode data, text files or transfer pieces of information between database systems. You can easily modify a text or script, while viewing it as original source, as HEX code, OLE code or HTML.
Advanced SQL and script editor
Database Workbench Pro features a multitude of tools for script and database editing, which enable you to configure your working space. Aside from the specific SQL and script editors, you can also modify schemas, tables, storage procedure, functions, triggers, Java source, domains, even libraries. Additionally, you can edit the user permissions to access the database or create login policies.
The software also offers specialized diagram designer, database comparing tools, migration assistants, data pump, ADO/ODBC explorers and support for opening MS Access files. Moreover, when connecting to a database server, or �registering’ to one, the software provides step-by-step guidance through a wizard.
Reliable tool for creating and editing databases
Database Workbench Pro is easy to work with and contains numerous tools for aiding you in creating and configuring databases. Aside from the editors and transfer assistants, the software supports multi-level clipboard, allows you to view catalogs, offers several guidance wizards and allows you to compare databases/texts.
Database Workbench what's new in version 5.7
New Database System Support
Database Workbench 5 and 5.7 offer support for the latest versions of database systems and offers new support for MariaDB & PostgreSQL.
Support for MySQL 8
Support for PostgreSQL 12
Support for InterBase 2017
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.
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, 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.
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
Even More New Tools and Features!
Based on customer suggestions, we've created new tools and features
Favorites, connect to your favorite databases without expanding server nodes
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
Ability to export result sets to UPDATE or DELETE statements in addition to INSERT
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
Only for V.I.P
Warning! You are not allowed to view this text.