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 Management Studio has a debugger in the 2008 version. It did not have in the 2005 version. →‎Features (continued)
Line 1,492: Line 1,492:
| {{?}}
| {{?}}
| {{?}}
| {{?}}
| {{no}}
| {{yes}}
| {{?}}
| {{?}}
|-
|-

Revision as of 15:58, 3 February 2010

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

Product Creator Latest stable release Latest testing release License / Price (USD) Runs on Windows Runs on Mac OS X Runs on Linux Database Programming language
Adminer Jakub Vrána 2.0.0 (2009-08-06) 2.0.0 (2009-08-06) Apache license Yes Yes Yes MySQL php
Advanced Query Tool (AQT) Cardett Associates Ltd. 8.2.8 (2009-08-31) 8.2.8 (2009-08-31) Proprietary / $300 Yes No No ODBC C++
PL/SQL Developer Allround Automations 8.0.0 (2009-08-24) 8.0.0 (2009-08-24) Proprietary / $180 Yes No No Oracle C++
Database Master Nucleon Software v1.7 (2010-01-01) ? Proprietary / $49 with a free 30 day trial version available Yes No No MS SQL Server,Oracle, MySQL, PostgreSQL, FireBird,SQLite,ODBC,OleDb,MS Access .Net / C#
Altova DatabaseSpy Altova v2009 (2009-02-03) ? Proprietary / $129 with a free 30 day trial version available Yes No No MS SQL Server, IBM DB2, Oracle, Sybase, MySQL, PostgreSQL, MS Access C++
Nob Hill Database Compare Nob Hill Software 1.3.01 ? Proprietary / 49$ for MySQL only, 299$ full ver. Yes No No MS SQL Server, MySQL .net
Aqua Data Studio AquaFold, Inc. 8.0.2 (2009-10-20) ? Proprietary / $399 Yes Yes Yes Oracle, IBM DB2 iSeries, DB2 LUW, IBM DB2 z/OS, MS SQL Server, Sybase ASE, Sybase Anywhere, Sybase (IQ), Teradata, Aster Data Systems (nCluster), Informix, PostgreSQL, MySQL, Apache Derby, JDBC, ODBC 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++
Caché Monitor Andreas Schneider 2009 2009 Freeware Yes Yes Yes InterSystems Caché Java
dbForge Studio for MySQL Devart 3.10 (2009-02-26) 3.50 (2009-03-19) 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 DbVis Software AB 7.0 (2010-01-15) ? Proprietary / $179 Yes Yes Yes JDBC Java
Devgems Data Modeler Devgems 1.0.0 (2009-04-30) ? Proprietary / €99 Yes No No InterBase, MS SQL Server, Firebird CodeGear Delphi
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 ?
Embarcadero DBArtisan Embarcadero Technologies 8.6.2 ? Proprietary Yes No No DB2, MySQL, MS SQL Server, Oracle, Sybase ASE C++
EMS SQL Management Studio SQLManager.net 1.1.01 (2007-12-13) ? Proprietary / $468–$518 / Also have free version Yes Yes Yes DB2, MySQL, MS SQL Server, PostgreSQL, InterBase/Firebird, Oracle ?
ESF Database Migration Toolkit EasyFrom Inc 6.0.21 (2009-06-05) ? Proprietary / $219 – $259 Yes No No MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2, MS Access, MS Excel, Firebird, Interbase, Foxpro, dBase, CSV/Text, and any ODBC C++
Epictetus Antilogic Software ? 1.0 (2009-06-17) 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
HeidiSQL [2] 3.2 (?) 4.0 RC3 (2008-01-13) GPL Yes No No MySQL CodeGear Delphi
jfacedbc2 ? 2.2.1 (2004-01-14) ? GPL Yes Yes Yes JDBC Java
Maatkit Baron Schwartz 5247 (2010-06-01) ? GPL Yes Yes Yes MySQL Perl
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/Free Community Edition for MySQL/PostgreSQL/ODBC Yes No No Oracle, MS SQL Server, DB2, DB2/zOS, MySQL, PostgreSQL, MS Access, ODBC C++
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 Corp. 2.1.0.63.73 (2009-12-15) ? Proprietary / free Yes Yes Yes Oracle Database, Microsoft Access, MySQL, Sybase, DB2, ODBC, JDBC Java
OraDeveloper Studio Devart 2.55 (2007-11-28) ? Proprietary / $99.95 Yes No No Oracle C#
pgAdmin III pgAdmin Development Team 1.10.1 (2009-12-04) 1.10.1 (2009-12-04) 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.2.5 (2010-01-10) ? GPL Yes Yes Yes MySQL php
phpPgAdmin ? 4.2.2 (2008-12-18) ? GPL Yes Yes Yes PostgreSQL php
QuantumDB ? 3.3.3 (2009-08-27) ? 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
SchemaBank Ezenso Limited ? ? SaaS / starting from $3 Yes Yes Yes MySQL, PostgreSQL ?
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, SQLite, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL; ODBC CodeGear Delphi
SQL Navigator Quest Software 6.1.1
(2009-02-17) 		6.2
Community 		Proprietary / $870-$2990 Yes No No Oracle CodeGear Delphi
Microsoft SQL Server Management Studio Microsoft ? ? Proprietary / $ / express edition for free Yes No No MS SQL Server ?
SQLyog Webyog Softworks Pvt. Ltd. 8.16 ? GPLv2 Yes No No MySQL C++
SQuirreL SQL ? 3.0.2 (2009-06-20) ? 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 Various Betas Proprietary / Pricing / Freeware Yes No No DB2, MS SQL Server, MySQL, Oracle, Sybase and ODBC CodeGear Delphi C#.NET
Toad Data Modeler Quest Software 3.3.8 (2009-03-05) 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.3.2 (2009-01-07) ? GPL Yes Yes Yes MS SQL Server, MySQL, PostgreSQL, SQLite JavaScript
MySql Lite Administrator Vladimir Carrer ? 0.8 (2008-06-11) GPL Yes Yes Yes MySQL php
Oracle Enterprise Manager Oracle Corp. 10gR5(2009-03-03) ? Proprietary / Free

