Jump to content

Database Workbench

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 83.128.83.172 (talk) at 13:17, 30 April 2014 (article created so the tool can be added to several other articles at Wikipedia (eg "http://en.wikipedia.org/wiki/Comparison_of_database_tools")). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)
Database Workbench
Original author(s)Upscene Productions
Stable release
4.4.6 [1] / April 29, 2014; 11 years ago (2014-04-29)
Operating systemWindows
TypeDatabase design/management/development
Licensecommercial/freeware
WebsiteDatabase Workbench website

Database Workbench (DBW) is a software application from Upscene Productions used for development and administration of various relational databases using SQL.[2]

Databases Workbench aims to provide the software developer with a consistent user interface and development environment for multiple database systems including cross database tools.

History

Database Workbench started out as a developer tool specifically for InterBase, as "InterBase Workbench", created as a hobby project by Martijn Tonies in 2001, modeled after the SQL Navigator tool for Oracle Database by Quest Software. During it's early years, InterBase suddenly became open source (for a short while) and soon after, Firebird was created as a fork from the InterBase code base. [3] This resulted in an "InterBase Workbench" and "Firebird Workbench" during the series of the version 1 releases of the software.

Due to support for both InterBase and Firebird, version 2 was renamed to "Database Workbench" in 2003.[4] This opened the path to supporting more database systems and support for Microsoft SQL Server and MySQL was added in 2003.[5][6]

In 2005, Database Workbench added support for Oracle Database and NexusDB, SQL Anywhere support followed in 2008. Early 2010 a full Unicode version of Database Workbench was released.[7]

Upscene Productions makes Database Workbench available in both commercial and trial "Pro Edition", as well as a freeware "Lite Edition".[8]

Supported databases and environments

Database Workbench supports the following relational databases: Oracle Database, Microsoft SQL Server, SQL Anywhere, Firebird, NexusDB, InterBase, and MySQL. Database Workbench 4 runs on 32-bit or 64 bit Windows platforms, from XP and up. Linux and FreeBSD users are successfully using Database Workbench using Wine.[9]

Features

Database Workbench be used to view, create and edit tables, indexes, stored procedures and other database meta data objects.

It also supports:

  • visual database design/diagramming
  • step-by-step debugging stored routines
  • testing SQL queries and viewing query plans
  • generating test data
  • transferring data between database systems (DataPump)
  • import and export of data
  • database schema compare and migration
  • visual privilege management

It includes several productivity features:[10]

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

References

  1. ^ "Database Workbench 4.4.6 released".
  2. ^ Official Database Workbench site
  3. ^ http://en.wikipedia.org/wiki/Interbase#Open_source
  4. ^ Database Workbench 2.0 released
  5. ^ Microsoft SQL Server support added
  6. ^ MySQL support added
  7. ^ Database Workbench 4.0 Unicode release
  8. ^ Feature Matrix
  9. ^ Running Database Workbench under Wine
  10. ^ Productivity Tools
Retrieved from "https://en.wikipedia.org/w/index.php?title=Database_Workbench&oldid=606472139"