Comparison of database tools

From Wikipedia, the free encyclopedia
Jump to: navigation, search

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.

General[edit]

Product Creator Latest stable release date Latest stable release Latest testing release License Runs on Windows Runs on Mac OS X Runs on Linux Oracle MySQL PostgreSQL SQL Server ODBC JDBC SQLite Other Programming language
Adminer Jakub Vrána 2014-04-18 4.1.0 none distributed Apache license or GPL Yes Yes Yes Yes Yes Yes Yes Yes PHP
Advanced Query Tool (AQT) Cardett Associates Ltd[1] 2009-08-31 8.2.8 8.2.8 (2009-08-31) Proprietary Yes No No Yes Yes Yes Yes Yes C++
DaDaBIK Eugenio Tacchini 2012-04-03 4.4 ? Proprietary Yes Yes Yes Yes Yes Yes Yes No No Yes PHP
Database Deployment Manager The Unauthorized Frog project 2012-05-29 v0.1i ? LGPL Yes No Yes Yes Qt/C++
DatabaseSpy Altova 2013-06-12 v2013r2sp1 ? Proprietary Yes No No Yes Yes Yes Yes Yes Yes IBM DB2, Sybase, MS Access C++
DBEdit Jef Van Den Ouweland 2011-03-18 2.4 ? GPL Yes Yes Yes Yes Yes Yes Yes No Yes Yes IBM DB2, HSQLDB, Apache Derby, H2 Java
Devgems Data Modeler Devgems 2009-04-30 1.0.0 ? Proprietary Yes No No Yes InterBase, Firebird Embarcadero Delphi
Embarcadero DBArtisan Embarcadero Technologies ? 8.6.3 9.5 Proprietary Yes No No Yes Yes Yes Yes Yes DB2, Sybase ASE C++ Java
Epictetus Antilogic Software ? ? 1.0 (2009-06-17) Proprietary Yes Yes Yes Yes Yes Yes Sybase, InterBase/Firebird, H2, HSQLDB Java
ERwin Data Modeler ca.com ? 7.3 ? Proprietary Yes Yes Yes Yes Yes Yes Yes Yes MS Access, DB2, Foxpro, Informix, Ingres, Sybase, Teradata ?
HeidiSQL HeidiSQL 2014-01-25 8.3.0.4694 8.3.0.4814 (2014-08-31) GPL Yes requires Wine — Java edition abandoned requires Wine — Java edition abandoned Yes Yes Embarcadero Delphi
Maatkit Baron Schwartz 2010-06-01 5247 ? GPL Yes Yes Yes Yes Perl
Microsoft SQL Server Management Studio Microsoft ? ? ? Proprietary Yes No No Yes .Net
ModelRight ModelRight ? 3.6 3.7 Proprietary Yes No No Yes Yes Yes Yes SQL Server, Oracle, MySQL, PostgreSQL, DB2, DB2/zOS, MS Access C++
MySQL Workbench Oracle Corporation 2014-06-27 6.1.7 6.2.1 (2014-08-19) GPL Yes Yes Yes Yes C++/C# Objective-C Python (programming language)
Navicat PremiumSoft CyberTech Ltd. 2013-07-03/

2013-06-10

11.0.8/

11.0.4

11.0.8

(2013-07-03)/

11.0.4 (2013-06-10)

Proprietary Yes Yes requires Wine Yes Yes Yes Yes Yes Yes Borland Delphi Objective-C
Navicat Data Modeler PremiumSoft CyberTech Ltd. 2013-02-04/

2013-06-14

1.0.11/

1.0.4

1.0.11 (2013-02-04)/

1.0.4

