Database Workbench
| Company type | Software |
|---|---|
| Industry | Database management software |
| Founded | 2001 |
| Founder | Martijn Tonies |
Area served | Worldwide |
| Products | Database Workbench (including Lite and Enterprise editions) |
| Website | www |
Database Workbench is a software solution designed for the development and management of various relational database systems through SQL, facilitating compatibility across diverse database platforms. This application is produced by Upscene Productions.
By supporting a range of database engines, Database Workbench offers developers a consistent interface and workspace, incorporating tools that function across different databases.[1][2]
Development
Originally known as InterBase Workbench, this tool was created as a developer utility inspired by the SQL Navigator for Oracle Database from Quest Software.[3] During its early phase, InterBase briefly transitioned to open-source status, which led to the emergence of Firebird as a fork. The lead developer, Martijn Tonies,[4] played a significant role in Firebird’s initial development and continues to be an active member and sponsor of the Foundation.[5]
At first, separate versions supported InterBase and Firebird, but since 2003 the product has evolved under the name Database Workbench to accommodate multiple database platforms. That year also saw the addition of Microsoft SQL Server and MySQL support; in 2005, compatibility extended to Oracle Database and NexusDB; and in 2008 SQL Anywhere was incorporated. A comprehensive Unicode edition was introduced in early 2010, with version 5 released in August 2014.[6] The launch of Database Workbench 6 in December 2021 featured an updated user interface with multi-threaded metadata processing and debuted the Enterprise Edition including the TeamServer module. In 2024, support for SQLite was incorporated.[7]
For users of MySQL and Firebird, a free version with limited capabilities called Database Workbench Lite is offered.[8]
Supported databases and environments
Database Workbench offers compatibility with leading relational database systems such as Oracle Database, Microsoft SQL Server, Firebird, NexusDB, InterBase, MySQL, MariaDB, SQLite, and PostgreSQL. The sixth version is designed as a 64-bit program for Windows, while previous editions were built as 32-bit applications. On platforms like Linux, FreeBSD, and Mac OS X, it runs through the use of Wine.
Features
This software facilitates the viewing, creation, and modification of tables, indexes, stored procedures, and various other database metadata components. Its prominent functionalities encompass:
- Visual database modeling and diagramming for both conceptual and physical designs, including reverse engineering capabilities
- Testing of SQL queries accompanied by query plan evaluation
- Stepwise debugging support for stored routines
- Generation of sample test data
- Cross-platform data migration via DataPump
- Importing and exporting data efficiently
- Schema comparison with automated generation of change scripts
- Migration of database schemas between different database platforms
- Visual tools for managing privileges and exploring dependencies
- Compatibility with ODBC, ADO data sources, and Microsoft Access databases
- User, group, and role security administration
- Creation of custom reports derived from queries
- Printing options for schema definitions, source code, object lists, or query outputs
- BLOB editor capable of handling images, HTML, PDF, RTF, DOC, and DOCX file formats
Enhancements aimed at boosting productivity include:
- Quick access through Favorite Databases
- SQL Insight featuring "Join Completion"
- Parameter Insight functionality
- Templates for code snippets, objects, and names
- Bidirectional Visual Query Builder
History
- Initially released as InterBase Workbench
- Version 1: launched in 2001
- Version 1.4: released in 2002; introduced Firebird Workbench dedicated to Firebird databases while InterBase Workbench supported both Firebird and InterBase systems
- Version 2: came out in 2003; renamed to Database Workbench with modular integration for Microsoft SQL Server, MySQL, Oracle, and NexusDB
- Version 3: introduced in 2007 with added support for SQL Anywhere
- Version 4: rolled out in 2010 featuring comprehensive Unicode support
- Version 5: launched in 2014; incorporated High DPI awareness along with PostgreSQL compatibility
- Version 6: released in 2021; Enterprise Edition introduced multi-user functionality, a centralized repository for servers/databases/workspaces, and a database Version Control System; discontinued support for SQL Anywhere
- Version 6.4: issued in 2024; included SQLite support
External links
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).
- ↑ Lua error in Module:Citation/CS1/Configuration at line 2123: attempt to index field '?' (a nil value).