Comparison of database tools

Comparison of database tools

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

General

Product Creator 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
My DataBase OnLine DataCast Technologies Inc. 1.4 (2007-06-22) 1.4 (2007-06-22) Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Mixed
ABIS-Query BOS-Software Sarl 1.4 (2010-09-22) 1.4 (2010-09-22) Proprietary Yes No No Yes Yes Yes Yes Yes SAP, Firebird, Adavantage Database, MS Access, MS Excel C#
D-Softs Database Compare D-Softs Database Compare 2.5.6 (2011-01-22) 2.5.6 (2011-01-22) Proprietary Yes No No No No No Yes Yes SQL Server C#
ACDB Electronic Experience 2.0.1 (2010-04-25) ? Proprietary Yes Yes Yes Yes Yes Java
Adminer Jakub Vrána 3.3.3 (2011-08-12) none distributed Apache license or GPL Yes Yes Yes Yes Yes Yes Yes Yes php
Advanced Query Tool (AQT) Cardett Associates Ltd 8.2.8 (2009-08-31) 8.2.8 (2009-08-31) Proprietary Yes No No Yes Yes Yes Yes Yes C++
Aqua Data Studio AquaFold, Inc. 9.0.0 (2010-10-04) ? Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes IBM DB2 iSeries, DB2 LUW, IBM DB2 z/OS, Netezza, Sybase ASE, Sybase Anywhere, Sybase (IQ), Teradata, Aster Data Systems (nCluster), Informix, Apache Derby Java
ARMS NovaQuantum 1.0.2 (2010-03-10) 1.0.2 (2010-03-10) Proprietary Yes Yes Yes Yes JavaScript / PHP
Caché Monitor Andreas Schneider 2009 2009 ? Yes Yes Yes InterSystems Caché Java
Chive Fusonic 0.3.0 ? GPL Yes Yes Yes Yes php
CompareData Zidsoft 2008 2008 Proprietary Yes No No Yes C++
DaDaBIK Eugenio Tacchini 4.3 (2010-12-08) 4.4 alpha (2010-02-02) GPL Yes Yes Yes Yes Yes Yes Yes No No Yes php
Data Analyst Toolkit LiveMeta.com 1.1.0.3 (209-09-22) 1.1.0.3 (2009-09-22) Freeware Yes No No Yes Yes Yes Yes Yes DB2 - All versions zOs and UDB, Any DB with an ODBC Driver C#
Data Visualization Adam Witkowski 1.0 (2011-07-24) Not Available Freeware Yes Yes Yes Yes Yes Yes Yes Yes Yes Firebird, IBM DB2, Interbase, Amazon SimpleDB, Sybase Java
Database Deployment Manager The Unauthorized Frog project v0.1a (2010-10-14) ? LGPL Yes No Yes Yes Qt/C++
Database Master with LINQ Nucleon Software v3.0 (2010-06-15) ? Proprietary Yes No No Yes Yes Yes Yes Yes No Yes MongoDB,SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, Ingres (database), Firebird,SQLite, EffiProz, XML File, ODBC, OleDb, MS Access Netezza .Net / C#
DatabaseSpy Altova v2010r3 (2009-05-05) ? Proprietary Yes No No Yes Yes Yes Yes IBM DB2, Sybase, MS Access C++
DataFlyer ALVILA SYSTEMS 2.0 ? Proprietary Yes No Yes Yes Yes Yes Yes Yes Yes IBM DB2 , Apache Derby , HSQLDB , MS Excel Java
DatAdmin JenaSoft 3.6.3 (2010-05-18) 3.7.3 (2010-05-16) Proprietary Yes No No Yes Yes Yes Yes MS Access C#
DataGlass impathic 3.0 (2010-12-04) ? Proprietary No iOS (iPhone, iPad, iPod Touch) No Yes Yes Yes Yes Microsoft Access, IBM DB2, Sybase ASE Objective-C
DBeauty DBeauty[1] 1.0 (2011-08-15) 1.0 (2011-08-15) Apache 2.0 Yes Yes Yes Yes Yes Yes Yes Yes JDBC Java
DBEdit Jef Van Den Ouweland 2.4 (2011-03-18) ? GPL Yes Yes Yes Yes Yes Yes Yes No Yes Yes IBM DB2, HSQLDB, Apache Derby, H2 Java
dbForge SQL Complete Devart 2.00 (2011-21-01) 2.00.46 (2011-24-01) Freeware and Proprietary Yes No No No No No Yes C#
dbForge Studio for MySQL Devart 4.50 (2010-06-21) ? Proprietary Yes No No Yes C#
DBMan SQLEXEC LLC 5.0 (2009-10-01) 5.0 (2009-10-01) ? Yes No No Yes Yes Yes Yes Yes DB2, Sybase (ASE/ASA), MS Access, Firebird PowerBuilder/C++
DbNinja Vayer Software Ltd. 1.0.1 (2010-01-01) ? Proprietary Yes Yes Yes Yes ?
DbSchema Wise Coders Solutions 5.1.2 (2008-08-13) ? Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes Java
DBTyp.NET BYPsoft 2007 2008 Proprietary Yes No No Yes Yes Yes C#
DbVisualizer DbVis Software 8.0 (2011-06-16) ? Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes IBM DB2, Sybase ASE, Informix, Apache Derby, Mimer SQL, HP Neoview, H2 Java
Debugger for MySQL MyDebugger.com 1.2 (2010-06-02) 1.2 (2010-06-02) Proprietary Yes No No Yes CodeGear Delphi
Devgems Data Modeler Devgems 1.0.0 (2009-04-30) ? Proprietary Yes No No Yes InterBase, Firebird CodeGear Delphi
Dezign for Database Datanamic 5.1.1 (2008-04-04) ? Proprietary Yes No No Yes Yes Yes Yes InterBase, IBM DB2, 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 Yes No No Yes Yes Yes ?
Embarcadero DBArtisan Embarcadero Technologies 8.6.2 ? Proprietary Yes No No Yes Yes Yes DB2, Sybase ASE C++
EMS SQL Management Studio SQLManager.net 1.1.01 (2007-12-13) ? Proprietary Yes Yes Yes Yes Yes Yes Yes DB2, InterBase/Firebird ?
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 ?
ESF Database Migration Toolkit EasyFrom Inc 6.0.21 (2009-06-05) ? Proprietary Yes No No Yes Yes Yes Yes Yes IBM DB2, MS Access, MS Excel, Firebird, Interbase, Foxpro, dBase, CSV/Text, any ODBC C++
Happy Fish Automatisering Polderij 4.0.1 (2008-05-24) ? ? Yes No No Yes Borland Delphi
HeidiSQL HeidiSQL 4.0 (2009-04-30) 5.0 Beta (2010-01-30) GPL Yes Yes Yes Yes CodeGear Delphi
Jailer Jailer[2] 3.5.6 (2011-06-07) 3.5.6 (2011-06-07) Apache 2.0 Yes Yes Yes Yes Yes Yes Yes Yes JDBC Java
jfacedbc2 ? 2.2.1 (2004-01-14) ? GPL Yes Yes Yes Yes Java
Maatkit Baron Schwartz 5247 (2010-06-01) ? GPL Yes Yes Yes Yes Perl
MicroOLAP Database Designer MicrOLAP 1.2.3 (2008-02-01) 1.2.4-beta (2008-05-09) Proprietary Yes No No Yes Yes ?
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++
MyOra Jayam Systems LLC 1.0.4 (2010-04-09) ? Proprietary Yes No No Yes Java
MyQuery Builder MyQuery Builder[3] 2.0.4 (2011-08-04) 2.0.4 (2011-08-04) Proprietary Yes Yes Yes Yes PHP
MySql Lite Administrator Vladimir Carrer ? 0.8 (2008-06-11) GPL Yes Yes Yes Yes php
Navicat Navicat 9.0.10 (2010-06-23) 9.0.10 (2010-06-23) Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes Borland Delphi Objective-C
Nob Hill Database Compare Nob Hill Software 1.3.01 ? Proprietary Yes No No Yes Yes .net
Online Data Modeler JenaSoft 1.0.0 1.0.0 Proprietary Yes Yes Yes Yes Yes Yes Yes Yes EffiProz JavaScript, ASP.NET
Oracle Enterprise Manager Oracle Corp. 10gR5(2009-03-03) ? Proprietary Yes No Yes Yes Yes Yes DB2, Sybase, TimesTen Java
Oracle SQL Developer Oracle Corp. 2.1.1 (1 March 2010) 3.0 early adopter Proprietary Yes Yes Yes Yes Yes No Yes Yes Yes Microsoft Access, Sybase, DB2, Teradata Java
OraDeveloper Studio Devart 2.55 (2007-11-28) ? Proprietary Yes No No Yes C#
Orbada Andrzej Kałuża 1.0.4.109 (2011-02-08) 1.0.4.109 (2011-02-08) 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 1.14.0 (2011-09-12) ? Artistic License Yes Yes Yes Yes C++
phpliteadmin Dane Iracleous 1.6 (2011-3-15) ? GPL No No No No No No No No No Yes php
phpMSAdmin Adam Voigt 0.18 (2006-07-23) ? GPL Yes Yes Yes Yes php
phpMyAdmin phpMyAdmin Development Team 3.4.2 (2011-06-07) ? GPL Yes Yes Yes Yes Drizzle, MariaDB php
phpPgAdmin The phpPgAdmin Project 4.2.3 (2010-03-29) ? GPL Yes Yes Yes Yes php
PL/SQL Developer Allround Automations 8.0.0 (2009-08-24) 8.0.0 (2009-08-24) Proprietary Yes No No Yes CodeGear Delphi
QuantumDB Julen Parra 3.3.3 (2009-08-27) ? GPL Yes Yes Yes Yes Yes Java
QweryBuilder Werysoft 7.1.0 (2011-11-12) 7.1.0 (2011-11-12) Proprietary Yes No No Yes Yes Yes Sybase, SQL Anywhere ?
RazorSQL Richardson Software, LLC 5.1.2 (2010-04-14) ? Proprietary Yes Yes Yes Yes Java
SchemaBank Ezenso Limited ? ? SaaS Yes Yes Yes Yes Yes ?
Silver Sash Administrator silversash.com 1.0.1 ? Proprietary Yes Yes Yes Yes Java
SQL Buddy ? 1.3.3 (2011-01-18) ? MIT Yes Yes Yes No Yes Yes php
SQL Developer Jan Borchers 2.3.0 ? Proprietary Yes Yes Yes Yes Java
SQL Edge Bay Breeze Software, Inc. 3.3 ? Proprietary Yes Yes Yes Yes Yes Yes Yes Yes DB2, Sybase, MaxDB Java
SQL Maestro SQL Maestro Group various various EULA Yes No No Yes Yes Yes Yes Yes Yes DB2, Firebird, MS Access CodeGear Delphi
SQL Navigator Quest Software 6.1.1
(2009-02-17)
6.2 Proprietary Yes No No Yes CodeGear Delphi
SQL Server Comparison Expert DatabaseComparer Ltd. 2.41 (2010-01-23) 2.41 (2010-01-23) ? Yes No No Yes C++
SQLDetective Conquest Software Solutions 4.3.1 (2009-04-07) 4.3.1 (2009-04-07) Proprietary Yes No Yes Yes CodeGear Delphi
SQLPro SQL Client Vive 1.4 (2008-02-04) ? Proprietary Yes No No Yes Yes Yes Yes Yes C++
SQLWave nerocode 5.7.2 Not Available Proprietary Yes No No Yes ?
SQLyog Webyog Softworks Pvt. Ltd. 9.2 ? GPLv2 Yes Yes Yes Yes C++
SQuirreL SQL ? 3.1.2 (2010-12-31) ? GPL Yes Yes Yes Yes Yes Yes Yes Yes Yes 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 Access, 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 Betas Proprietary Yes No No Yes Yes Yes Yes DB2, Sybase CodeGear Delphi C#.NET
Toad Data Modeler Quest Software 3.3.8 (2009-03-05) Betas Freeware and Proprietary Yes No No Yes Yes Yes Yes DB2, MS Access, Sybase CodeGear Delphi
TOra Community 2.1.3 (2010-09-19)  ? GPL Yes Yes Yes Yes Yes Yes Teradata C++/Qt
WWW SQL Designer Ondřej Žára 2.3.2 (2009-01-07) ? GPL Yes Yes Yes Yes Yes Yes Yes JavaScript

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
  • Multi-server support:
    • Yes - can manage from the same window/session multiple servers
    • Some - can manage from a different window/session multiple servers
