Comparison of database tools

https://en.wikipedia.org/wiki/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.

General[edit]

Product	Creator	Latest stable release date	Latest stable release	Latest testing release	License	Runs onWindows	Runs onMac OS X	Runs onLinux	Oracle	MySQL	PostgreSQL	MS SQL Server	ODBC	JDBC	SQLite	Other	Programming language
Adminer	Jakub Vrána	2014-04-18	4.1.0	none distributed	Apache License orGPL	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++
Database Workbench	Upscene Productions	2014-08-29	5.0	?	Proprietary	Yes	requiresWine	requiresWine	Yes	Yes		Yes	Yes			InterBase,Firebird, SQL Anywhere,NexusDB andMariaDB	Delphi
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
DbVisualizer	DbVis Software	2015-05-13	9.2.7	?	Proprietary	Yes	Yes	Yes	Yes	Yes	Yes	Yes		Yes	Yes		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-11-11	9.1.0.4867	9.1.0.4882 (2014-12-01)	GPL	Yes	requiresWine	requiresWine		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	2015-04-23	6.3.3	?	GPL	Yes	Yes	Yes		Yes							C++/C#Objective-CPython (programming language)
Navicat	PremiumSoft CyberTech Ltd.	2015-01-23	11.1.9	?	Proprietary	Yes	Yes	requiresWine	Yes	Yes	Yes	Yes	Yes		Yes		Borland DelphiObjective-C
Navicat Data Modeler	PremiumSoft CyberTech Ltd.	2015-06-15	2.0.0	?	Proprietary	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes		Yes		Borland DelphiObjective-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.	2014-09-15	4.0.3.16.84	4.1 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, Derbyall with JDBCdriver	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	2015-02-05	4.3.9[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
SQL Database Studio	Jan Prochazka	2014-11-13	2.0.7		Proprietary	Yes	No	No	No	No	No	Yes					.NET, WPF, C#
SQLyog	Webyog Softworks Pvt. Ltd.	2014-10-23	12.02[4]	?	GPLv2	Yes	requiresWine	requiresWine		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	?
Database Workbench	desktop	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?
DBEdit	desktop	No	No	No	No	Yes	Yes	Yes	No	No	Yes	No	?
DbVisualizer	desktop	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?
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	Yes	Yes	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	?	?	?	?	?	?	?	?	?	?	?	?
SQL Database Studio	desktop	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
SQLyog	desktop	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	?	?
SQuirreL SQL	desktop	?	?	?	?	Yes	Yes	?	?	Yes	Yes	Some	?
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
Database Workbench	Yes	No	Yes	Yes	Yes	Yes	?
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	?
SQL Database Studio	Yes	Yes	No	CSV, XML, MS Excel	CSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XML	No	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
Database Workbench	Yes	Yes	Yes	?	Yes
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	Yes	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 Database Studio	Yes	Yes	Yes	Yes	No
SQL Server Management Studio	?	Yes	Yes	?	?
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]

• Comparison of data modeling tools
• Comparison of object database management systems
• Comparison of object-relational database management systems
• Comparison of relational database management systems
• List of relational database management systems
• SQL programming tool

Notes[edit]

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

External links[edit]

• Database administration and schema design tools

[hide] v t e Database Main Requirements Theory Models Database management system Machine Server Application Connection  datasource DSN Administrator Lock Types Tools   Languages Data definition Data manipulation Query  information retrieval   Security Activity monitoring Audit Forensics Negative database   Design Entities and relationships (and Enhanced notation) Normalization Refactoring   Programming Abstraction layer Object-relational mapping   Management Virtualization Tuning  caching Migration Preservation Integrity   See also Database-centric architecture Intelligent database Two-phase locking Locks with ordered sharing Load file Publishing Halloween Problem Log shipping    Book  Category  WikiProject

Categories: 

• Database administration tools
• Database software comparisons
• Database management systems