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 ** Administrative Assistant, traditionally known as a Secretary, or also known as an administrative officer, admini ...

of multiple

relational database A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relati ...

s using SQL, 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. InterBase is distinguished from other RDBMSs by its small footprint, close to zero administration requirements, and multi-g ...

, ''"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 multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online ...

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 c ...

. 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 the source code, design documents, or content of the product. The open-source model is a decentralized so ...

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 relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ...

and

MySQL MySQL () is an 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 relational database ...

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 do ...

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

Unicode Unicode, formally The Unicode Standard,The formal version reference is is an information technology standard for the consistent encoding, representation, and handling of text expressed in most of the world's writing systems. The standard, ...

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. A free version with limited functionality, Data Workbench Lite, based on Data Workbench 4 is also available.

Supported databases and environments

Database Workbench supports the following relational databases:

, SQL Anywhere, Firebird,

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

and

PostgreSQL PostgreSQL (, ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the ...

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 CPUs and ALUs are those that are based on processor registers, address buses, or data buses of that size. A ...

application for

Windows Windows is a group of several proprietary graphical operating system families developed and marketed by Microsoft. Each family caters to a certain sector of the computing industry. For example, Windows NT for consumers, Windows Server for se ...

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 32- bit units. Compared to smaller bit widths, 32-bit computers can perform large calculati ...

. Under

Linux Linux ( or ) is a family of open-source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically packaged as a Linux distribution, whi ...

FreeBSD FreeBSD is a free and open-source Unix-like operating system descended from the Berkeley Software Distribution (BSD), which was based on Research Unix. The first version of FreeBSD was released in 1993. In 2005, FreeBSD was the most popular ...

Mac OS X macOS (; previously OS X and originally Mac OS X) is a Unix operating system developed and marketed by Apple Inc. since 2001. It is the primary operating system for Apple's Mac computers. Within the market of desktop and lap ...

Database Workbench can operate using

Wine Wine is an alcoholic drink typically made from Fermentation in winemaking, fermented grapes. Yeast in winemaking, Yeast consumes the sugar in the grapes and converts it to ethanol and carbon dioxide, releasing heat in the process. Different ...

Features

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

stored procedure A stored procedure (also termed 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 data 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 reversible changes to relational database schemas. A schema migration is performed ...

, 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 in 1992 to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems. ...

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.

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