Tools User Interface Create & Alter wizard Browse Auto Completion Syntax colored Multi server support
Database Table Procedure Trigger Database Table Procedure Trigger
ABIS-Query desktop No No No No Yes Yes Yes No No Yes ?
ACDB desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ?
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
Aqua Data Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
ARMS Browser-based Yes Yes Yes Yes Yes Yes Yes Yes No No Yes
Caché Monitor desktop No Yes No Yes Yes Yes Yes Yes Yes Yes ?
Chive Browser-based Yes Yes Yes Yes Yes Yes Yes Yes No Yes ?
DaDaBIK Browser-based No Some [4] No No No Some [5] No No No No No
Data Visualization desktop No No No No Yes Yes No No Yes Yes Yes
Database Master desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
DatAdmin desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes
DataGlass mobile (iOS) No No No No Yes Yes No No No No Yes
DataFlyer desktop ? ? ? ? Yes Yes ? ? ? ? ?
DBeauty desktop No No No No Yes Yes No No Yes Yes ?
DBEdit desktop No No No No Yes Yes Yes No No Yes No
dbForge Studio for MySQL TDI Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
DBMan desktop Yes Yes Yes Yes Yes Yes Yes Yes No No ?
DbNinja Browser-based Yes 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 Yes
Debugger for MySQL desktop No No Yes No No No Yes No Yes[6] Yes Some
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[7] 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 Yes
Epictetus desktop No Yes No No Yes Yes Yes Yes Yes Yes ?
Happy Fish desktop Some[8] Some ? Yes Some[9] Some ? Yes No Yes ?
Jailer desktop No No No No Yes Yes No No Yes Yes ?
jfacedbc desktop ? ? ? ? ? ? ? ? ? ? ?
MicroOLAP Database Designer desktop Yes Some Yes Yes Yes Some Yes Yes No Yes ?
Microsoft SQL Server Management Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes
ModelRight desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes ?
MyQuery Builder Browser-based No No No No Yes Yes No No No No Yes
MySql Lite Administrator Browser-based No No No No Yes Yes No No No No ?
Navicat desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Online Data Modeler Browser-based No Yes Yes Yes Yes No No No No Yes ?
Oracle Enterprise Manager Browser-based 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
OraDeveloper Studio TDI Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ?
Orbada desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
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 ?
phpMSAdmin Browser-based ? ? ? ? ? ? ? ? ? ? ?
phpMyAdmin Browser-based Yes Yes Yes No Yes Yes Yes Yes No Yes Yes
phpPgAdmin Browser-based ? ? ? ? ? ? ? ? ? ? ?
PL/SQL Developer desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ?
QuantumDB desktop ? ? ? ? Yes Yes ? ? No Yes ?
QweryBuilder desktop No No No No Yes [10] Yes Yes Yes Yes [11] Yes Yes