(2013-06-14)

Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes Borland Delphi Objective-C
Oracle Enterprise Manager Oracle Corp. 2009-03-03 10gR5 ? Proprietary Yes No Yes Yes Yes Yes DB2, Sybase, TimesTen Java
Oracle SQL Developer Oracle Corp. 2010-03-01 2.1.1 3.0 early adopter Proprietary Yes Yes Yes Yes Yes No Yes Yes Yes Microsoft Access, Sybase, DB2, Teradata Java
Orbada Andrzej Ka?u?a 2014-08-13 1.2.2.335 none GPL Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Firebird, HSQL, Interbase, Derby all with JDBC driver Java
pgAdmin III pgAdmin Development Team 2012-09-11 1.18.0 ? PostgreSQL License Yes Yes Yes Yes C++
phpLiteAdmin Dane Iracleous 2012-5-31 1.9.2 ? GPL Yes Yes Yes No No No No No No Yes PHP
phpMyAdmin phpMyAdmin Development Team 2014-08-07 4.2.7.1[2] none GPL Yes Yes Yes Yes Drizzle, MariaDB php
phpPgAdmin The phpPgAdmin Project 2013-04-14 5.1[3] ? GPL Yes Yes Yes Yes php
SQLPro SQL Client Vive 2008-02-04 1.4 ? Proprietary Yes No No Yes Yes Yes Yes Yes C++
SQLyog Webyog Softworks Pvt. Ltd. 2014-07-18 11.52[4] ? GPLv2 Yes requires Wine requires Wine Yes C++
SQuirreL SQL Colin Bell, Gerd Wagner, Rob Manning and others 2014-05-11 3.5.3 20140830_1158 GPLv2 & LGPLv2 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Access,Axion Java RDBMS, Apache Derby, Daffodil DB, Fujitsu Siemens SESAM/SQL, Firebird, FrontBase, HSQLDB, Hypersonic SQL, H2 (DBMS), IBM DB2, Informix, Ingres, OpenIngres, InstantDB, InterBase, Mckoi SQL Database, Microsoft SQL Server, Mimer SQL, Netezza, Pointbase, SAPDB, Sybase, Sunopsis XML Driver, Teradata Warehouse, ThinkSQL RDBMS, Vertica Analytic Database, and others with JDBC drivers. Java
Toad Quest Software Various Various Betas Proprietary Yes No No Yes Yes Yes Yes DB2, Sybase Embarcadero Delphi, C#.NET
Toad Data Modeler Quest Software 2009-03-05 3.3.8 Betas[5] Proprietary Yes No No Yes Yes Yes Yes DB2, MS Access, Sybase Embarcadero Delphi
TOra Community 2010-09-19 2.1.3 ? GPL Yes Yes Yes Yes Yes Yes Teradata C++/Qt

Features[edit]

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
  • Multi-server support:
    • Yes - can manage from the same window/session multiple servers
    • Some - can manage from a different window/session multiple servers
  • Monitoring server:
    • Yes - includes a headless server, that runs checks and reports failures
Tools User Interface Create & Alter wizard Browse Auto Completion Syntax colored Multi server support Monitoring server
Database Table Procedure Trigger Database Table Procedure Trigger
Adminer Browser-based Yes Yes Yes Yes Yes Yes Yes Yes No Yes ? ?
Altova DatabaseSpy desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ?
DaDaBIK Browser-based No Some[6] No No No Some[7] No No No No No ?
Database Deployment Manager desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No ?
DBEdit desktop No No No No Yes Yes Yes No No Yes No ?
Devgems Data Modeler desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes ? ?
DeZign for Databases desktop Yes Some Yes Yes Yes Some Yes Yes No Yes ? ?
Embarcadero DBArtisan desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ? ?
Epictetus desktop No Yes No No Yes Yes Yes Yes Yes Yes ? ?
Microsoft SQL Server Management Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes No
ModelRight desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes ? ?
MySQL Workbench desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Some
Navicat desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ?
Navicat Data Modeler desktop No Yes No Yes No No No No No No Yes ?
Oracle Enterprise Manager Browser-based Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ? Yes
Oracle SQL Developer desktop No Yes Yes Yes Yes Yes Yes Yes No Yes Yes ?
Orbada desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No
pgAdmin III TDI Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ?
phpliteadmin Browser-based Yes Yes No No Yes Yes No No No No ? ?
phpMyAdmin Browser-based Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes ?
phpPgAdmin Browser-based ? ? ? ? ? ? ? ? ? ? ? ?
SQLyog desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ? ?
SQuirreL SQL desktop ? ? ? ? Yes Yes ? ? Yes Yes Some ?
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 ? ?
TOra desktop No Yes Yes No Yes Yes Yes Yes Yes Yes Yes ?

