Jump to content

Comparison of database administration tools: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
m →Features - visual design and reverse engineering: No visual tools in SQLPro SQL Editor and SQL client
Added DreamCoder. Improved Toad Modeler.
Line 64: Line 64:
| {{no}}
| {{no}}
| [[MySQL]], [[Oracle Database|Oracle]], [[InterBase]], [[IBM DB2]], [[PostgreSQL]], [[MS SQL Server]], [[Firebird_(database_server)|Firebird]], [[MS Access]], [[Paradox]], [[dBase]], [[Pervasive]], [[Informix]], [[Clipper]], [[Foxpro]], [[Sybase]], [[ElevateDB]], [[NexusDB]], [[DBISAM]]
| [[MySQL]], [[Oracle Database|Oracle]], [[InterBase]], [[IBM DB2]], [[PostgreSQL]], [[MS SQL Server]], [[Firebird_(database_server)|Firebird]], [[MS Access]], [[Paradox]], [[dBase]], [[Pervasive]], [[Informix]], [[Clipper]], [[Foxpro]], [[Sybase]], [[ElevateDB]], [[NexusDB]], [[DBISAM]]
⚫
| {{?}}

|-
! style="text-align: left; background: #ececec;" | [[DreamCoder]]
| [http://www.sqldeveloper.net/products.html DreamCoder for MySQL/Oracle/PostgreSQL]
| 5.1.1 (2008-04-04)
⚫
| {{?}}
| [[Proprietary software|Proprietary]] / $80-$150
⚫
| {{yes}}
⚫
| {{no}}
| {{no}}
| [[MySQL]], [[Oracle Database|Oracle]], [[PostgreSQL]]
| {{?}}
| {{?}}


Line 284: Line 296:
|-
|-
! style="text-align: left; background: #ececec;" | [[TOAD (software)|TOAD]]
! style="text-align: left; background: #ececec;" | [[TOAD (software)|TOAD]]
| [[Quest Software]]
| [http://www.casestudio.com CharonWare], part of [[Quest Software]]
| {{?}}
| 3.1
| [http://modeling.inside.quest.com/ann.jspa?annID=150 3.2.1.12 beta], 2008-10-29
⚫
| {{?}}
| [[Proprietary software|Proprietary]]
| [[Proprietary software|Proprietary]]
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| [[Oracle Database|Oracle]], [[MS SQL Server]], [[DB2]], [[MySQL]]
| [[DB2]], [[MS SQL Server]], [[MySQL]], [[Oracle Database|Oracle]], [[PostgreSQL]], [[Sybase]]
| {{?}}
| {{?}}


Line 387: Line 399:
| {{No}}
| {{No}}
| {{Yes}}
| {{Yes}}

|-
! style="text-align: left; background: #ececec;" | [[DreamCoder]]
| {{no}}
| {{?}}
| {{?}}
| {{?}}
| {{?}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{yes}}<ref name="DreamCoder features">[http://www.sqldeveloper.net/postgresql-manager-developer/dreamcoder-for-postgresql.html DreamCoder for PostgreSQL feature list]</ref>
| {{yes}}


|-
|-
Line 632: Line 658:
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{some}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{some}}
⚫
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
Line 645: Line 671:
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{some}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
Line 690: Line 716:
| [[Comma-separated values|CSV]],[[HTML]],[[Microsoft Excel|Excel]],[[XML]],[[SQL]],[[Text file|text]]
| [[Comma-separated values|CSV]],[[HTML]],[[Microsoft Excel|Excel]],[[XML]],[[SQL]],[[Text file|text]]
| {{no}}
| {{no}}

|-
|-
! style="text-align: left; background: #ececec;" |[[DeZign for Databases]]
! style="text-align: left; background: #ececec;" |[[DeZign for Databases]]
Line 698: Line 725:
| [[SQL]]
| [[SQL]]
| {{no}}
| {{no}}

|-
! style="text-align: left; background: #ececec;" |[[DreamCoder]]
| {{No}}
| {{No}}
| {{Yes}}<ref name="DreamCoder features" />
| {{Yes}}<ref name="DreamCoder features" />
| {{yes}}<ref name="DreamCoder features" />
| {{no}}<ref name="DreamCoder features" />


|-
|-
Line 853: Line 889:
|-
|-
! style="text-align: left; background: #ececec;" | [[TOAD (software)|TOAD]]
! style="text-align: left; background: #ececec;" | [[TOAD (software)|TOAD]]
| {{some}}
| {{?}}
| {{?}}
| {{?}}
| {{yes}}
⚫
| {{?}}
| {{?}}
| {{?}}
| {{?}}
| {{?}}
Line 904: Line 940:
| {{no}}
| {{no}}
| {{no}}
| {{no}}

|-
|-
! style="text-align: left; background: #ececec;" |[[DeZign for Databases]]
! style="text-align: left; background: #ececec;" |[[DeZign for Databases]]
| {{Yes}}
| {{?}}
| {{?}}
| {{?}}
| {{?}}

|-
! style="text-align: left; background: #ececec;" |[[DreamCoder]]
| {{Yes}}
| {{Yes}}
| {{?}}
| {{?}}
Line 1,040: Line 1,085:
|-
|-
! style="text-align: left; background: #ececec;" | [[TOAD (software)|TOAD]]
! style="text-align: left; background: #ececec;" | [[TOAD (software)|TOAD]]
| {{?}}
| {{no}}
| {{?}}
| {{yes}}
| {{yes}}<ref>Via Model -> Update Model. In version 3.2.1.12beta, selective reverse engineering may fail to work</ref>
⚫
| {{?}}
| {{?}}
| {{yes}}
| {{?}}
| {{no}}
|-
|-
! style="text-align: left; background: #ececec;" | [[SQLPro SQL Client]]
! style="text-align: left; background: #ececec;" | [[SQLPro SQL Client]]

Revision as of 05:54, 30 May 2008

The following tables compare general and technical information for a number of available database administrator tools. Please see the individual products' articles for further information. This article is neither all-inclusive nor necessarily up-to-date.

General

Creator Latest stable release Latest testing release License / Price (USD) Runs on Windows Runs on Mac OS X Runs on Linux Database Programming language
Aqua Data Studio AquaFold, Inc. 6.5.9 (2008-03-22) ? Proprietary / $399 Yes Yes Yes JDBC Java
DBTyp.NET BYPsoft 2007 2008 Proprietary / $70 Yes No No MySQL, Oracle, MS SQL Server C#
DbVisualizer Minq Software AB 6.0.9 (2008-03-17) ? Proprietary / $149 Yes Yes Yes JDBC Java
Dezign for Database Datanamic 5.1.1 (2008-04-04) ? Proprietary / $245 Yes No No MySQL, Oracle, InterBase, IBM DB2, PostgreSQL, MS SQL Server, Firebird, MS Access, Paradox, dBase, Pervasive, Informix, Clipper, Foxpro, Sybase, ElevateDB, NexusDB, DBISAM ?
DreamCoder DreamCoder for MySQL/Oracle/PostgreSQL 5.1.1 (2008-04-04) ? Proprietary / $80-$150 Yes No No MySQL, Oracle, PostgreSQL ?
EMS SQL Management Studio SQLManager.net 1.1.01 (2007-12-13) ? Proprietary / $468-$518 Yes No No MySQL, MS SQL Server, PostgreSQL, InterBase/Firebird, Oracle ?
jfacedbc2 ? 2.2.1 (2004-01-14) ? GPL Yes Yes Yes JDBC Java
Happy Fish Automatisering Polderij 4.0.1 (2008-05-24) ? [1] / €109 Yes No No ODBC Borland Delphi
MicroOLAP Database Designer MicrOLAP 1.2.3 (2008-02-01) 1.2.4-beta (2008-05-09) Proprietary Yes No No MySQL, PostgreSQL ?
pgAdmin III pgAdmin Development Team 1.8.3 (2008-03-27) ? Artistic License Yes Yes Yes PostgreSQL C++
phpMSAdmin Adam Voigt 0.18 (2006-07-23) ? GPL Yes Yes Yes MS SQL Server php
phpMyAdmin ? 2.11.5.1 (2008-03-29) ? GPL Yes Yes Yes MySQL php
phpPgAdmin ? 4.1.3 (2007-07-10) ? GPL Yes Yes Yes PostgreSQL php
QuantumDB ? 3.0.7 (2007-10-20) ? GPL Yes Yes Yes JDBC, Eclipse plugin Java
RazorSQL Richardson Software 4.2.2 (2008-04-01) ? Proprietary / $49.95 Yes Yes Yes JDBC Java
SQL Developer Jan Borchers 2.3.0 ? Proprietary / $99 Yes Yes Yes JDBC Java
SQL Edge Bay Breeze Software, Inc. 3.3 ? Proprietary / $19 Yes Yes Yes JDBC; Oracle, DB2, Microsoft SQL Server, Sybase, MySQL, PostgreSQL, MaxDB Java
SQL Manager EMS Database Management Solutions, Inc 1.1.0.1 (2008-04-02) ? $ Yes No No MySQL, Oracle, MS SQL Server, Interbase, Firebird, DB2 ?
SQL Maestro SQL Maestro Group various various EULA / $59-$1899 Yes No No DB2, Firebird, MaxDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL; ODBC ?
SQL Server Configuration Manager Microsoft ? ? Proprietary / $ Yes No No MS SQL Server ?
SQLyog Webyog Softworks Pvt. Ltd. 6.5 ? GPLv2 Yes No No MySQL C++
SQuirreL SQL ? 2.6.5a (2008-03-08) ? GPL Yes Yes Yes JDBC Java
SQLPro SQL Client Vive 1.4 (2008-02-04) ? Proprietary / $29.95 Yes No No MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite C++
TOAD CharonWare, part of Quest Software 3.1 3.2.1.12 beta, 2008-10-29 Proprietary Yes No No DB2, MS SQL Server, MySQL, Oracle, PostgreSQL, Sybase ?
WWW SQL Designer Ondřej Žára 2.0.1 (2008-04-01) ? GPL Yes Yes Yes MySQL JavaScript
Creator Latest stable release Latest testing release Licence Runs on Windows Runs on Mac OS X Runs on Linux Database Programming language

Features

Legend

  • Create/alter table:
    • Yes - can create table, alter its definition and data, and add new rows
    • Some - can only create/alter table definition, not data
  • Browse table:
    • Yes - can browse table definition and data
    • Some - can only browse table definition
Tools web interface Create & Alter wizard Browse Auto Completion Syntax colored
Database Table Procedure Trigger Database Table Procedure Trigger
Aqua Data Studio No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
DbVisualizer No ? Yes ? ? Yes Yes Yes Yes Yes Yes
DeZign for Databases No Yes Yes Yes Yes Yes Yes Yes Yes No Yes
DreamCoder No ? ? ? ? Yes Yes Yes Yes Yes[1] Yes
EMS SQL Management Studio No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes


Happy Fish No Some[2] Some ? Yes Some[3] Some ? Yes No Yes
jfacedbc No ? ? ? ? ? ? ? ? ? ?
MicroOLAP Database Designer No Yes Some Yes Yes Yes Some Yes Yes No Yes
pgAdmin III No Yes Yes Yes Yes Yes Yes Yes Yes ? Yes
phpMSAdmin Yes ? ? ? ? ? ? ? ? ? ?
phpMyAdmin Yes Yes Yes No No Yes Yes No No No No
phpPgAdmin Yes ? ? ? ? ? ? ? ? ? ?
QuantumDB No ? ? ? ? Yes Yes ? ? No Yes
RazorSQL No ? ? ? ? ? ? ? ? ? ?
SQL Developer No ? ? ? ? ? ? ? ? ? ?
SQL Edge No Yes Some[4] No No Yes Yes Yes[5] Yes[5] No Yes
SQL Manager No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
SQL Maestro No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
SQL Server Configuration Manager No Yes Yes Yes Yes Yes Yes Yes Yes No Yes
SQLyog No ? ? ? ? ? ? ? ? ? ?
SQuirreL SQL No ? ? ? ? ? ? ? ? ? ?
SQLPro SQL Client No No No No No Yes Yes Yes Yes No Yes
TOAD No Yes Some Yes Yes Yes Some Yes Yes No Yes
WWW SQL Designer Yes No Some No No No No No No No No

Features (continued)

Legend:

  • User manager:
    • Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
    • Some - simple user manager with support for database and schema permissions
    • No - no user manager, or read-only user manager
user manager Plugin Compare Import Export Debugger
Aqua Data Studio Yes ? Yes Yes Yes oracle,sybase
DbVisualizer No ? ? Yes CSV,HTML,Excel,XML,SQL,text No
DeZign for Databases No No Yes Yes SQL No
DreamCoder No No Yes[1] Yes[1] Yes[1] No[1]
EMS SQL Management Studio Yes ? Yes[6] MS Excel/Access/Word, TXT, CSV, DBF, HTML, XML Datapacket, XML Generic, ODF Spreadsheets, ODF Text Imported formats plus RTF, PDF, LaTeX, DIF file, SYLK ?
Happy Fish No ? Yes ? SQL; diagram as XML, BMP, JPG, WMF No
jfacedbc ? ? ? ? ? No
MicroOLAP Database Designer No ? No Some[7] SQL; HTML report; diagram as BMP, EMF, GIF, JPG, PNG No
pgAdmin III Some ? ? ? CSV,text No
phpMSAdmin ? ? ? ? ? No
phpMyAdmin Yes ? ? ? CSV,LaTeX,Excel,XML,SQL No
phpPgAdmin ? ? ? ? ? No
QuantumDB ? ? ? ? CSV,XML No
RazorSQL ? ? ? ? ? No
SQL Developer ? ? ? ? ? No
SQL Edge No ? No No data as CSV or Tab-delimited; diagram as GIF, JPG, PNG or SVG[8] No
SQL Maestro Some ? ? ? SQL; diagram in XML format Yes
SQL Manager Yes ? ? ? ? Yes
SQL Server Configuration Manager Yes ? ? ? ? No
SQLyog ? ? ? ? ? No
SQuirreL SQL ? ? ? ? ? No
SQLPro SQL Client ? ? ? ? ? No
TOAD Some ? Yes ? ? No
WWW SQL Designer No No No No SQL No

Features - visual design and reverse engineering

Legend:

  • Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing
  • Reverse engineering - the ability to produce an ER diagram from a database, complete with foreign key relationships
    • Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
    • Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't "refresh" the diagram to match the database)
  • Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer
    • Yes - can update user-selected entities
    • Some - can only update the entire database at once
Visual query builder Visual schema/model/E-R diagram design Reverse engineering Forward engineering ER diagram groupboxes
Aqua Data Studio Yes Yes Yes No ?
DbVisualizer ? Yes Some No No
DeZign for Databases Yes ? ? ? ?
DreamCoder Yes ? ? ? ?
EMS SQL Management Studio Yes[9] No No No No
Hapy Fish ? Yes Yes Yes Yes
jfacedbc ? ? ? ? ?
MicroOLAP Database Designer No Yes Some Yes ?
pgAdmin III No No No No No
phpMSAdmin No ? ? ? ?
phpMyAdmin No No No No No
phpPgAdmin No No No No No
QuantumDB No ? ? ? ?
RazorSQL Yes[10] No No No No
SQL Developer ? ? ? ? ?
SQL Edge Some[11] Yes Yes No[4] No
SQL Maestro Yes Yes Yes Yes No
SQL Manager Yes ? ? ? ?
SQL Server Configuration Manager ? ? ? ? ?
SQLyog Yes[12] Yes[13] ? ? ?
SQuirreL SQL ? ? ? ? ?
TOAD No Yes Yes[14] Yes No
SQLPro SQL Client ? No No No No
WWW SQL Designer No Yes No Some No

See also

References

Notes

  1. ^ a b c d e DreamCoder for PostgreSQL feature list
  2. ^ Via reverse and forward engineering; i.e. cannot set options such as the database encoding
  3. ^ Via reverse engineering
  4. ^ a b SQL Edge can create and drop tables, edit table data, but cannot alter table structure
  5. ^ a b "For Oracle, DB2, Microsoft SQL Server, Sybase, MySQL and PostgreSQL databases, script information will also be displayed for views, synonyms, sequences, stored procedures, triggers and packages based on whether the database supports these objects."
  6. ^ With the Database Comparer application from the Studio suite
  7. ^ Can import SQL via "Reverse Engineer - SQL Script"
  8. ^ SQL Edge - Model Perspective screenshots
  9. ^ With the SQL Query application from the Studio suite
  10. ^ RazorSQL - SQL Query Builder
  11. ^ SQL query wizard
  12. ^ SQLYog query builder
  13. ^ SQLYog schema designer
  14. ^ Via Model -> Update Model. In version 3.2.1.12beta, selective reverse engineering may fail to work
Retrieved from "https://en.wikipedia.org/w/index.php?title=Comparison_of_database_administration_tools&oldid=215905670"