RazorSQL desktop ? ? ? ? ? ? ? ? ? ? ?
SchemaBank Browser-based Yes Yes Yes Yes No No No No No No No
Silver Sash Administrator desktop Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes
SQL Developer desktop Yes Some[12] Yes ? Yes Some[13] Yes ? Yes Yes ?
SQL Edge desktop Yes Some[14] No No Yes Yes Yes[15] Yes[15] 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 ?
SQLDetective desktop 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
SQLPro SQL Client desktop No No No No Yes Yes Yes Yes No Yes ?
SQLWave desktop ? ? ? ? Yes Yes Yes Yes ? Yes 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
WWW SQL Designer Browser-based No Some No No No No No No No No ?

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
Jailer No No No SQL script SQL script (topologically sorted), XML, DBUnit-XML No ?
ABIS-Query No ? No SQL script, Excel SQL script, Excel multi-sheet, XML, XSD No ?
ACDB Yes ? No SQL script SQL script Oracle, MySQL ?
Adminer Yes Yes Yes SQL script, CSV SQL script, CSV No SVN
Altova DatabaseSpy No No Yes CSV, XML XML, XML Structure, CSV, HTML, MS Excel No ?
Aqua Data Studio Yes ? Yes CSV CSV, SQL; diagram as JPEG, PNG Oracle, Sybase, MS SQL Server, IBM DB2 (SVN) Subversion (software), (CVS) Concurrent Versions System
ARMS No ? ? SQL script SQL script No ?
Chive Some ? No SQL script SQL script No ?
DaDaBIK Some[16] No No No CSV Yes No
Data Visualization No No No CSV, XLS(X) PDF, XML, CSV, RTF, MATLAB, TXT, XLS(X), HTML No No
Database Master Yes ? Yes XML Files, CSV, Bulk SQL Script SQL Script, MS Excel, MS Word, PDF, RTF, XPS, CSV, HTML, XML, OpenOffice, DBF, Pack&Go Export/Import, ER Diagram No ?
DatAdmin No Yes Yes SQL script, CSV, HTML, text file using regular expressions, generic XML SQL script, CSV, HTML, XML, DokuWIKI, MediaWIKI, generic text file, MS Excel No No
DataGlass No No No No CSV No No
DataFlyer No ? No No CSV , MS Excel No ?
DBEdit No No No No MS Excel, PDF, Text, SQL script No ?
dbForge Studio for MySQL Yes Yes Yes Yes CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML [17] Yes ?
DBMan Yes No Yes SQL Script, TXT, CSV TXT, CSV, SQL, PDF, XLS, XML, HTML Table, WK1, WMF, DIF, DBF, Clipboard No No
DbNinja Yes Yes Yes SQL script, CSV SQL script, CSV 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, JPEG No ?
Debugger for MySQL No No No No No Yes 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 ?
DreamCoder No No Yes[7] Yes[7] Yes[7] No[7] ?
EMS SQL Management Studio Yes ? Yes[18] 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 No Excel No ?
ESF Database Migration Toolkit Yes No Yes Any database/file systems Any database/file systems No ?
Happy Fish No ? Yes ? SQL; diagram as XML, BMP, JPEG, WMF No ?
jfacedbc ? ? ? ? ? No ?
MicroOLAP Database Designer No ? No Some[19] SQL; HTML report; diagram as BMP, EMF, GIF, JPEG, PNG 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 ?
MyQuery Builder No No No MySQL script MySQL script No No
MySql Lite Administrator No No No No No 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[20]) 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[20]) Yes 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 ?
Orbada No Yes Yes SQL script SQL script, CSV, XML, HTML, PDF, Excel, DBF, DataText No No
pgAdmin III Yes Yes No No CSV, text, HTML, XML Yes No
phpMSAdmin ? ? ? ? ? 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 ?
PL/SQL Developer Yes Yes Yes Dump, SQL CSV, TSV, XML, SQL, HTML, MS Excel Yes Microsoft Visual SourceSafe, Merant PVCS, MKS Source Integrity
QuantumDB ? ? ? ? CSV, XML No ?
QweryBuilder No No Yes [21] Yes Yes Yes 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, JPEG, PNG or SVG[22] No ?
SQL Maestro Yes[23] ? ? 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
SQLDetective Yes Yes Yes Yes Yes Yes Microsoft Visual SourceSafe, Merant PVCS
SQLPro SQL Client ? ? ? ? ? No ?
SQLWave ? 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
WWW SQL Designer No No No No SQL 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
Jailer Yes Yes Yes No No
ABIS-Query Yes No Yes Yes No
ACDB No Yes Yes Yes Yes
Adminer Yes Yes Yes No No
Altova DatabaseSpy Yes Yes Yes Yes ?
Aqua Data Studio Yes Yes Some No ?
ARMS Yes No No No No
Chive No No No No No
DaDaBIK Some [24] No No No No
Database Master Yes Yes Yes Yes Yes
DatAdmin Yes Yes Yes Yes No
DataGlass Yes No No No No
DBEdit No No No No No
dbForge Studio for MySQL Yes Yes Yes Yes Yes
DBMan No Yes Yes Yes Yes
DbNinja Yes Yes Yes No No
DbSchema 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[25] Yes
DreamCoder Yes ? ? ? ?
EMS SQL Management Studio Yes[26] Yes Yes No No
Happy Fish ? Yes Yes Yes Yes
jfacedbc ? ? ? ? ?
MicroOLAP Database Designer No Yes Some Yes ?
ModelRight No Yes Yes Yes Yes
MyQuery Builder Yes No No No No
MySql Lite Administrator No No No No No
Navicat Yes Yes Yes Yes Yes
Online Data Modeler No Yes Yes Yes No
Oracle SQL Developer Yes Yes Yes Yes ?
OraDeveloper Studio Yes No No No No
Orbada No No No No No
pgAdmin III Yes No No No No
phpMSAdmin No ? ? ? ?
phpMyAdmin Yes Yes Yes No No
phpPgAdmin No No No No No
QuantumDB No ? ? ? ?
QweryBuilder Yes[27] No Yes No No
RazorSQL Yes[28] No No No No
SchemaBank No Yes Yes Yes Yes
SQL Developer No Yes Yes No[13] No
SQL Edge Some[29] Yes Yes No[14] No
SQL Maestro Yes[30] Yes Yes Yes No
SQL Navigator Yes Yes Yes No ?
SQL Server Management Studio ? Yes Yes ? ?
SQLDetective Yes No No No No
SQLPro SQL Client ? No No No No
SQLWave ? ? ? ? ?
SQLyog Yes[31] Yes[32] Yes Yes ?
SQuirreL SQL No Yes Yes[33] ? No
Toad Yes Yes Yes Yes ?
Toad Data Modeler No Yes Yes Yes[34] ?
WWW SQL Designer No Yes No Some No