Features (continued)[edit]

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
Adminer Yes Yes Yes SQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2 SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin) No Git
Altova DatabaseSpy No No Yes CSV, XML XML, XML Structure, CSV, HTML, MS Excel No ?
DaDaBIK Some[8] No No No CSV Yes No
DBEdit No No No No MS Excel, PDF, Text, SQL script No ?
Devgems Data Modeler No No No No SQL; HTML report; diagram as EMF, BMP No ?
DeZign for Databases No No Yes No SQL; diagram as EMF, BMP, GIF, JPEG, PNG No ?
Epictetus No Yes No No Excel No ?
ModelRight Some Yes Yes Yes - from supported databases using native interfaces, or from any ODBC source SQL; XML; DTD; Diagram as BMP, JPEG No ?
Navicat Yes No Yes Yes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations[9]) Yes - TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF (See link for limitations[9]) Yes No
Navicat Data Modeler No No Yes Yes - Import Database from server/ODBC Yes - Export SQL No No
MySQL Workbench Yes Yes Yes Yes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML Yes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML Yes No
Oracle SQL Developer Yes ? ? Yes Yes Yes ?
Orbada No Yes Yes SQL script SQL script, CSV, XML, HTML, PDF, Excel, DBF, DataText No No
pgAdmin III Yes Yes No CSV, Text, or binary CSV, text, HTML, XML Yes No
phpMyAdmin Yes Some Yes Yes - CSV, SQL, XML, Excel, ODS Yes - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediaWiki No Git
phpPgAdmin ? ? ? ? ? No ?
SQLPro SQL Client ? ? ? ? ? No ?
SQLyog Yes ? Yes Yes Yes ? ?
SQL Server Management Studio Yes ? ? ? ? Yes ?
SQuirreL SQL ? Yes ? Yes ? No ?
Toad Some No Yes Yes Yes Yes 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, JPEG, PNG No ?
TOra Some No Yes Yes Yes Yes No

Features - visual design and reverse engineering[edit]

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
Adminer Yes Yes Yes No No
Altova DatabaseSpy Yes Yes Yes Yes ?
DaDaBIK Some[10] No No No No
Database Deployment Manager Yes Yes Yes No No
DBEdit No No No No No
Devgems Data Modeler No Yes Yes Yes Yes
DeZign for Databases No Yes Yes Yes[11] Yes
ModelRight No Yes Yes Yes Yes
Navicat Yes Yes Yes Yes Yes
Navicat Data Modeler No Yes Yes Yes Yes
MySQL Workbench Yes Yes Yes Yes Yes
Oracle SQL Developer Yes Yes Yes Yes ?
Orbada No No No No No
pgAdmin III Yes No No No No
phpMyAdmin Yes Yes Yes No No
phpPgAdmin No No No No No
SQL Server Management Studio ? Yes Yes ? ?
SQLPro SQL Client ? No No No No
SQLyog Yes[12] Yes[13] Yes Yes ?
SQuirreL SQL Yes Yes Yes[14] ? No
Toad Yes Yes Yes Yes ?
Toad Data Modeler No Yes Yes Yes[15] ?

See also[edit]

Notes[edit]

  1. ^ Cardett Associates Ltd
  2. ^ http://sourceforge.net/p/phpmyadmin/news/2014/08/phpmyadmin-40102-41143-and-4271-are-released/
  3. ^ http://phppgadmin.sourceforge.net/doku.php
  4. ^ "SQLyog MySQL GUI 11.52 Released". webyog.com. Retrieved 1 August 2014. 
  5. ^ Toad Data Modeler Betas
  6. ^ create CRUD interfaces, so create table data, not table theriselves
  7. ^ browse table data, not table definitions
  8. ^ can manage its own users, which override the DBMS users
  9. ^ a b title= Navicat feature matrix
  10. ^ the CRUD interface created includes a search form
  11. ^ Via SQL scripts for dropping and creating, which must be executed outside DeZign for Databases
  12. ^ SQLYog query builder
  13. ^ SQLYog schema designer
  14. ^ Only incremental, by manually going through each table and clicking "Add to graph"
  15. ^ Generated SQL must be executed outside Toad Data Modeler

External links[edit]