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 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
Altova DatabaseSpy Altova v2008r2sp2 (2008-09-03) ? Proprietary / $149 with a free 30 day trial version available Yes No No MS SQL Server, IBM DB2, Oracle, Sybase, MySQL, MS Access, any ODBC, any ADO C++
Aqua Data Studio AquaFold, Inc. 7.0.7 (2008-10-30) ? Proprietary / $399 Yes Yes Yes JDBC Java
ACDB Electronic Experience 1.0.7 (2008-03-01) ? Proprietary / €90 pro or free Yes Yes Yes MySQL, Oracle Java
DBTyp.NET BYPsoft 2007 2008 Proprietary / $70 Yes No No MySQL, Oracle, MS SQL Server C#
CompareData Zidsoft 2008 2008 Proprietary / $395 Yes No No ODBC C++
dbForge Studio for MySQL Devart 3.00 (2008-08-01) 3.00 (2008-08-01) Proprietary / $49.95 - $199.95 Yes No No MySQL C#
DbSchema Wise Coders 5.1.2 (2008-08-13) ? Proprietary / $129 Yes Yes Yes JDBC Java
DbVisualizer Minq Software AB 6.0.13 (2008-08-19) ? 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 DB2, MySQL, MS SQL Server, PostgreSQL, InterBase/Firebird, Oracle ?
Epictetus Antilogic Software ? 0.3.2 (2008-10-02) Proprietary / Free Yes Yes Yes Oracle, MS SQL Server/Sybase, MySQL, PostgreSQL, InterBase/Firebird, H2, HSQLDB Java
Happy Fish Automatisering Polderij 4.0.1 (2008-05-24) ? [1] / €109 Yes No No ODBC Borland Delphi
jfacedbc2 ? 2.2.1 (2004-01-14) ? GPL Yes Yes Yes JDBC Java
MicroOLAP Database Designer MicrOLAP 1.2.3 (2008-02-01) 1.2.4-beta (2008-05-09) Proprietary Yes No No MySQL, PostgreSQL ?
ModelRight ModelRight 3.0 3.5 Proprietary software/Free Community Edition for MySQL & ODBC Yes No No Oracle, MS SQL Server, MySQL, ODBC ?
Navicat Navicat 8.1.2 (2008-09-01) 8.1.3-beta (2008-09-02) Proprietary Yes Yes Yes MySQL, PostgreSQL, Oracle database ?
Oracle SQL Developer [Oracle Corporation] 1.5.1 (2008-06-09)  ? Proprietary / free Yes Yes Yes Oracle Database, Microsoft Access, MySQL, Sybase Java
OraDeveloper Studio Devart 2.55 (2007-11-28) ? Proprietary / $99.95 Yes No No Oracle C#
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 phpMyAdmin Development Team 3.0.1.1 (2008-10-30) ? 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 CodeGear Delphi
Microsoft SQL Server Management Studio 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 Quest Software 9.7 (2008-09-17) Betas Proprietary / Pricing Yes No No DB2, MS SQL Server, MySQL, Oracle, Sybase and ODBC CodeGear Delphi
Toad Data Modeler Quest Software 3.2 (2008-09-17) Betas Proprietary / Pricing Yes No No DB2, MS Access, MS SQL Server, MySQL, Oracle, Sybase, and PostgreSQL CodeGear Delphi
WWW SQL Designer Ondřej Žára 2.0.1 (2008-04-01) ? GPL Yes Yes Yes MySQL JavaScript
MySql Lite Administrator Vladimir Carrer ? 0.8 (2008-06-11) GNU Yes Yes Yes MySQL php

[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
Altova DatabaseSpy desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Aqua Data Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
ACDB desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
dbForge Studio for MySQL TDI Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
DbSchema desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
DbVisualizer desktop Yes Yes Yes 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
Epictetus desktop Yes Yes No No Yes Yes Some Some No 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
ModelRight desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes
Oracle SQL Developer desktop No Yes Yes Yes Yes Yes Yes Yes No Yes
OraDeveloper Studio TDI Yes Yes Yes Yes Yes Yes Yes Yes Yes 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
Microsoft SQL Server Management Studio 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 Yes Yes Yes Yes Yes Yes Yes Yes Yes
Toad Data Modeler desktop Yes Yes Yes Yes Some Some Some Some No Yes
WWW SQL Designer Browser-based No Some No No No No No No No No
MySql Lite Administrator Browser-based No No No No Yes Yes 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 Source control
Altova DatabaseSpy No No No CSV XML, XML Structure, CSV, HTML, MS Excel No ?
Aqua Data Studio Yes ? Yes CSV CSV, SQL; diagram as JPG, PNG Oracle, Sybase ?
ACDB Yes ? No SQL script SQL script Oracle, MySQL ?
dbForge Studio for MySQL Yes No Yes No CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML Yes ?
DbSchema No ? Yes Yes SQL script,CSV,HTML,XML,Diagram as image No ?
DbVisualizer No Some No Yes CSV,HTML,Excel,XML,SQL,text,Diagram in PNG, JPG 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 ? ?
Epictetus No Yes No SQL SQL No ?
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 ?
ModelRight Some Yes Yes Yes - from supported databases using native interfaces, or from any ODBC source SQL; XML; DTD; Diagram as BMP, JPG No ?
Oracle SQL Developer Yes ? ? Yes Yes Yes ?
OraDeveloper Studio Yes No Yes No CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML Yes ?
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 ?
Microsoft SQL Server Management Studio 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 SVN, CVS, TFS, VSS
Toad Data Modeler No ? Yes Toad for Oracle ERD, ERWin 7.1(XML) via plugin SQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPG, PNG No ?
WWW SQL Designer No No No No SQL No ?
MySql Lite Administrator No No No No No 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
Altova DatabaseSpy Yes Yes Yes Yes ?
Aqua Data Studio Yes Yes Some No ?
ACDB No Yes Yes Yes Yes
DbSchema Yes Yes Yes Yes Yes
DbVisualizer Yes Yes Some No No
DeZign for Databases No Yes Yes Yes[12] Yes
dbForge Studio for MySQL Yes No No No No
DreamCoder Yes ? ? ? ?
EMS SQL Management Studio Yes[13] Yes Yes No No
Happy Fish ? Yes Yes Yes Yes
jfacedbc ? ? ? ? ?
MicroOLAP Database Designer No Yes Some Yes ?
ModelRight No Yes Yes Yes Yes
Oracle SQL Developer No No No No No
OraDeveloper Studio Yes No No No No
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
Microsoft SQL Server Management Studio ? ? ? ? ?
SQLyog Yes[16] Yes[17] ? ? ?
SQuirreL SQL No Yes Yes[18] ? No
TOAD Yes No No No No
Toad Data Modeler No Yes Yes Yes[19] ?
SQLPro SQL Client ? No No No No
WWW SQL Designer No Yes No Some No
MySql Lite Administrator No No No No 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. ^ Generated SQL must be executed outside Toad Data Modeler
This is an extract from Wikipedia, the Free Encyclopedia
offerte voli | hoteles | precios | voli | die verzeichnis | annuarie web | stop smoking london