See also

Notes

  1. ^ DBeauty Relational Data Browser
  2. ^ Database Subsetting and Browsing
  3. ^ A MySQL query editor for PHP web developers
  4. ^ create CRUD interfaces, so create table data, not table theriselves
  5. ^ browse table data, not table definitions
  6. ^ Debugger for MySQL: Autocomplete
  7. ^ a b c d e DreamCoder for PostgreSQL feature list
  8. ^ Via reverse and forward engineering; i.e. cannot set options such as the database encoding
  9. ^ Via reverse engineering
  10. ^ QweryBuilder - Object Browser
  11. ^ QweryBuilder - Auto Complete
  12. ^ SQL Developer 2.3.0 mixes up PostgreSQL indexes as tables
  13. ^ 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
  14. ^ a b SQL Edge can create and drop tables, edit table data, but cannot alter table structure
  15. ^ 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."
  16. ^ can manage its own users, which override the DBMS users
  17. ^ dbForge Studio features matrix
  18. ^ With the Database Comparer application from the Studio suite
  19. ^ Can import SQL via "Reverse Engineer - SQL Script"
  20. ^ a b title= Navicat feature matrix
  21. ^ QweryBuilder - Visual Difference
  22. ^ SQL Edge - Model Perspective screenshots
  23. ^ Individual table permissions can be applied from the Permissions tab of each table
  24. ^ the CRUD interface created includes a search form
  25. ^ Via SQL scripts for dropping and creating, which must be executed outside DeZign for Databases
  26. ^ With the SQL Query application from the Studio suite
  27. ^ QweryBuilder - Graphic Query Window
  28. ^ RazorSQL - SQL Query Builder
  29. ^ SQL query wizard
  30. ^ SQL Maestro query builder
  31. ^ SQLYog query builder
  32. ^ SQLYog schema designer
  33. ^ Only incremental, by manually going through each table and clicking "Add to graph"
  34. ^ Generated SQL must be executed outside Toad Data Modeler