Priced Add-on Packs and Extensions

Yes No Yes Oracle, DB2, MS SQL Server, MySQL, Sybase, TimesTen.

Also manage Storage, Middleware, Network, Host components and bidirectionally connect to other applications.

Java

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
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
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
Caché Monitor desktop No Yes No Yes Yes Yes Yes Yes Yes Yes
dbForge Studio for MySQL TDI Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Database Master desktop 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
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
DreamCoder desktop ? ? ? ? Yes Yes Yes Yes Yes[1] Yes
Embarcadero DBArtisan desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes
EMS SQL Management Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Epictetus desktop No Yes No No 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
ModelRight desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes
Navicat desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes 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
PL/SQL Developer desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
pgAdmin III TDI Yes 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 ? ? ? ? ? ? ? ? ? ?
SchemaBank Browser-based Yes Yes Yes Yes No No No No No No
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 Navigator desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Microsoft SQL Server Management Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
SQLyog desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
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
Oracle Enterprise Manager Browser-based Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

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
Adminer Yes Yes Yes SQL script, CSV SQL script, CSV No SVN
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, MS SQL Server, IBM DB2 (SVN) Subversion (software), (CVS) Concurrent Versions System
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 ?
Database Master Yes ? Yes Yes SQL Script, Excel, Word, PDF, Report, CSV,HTML,XML,Data Package (Pack&Go) Export/Import (Large Data), ER Diagram as image, Bulk SQL Import No ?
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 ?
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, 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 ? ?
ESF Database Migration Toolkit Yes No Yes Any database/file systems Any database/file systems No ?
Epictetus No Yes No No Excel 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 ?
Navicat Yes No Yes Yes - from supported databases using native interfaces, or from any ODBC source CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML 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 ?
PL/SQL Developer Yes Yes Yes Dump, SQL CSV, TSV, XML, SQL, HTML, MS Excel Yes Microsoft Visual SourceSafe, Merant PVCS, MKS Source Integrity
pgAdmin III Yes Yes No No CSV,text, HTML, XML Yes No
phpMSAdmin ? ? ? ? ? No ?
phpMyAdmin Yes ? ? ? CSV,LaTeX,Excel,XML,SQL No ?
phpPgAdmin ? ? ? ? ? No ?
QuantumDB ? ? ? ? CSV,XML No ?
RazorSQL ? ? ? ? ? No ?
SchemaBank Some Some Yes SQL script SQL script, HTML report, diagram as PNG No Yes
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 Navigator Some No Some Yes Yes Yes CVS, ClearCase, PVCS, StarTeam, TFS, VSS
SQL Server Management Studio Yes ? ? ? ? Yes ?
SQLyog Yes ? Yes Yes Yes ? ?
SQuirreL SQL ? Yes ? Yes ? No ?
SQLPro SQL Client ? ? ? ? ? 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, JPG, PNG No ?
WWW SQL Designer No No No No SQL No ?
MySql Lite Administrator No No No No No 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
Adminer Yes Yes Yes No No
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
Database Master Yes Yes Yes Yes Yes
DbVisualizer Yes Yes Some No No
Devgems Data Modeler No Yes Yes Yes Yes
DeZign for Databases No Yes Yes Yes[12] Yes
dbForge Studio for MySQL Yes Yes Yes Yes Yes
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 Yes 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
SchemaBank No Yes Yes Yes Yes
SQL Developer No Yes Yes No[5] No
SQL Edge Some[15] Yes Yes No[6] No
SQL Maestro Yes[16] Yes Yes Yes No
SQL Navigator Yes Yes Yes No ?
SQL Server Management Studio ? ? ? ? ?
SQLyog Yes[17] Yes[18] Yes Yes ?
SQuirreL SQL No Yes Yes[19] ? No
Toad Yes Yes Yes Yes ?
Toad Data Modeler No Yes Yes Yes[20] ?
SQLPro SQL Client ? No No No No
WWW SQL Designer No Yes No Some No
MySql Lite Administrator No No No No 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. ^ 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. ^ SQL Maestro query builder
  17. ^ SQLYog query builder
  18. ^ SQLYog schema designer
  19. ^ Only incremental, by manually going through each table and clicking "Add to graph"
  20. ^ Generated SQL must be executed outside Toad Data Modeler
Retrieved from "https://en.wikipedia.org/w/index.php?title=Comparison_of_database_administration_tools&oldid=341699060"