Comparison of database tools

From Wikipedia, the free encyclopedia

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

Contents

[edit] 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 Maestro SQL Maestro Group various various EULA / $59-$1899 Yes No No DB2, Firebird, MaxDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL; ODBC Borland Delphi
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

[edit] 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 User Interface Create & Alter wizard Browse Auto Completion Syntax colored
Database Table Procedure Trigger Database Table Procedure Trigger
Aqua Data Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
DbVisualizer TDI ? Yes ? ? Yes Yes Yes Yes Yes Yes
DeZign for Databases desktop Yes Some Yes Yes Yes Some Yes Yes No Yes
DreamCoder desktop ? ? ? ? Yes Yes Yes Yes Yes[1] Yes
EMS SQL Management Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes


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

[edit] 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 CSV CSV, SQL; diagram as JPG, PNG oracle,sybase
DbVisualizer No ? ? Yes CSV,HTML,Excel,XML,SQL,text No
DeZign for Databases No No Yes No SQL; diagram as EMF, BMP, GIF, JPG, PNG No
DreamCoder No No Yes[1] Yes[1] Yes[1] No[1]
EMS SQL Management Studio Yes ? Yes[8] 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[9] 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 Yes Yes clipboard SQL, CSV, XML, HTML; diagram as PNG, SVG No
SQL Edge No ? No No data as CSV or Tab-delimited; diagram as GIF, JPG, PNG or SVG[10] No
SQL Maestro Yes[11] ? ? MS Excel, MS Access, DBF, XML, TXT, CSV SQL, MS Excel/Access/Word, RTF, HTML, PDF, TXT, CSV, DIF file, SYLK, LaTeX, XML, DBF; diagram in XML format Yes
SQL Server Configuration Manager Yes ? ? ? ? No
SQLyog ? ? ? ? ? No
SQuirreL SQL ? Yes ? Yes ? No
SQLPro SQL Client ? ? ? ? ? No
TOAD Some ? Yes Toad for Oracle ERD diagram as BMP, JPG, PNG, XML No
WWW SQL Designer No No No No SQL No

[edit] 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 Some No ?
DbVisualizer ? Yes Some No No
DeZign for Databases No Yes Yes Yes[12] Yes
DreamCoder Yes ? ? ? ?
EMS SQL Management Studio Yes[13] 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[14] No No No No
SQL Developer No Yes Yes No[5] No
SQL Edge Some[15] Yes Yes No[6] No
SQL Maestro Yes Yes Yes Yes No
SQL Server Configuration Manager ? ? ? ? ?
SQLyog Yes[16] Yes[17] ? ? ?
SQuirreL SQL No Yes Yes[18] ? No
TOAD No Yes Yes[19] Yes[20] No
SQLPro SQL Client ? No No No No
WWW SQL Designer No Yes No Some No

[edit] See also

[edit] References

[edit] External links

[edit] 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. ^ SQL Developer 2.3.0 mixes up PostgreSQL indexes as tables
  5. ^ a b SQL Developer 2.3.0 disables the "New" menu item for tables, but tables can be imported from the clipboard, along with data
  6. ^ a b SQL Edge can create and drop tables, edit table data, but cannot alter table structure
  7. ^ 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."
  8. ^ With the Database Comparer application from the Studio suite
  9. ^ Can import SQL via "Reverse Engineer - SQL Script"
  10. ^ SQL Edge - Model Perspective screenshots
  11. ^ Individual table permissions can be applied from the Permissions tab of each table
  12. ^ Via SQL scripts for dropping and creating, which must be executed outside DeZign for Databases
  13. ^ With the SQL Query application from the Studio suite
  14. ^ RazorSQL - SQL Query Builder
  15. ^ SQL query wizard
  16. ^ SQLYog query builder
  17. ^ SQLYog schema designer
  18. ^ Only incremental, by manually going through each table and clicking "Add to graph"
  19. ^ Via Model -> Update Model. In version 3.2.1.12beta, selective reverse engineering may fail to work
  20. ^ Via generated SQL which must be executed outside Toad Modeler