Girish Mahajan (Editor)

Database Workbench

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit
Original author(s)
  
Upscene Productions

License
  
commercial/trial

Operating system
  
Windows

Stable release
  
5.2.6 / November 11, 2016; 2 months ago (2016-11-11)

Type
  
Database design/management/development

Website
  
Database Workbench website

Database Workbench is a software application for development and administration of multiple relational databases using SQL, with interoperationality between different database systems, developed by Upscene Productions.

Contents

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 Workbench", initially modeled after the SQL Navigator tool for Oracle Database by Quest Software. During its early years, InterBase became open source 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 and has been a committee member of the Firebird Foundation.

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 and MySQL was added in 2003; in 2005, support for Oracle Database and NexusDB was added and SQL Anywhere support followed in 2008. Early 2010, a full Unicode version of Database Workbench was released and version 5 of Database Workbench was released in August 2014. 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: Oracle Database, Microsoft SQL Server, SQL Anywhere, Firebird, NexusDB, InterBase, MySQL, MariaDB and PostgreSQL Version 5 of Database Workbench runs on 32-bit or 64 bit Windows platforms. Under Linux, FreeBSD or Mac OS X Database Workbench can operate using Wine.

Features

Database Workbench can be used to view, create and edit tables, indexes, stored procedures 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, 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
  • print database schema, source code, lists of objects or query result sets

    • It includes several productivity features:

  • SQL Insight including "Join Completion"
  • Parameter Insight
  • Code Templates
  • Object Templates
  • Name Templates
  • Two-way Visual Query Builder

    • References

    Database Workbench Wikipedia
    (Text) CC BY-SA