External links


Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать реферат

Look at other dictionaries:

  • Database administration and automation — Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM DB2 and Microsoft SQL Server need ongoing management. As such, corporations that use… …   Wikipedia

  • Database Deployment Manager — Developer(s) The Unauthorized Frog project Stable release 0.1e Operating system Windows 2000, XP and Vista, Linux License …   Wikipedia

  • Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… …   Wikipedia

  • Comparison of data modeling tools — This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment. General Tool Creator Target… …   Wikipedia

  • Comparison of relational database management systems — Programming language comparisons General comparison Basic syntax Basic instructions Arrays Associative arrays String operations …   Wikipedia

  • Comparison of object-relational database management systems — The following Database Management Systems (DBMSs) have at least some object relational features. They vary widely in their completeness and the approaches taken. The following tables compare general and technical information for a number of… …   Wikipedia

  • Comparison microscope — A B Two identical microscopes C C Specimens to compare D Comparison eyepiece (optical bridge) A comparison microscope is a device used to analyze side by side specimens. It consists of two microscopes connected by an optical bridge, which results …   Wikipedia

  • EMS Database Management Solutions — [http://www.sqlmanager.net EMS Database Management Solutions] Information Technology Company, one of its activity fields is software development. Since 1999, EMS Database Management Solutions has concentrated on producing SQL tools and utility… …   Wikipedia

  • Comparison of EDA software — Comparison of Electronic Design Automation (EDA) software Contents 1 Free and Open Source Software (FOSS) 2 Proprietary software 3 Comparison of EDA packages 4 See …   Wikipedia

  • List of relational database management systems — See DBMS for a shorter list of “typical”, representative database management systems.Current software*4th Dimension *Adabas D *Alpha Five *Apache Derby *CA Datacom *CSQL *Daffodil database *Dataphor *DB2 *Derby aka Java DB *EnterpriseDB… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”