Database Workbench is a software application for development and

administration Administration may refer to: Management of organizations * Management, the act of directing people towards accomplishing a goal: the process of dealing with or controlling things or people. ** Administrative assistant, traditionally known as a se ...

of multiple

relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...

s using

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

, with interoperationality between different database systems, developed by Upscene Productions. Because Databases Workbench supports multiple database systems, it can provide software developers with the same interface and development environment for these otherwise different database systems and also includes cross database tools.

Development

Database Workbench started out as a developer tool specifically for

InterBase InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. It runs on the operating systems Microsoft Windows, macOS, Linux, Oracle Solaris, Solaris, Android (operating system), Andr ...

, ''"InterBase Workbench"'', initially modeled after the SQL Navigator tool for

Oracle Database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for ru ...

Quest Software Quest Software, also known as Quest, is a privately held software company headquartered in Aliso Viejo, California, United States. Quest provides cloud management, software as a service, security, workforce mobility, and backup & recovery. The co ...

. During its early years, InterBase became

open-source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use and view the source code, design documents, or content of the product. The open source model is a decentrali ...

for a short while, and soon after Firebird was created as a fork from the InterBase code base. The main developer of Database Workbench, Martijn Tonies, was closely involved in the early development of Firebird, has been a committee member of the Firebird Foundation and continues to be a Foundation member and sponsor. Database Workbench continued to support both database systems, initially through a separate ''"Firebird Workbench"'' release. Not long after, the program became interoperational between the different database systems and this initial support for multiple database systems led to the renaming of the product to its current title ''"Database Workbench"'' in 2003. It also opened the path to the inclusion of support for more database systems: support for

Microsoft SQL Server Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced "sequel"). As a database server, it is a software product with the primary function of ...

and

MySQL MySQL () is an Open-source software, open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A rel ...

was added in 2003; in 2005, support for

and

NexusDB NexusDB is a relational commercial database engine for the Delphi, C++ Builder and .NET programming languages created by NexusDB Pty Ltd. It was developed as a successor to the TurboPower FlashFiler system for Delphi (still available for free dow ...

was added and SQL Anywhere support followed in 2008. Early 2010, a full

Unicode Unicode or ''The Unicode Standard'' or TUS is a character encoding standard maintained by the Unicode Consortium designed to support the use of text in all of the world's writing systems that can be digitized. Version 16.0 defines 154,998 Char ...

version of Database Workbench was released and version 5 of Database Workbench was released in August 2014. In December 2021, Database Workbench 6 was released with a revamped user interface including a more consistent look and feel and the multi-threaded loading of database metadata. This version introduced the Enterprise Edition with its TeamServer component. In 2024,

SQLite SQLite ( "S-Q-L-ite", "sequel-ite") is a free and open-source relational database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it ...

support was added. A free version for personal use with limited functionality, Database Workbench Lite, is available for MySQL and Firebird.

Supported databases and environments

The current available version of Database Workbench supports the following relational databases:

, Firebird,

MariaDB MariaDB is a community-developed, commercially supported Fork (software development), fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Developm ...

and

PostgreSQL PostgreSQL ( ) also known as Postgres, is a free and open-source software, free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transaction processing, transactions ...

Version 6 of Database Workbench is a

64-bit In computer architecture, 64-bit integers, memory addresses, or other data units are those that are 64 bits wide. Also, 64-bit central processing units (CPU) and arithmetic logic units (ALU) are those that are based on processor registers, a ...

application for

Windows Windows is a Product lining, product line of Proprietary software, proprietary graphical user interface, graphical operating systems developed and marketed by Microsoft. It is grouped into families and subfamilies that cater to particular sec ...

platforms, previous versions were

32-bit In computer architecture, 32-bit computing refers to computer systems with a processor, memory, and other major system components that operate on data in a maximum of 32- bit units. Compared to smaller bit widths, 32-bit computers can perform la ...

. Under

Linux Linux ( ) is a family of open source Unix-like operating systems based on the Linux kernel, an kernel (operating system), operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically package manager, pac ...

FreeBSD FreeBSD is a free-software Unix-like operating system descended from the Berkeley Software Distribution (BSD). The first version was released in 1993 developed from 386BSD, one of the first fully functional and free Unix clones on affordable ...

Mac OS X macOS, previously OS X and originally Mac OS X, is a Unix, Unix-based operating system developed and marketed by Apple Inc., Apple since 2001. It is the current operating system for Apple's Mac (computer), Mac computers. With ...

Database Workbench can operate using

Wine Wine is an alcoholic drink made from Fermentation in winemaking, fermented fruit. Yeast in winemaking, Yeast consumes the sugar in the fruit and converts it to ethanol and carbon dioxide, releasing heat in the process. Wine is most often made f ...

Features

Database Workbench can be used to view, create and edit tables,

indexes Index (: indexes or indices) may refer to: Arts, entertainment, and media Fictional entities * Index (A Certain Magical Index), Index (''A Certain Magical Index''), a character in the light novel series ''A Certain Magical Index'' * The Index, a ...

stored procedure A stored procedure (also termed prc, proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database d ...

s and other database meta data objects. It also supports: * visual database design/diagramming, both conceptual and physical, including reverse engineering * testing SQL queries and viewing query plans * step-by-step debugging of stored routines * generating test data * transferring data between database systems (DataPump) * import and export of data * database schema compare and change script creation * database

schema migration In software engineering, a schema migration (also database migration, database change management) refers to the management of version-controlled, incremental and sometimes reversible changes to relational database schemas. A schema migration i ...

, also from one database system to another * visual privilege management * dependency browsing * open ODBC or ADO data sources and MS Access databases * manage security items like users, groups and roles * create custom reports based on database queries * print database schema, source code, lists of objects or query result sets * BLOB (binary large object) editor with support for images, HTML,

PDF Portable document format (PDF), standardized as ISO 32000, is a file format developed by Adobe Inc., Adobe in 1992 to present documents, including text formatting and images, in a manner independent of application software, computer hardware, ...

and RTF, DOC and DOCX documents It includes several productivity features: * Favorite Databases for easy access to your most used databases * SQL Insight including "Join Completion" * Parameter Insight * Code Templates * Object Templates * Name Templates * Two-way Visual Query Builder

History

* Initially created by as InterBase Workbench * Version 1: 2001 * Version 1.4: 2002, Firebird Workbench to only work with Firebird. InterBase Workbench works with both Firebird and InterBase. * Version 2: 2003, renamed Database Workbench with modular approach for supported database systems, Microsoft SQL Server, MySQL, Oracle and NexusDB support added. * Version 3: 2007, SQL Anywhere support added. * Version 4: 2010, fully Unicode enabled. * Version 5: 2014, High DPI aware and support for PostgreSQL added. * Version 6: 2021, Enterprise Edition added, a special multi-user version with central repository of servers, databases and workspaces and a database Version Control System. SQL Anywhere support removed. * Version 6.4: 2024, SQLite support added.

References

External links

Database Workbench website
{{MySQL Database administration tools Data modeling tools MySQL Firebird (database server) Interbase Oracle database tools Microsoft database software MariaDB PL/SQL_editors PostgreSQL SQLite