Komputer Sains    
   
Daftar Isi ☛
(Sebelumnya) Comparison of database accessComparison of defragmentation ... (Berikutnya)

Perbandingan -- 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

ProductCreatorLatest stable releaseLatest testing releaseLicenseRuns on WindowsRuns on Mac OS XRuns on LinuxOracleMySQLPostgreSQLSQL ServerODBCJDBCSQLiteOtherProgramming language
ABIS-Query[1]BOS-Software Sarl[2]1.4 (2010-09-22)1.4 (2010-09-22)ProprietaryYesNoNoYesYesYesYesYes  SAP, Firebird, Advantage Database, MS Access, MS ExcelC#
ACDB[3]Electronic Experience2.0.1 (2010-04-25)?DonationwareYesYesYesYesYes      Java
Crudin[4]Smarc\Web Internet Agency8.1 (2012-05-01)?ProprietaryYesYesYesYesYes      PHP
AdminerJakub Vrána3.3.3 (2011-08-12)none distributedApache license or GPLYesYesYesYesYesYesYes  Yes PHP
Advanced Query Tool (AQT)Cardett Associates Ltd[5]8.2.8 (2009-08-31)8.2.8 (2009-08-31)ProprietaryYesNoNoYesYesYesYesYes   C++
Aqua Data Studio[6]AquaFold, Inc.10.0.8 (2011-8-10)?ProprietaryYesYesYesYesYesYesYesYesYes IBM DB2 iSeries, DB2 LUW, IBM DB2 z/OS, Netezza, Sybase ASE, Sybase Anywhere, Sybase (IQ), Teradata, Aster Data Systems (nCluster), Informix, Apache DerbyJava
ARMS[7]NovaQuantum1.0.2 (2010-03-10)1.0.2 (2010-03-10)ProprietaryYesYesYes Yes      JavaScript / PHP
Caché Monitor[8]Andreas Schneider20092009?YesYesYes       InterSystems CachéJava
CAM editor [9]Sourceforge20122012OSL Ver. 3YesYesYesYesYes   Yes SourceforgeJava
Chive (Software)Fusonic0.3.0?GPLYesYesYes Yes      PHP
CompareDataZidsoft20082008ProprietaryYesNoNo    Yes   C++
DaDaBIKEugenio Tacchini4.4 (2012-04-03)?ProprietaryYesYesYesYesYesYesYesNoNoYes PHP
Data Analyst Toolkit[10]LiveMeta1.1.0.3 (209-09-22)1.1.0.3 (2009-09-22)FreewareYesNoNoYesYesYesYesYes  DB2 - All versions zOs and UDB, Any DB with an ODBC DriverC#
Data Visualization[11]Adam Witkowski4.0 (2013-02-03)Not AvailableFreewareYesYesYesYesYesYesYesNoYesYesFirebird, IBM DB2, Interbase, Amazon SimpleDB, Sybase, Hsqldb, Apache derby, KDB (database)Java
Database Deployment ManagerThe Unauthorized Frog projectv0.1i (2012-05-29)?LGPLYesNoYes Yes      Qt/C++
Database Master with LINQNucleon Softwarev5.0 (2012-09-01)?ProprietaryYesNoNoYesYesYesYesYesNoYesMongoDB, SQL Server, SQL Azure, Oracle, MySQL, PostgreSQL, DB2, Informix, Ingres (database), Firebird, SQLite, EffiProz, XML File, ODBC, OleDb, MS Access Netezza.Net / C#
DatabaseSpyAltovav2010r3 (2009-05-05)?ProprietaryYesNoNoYesYesYesYes   IBM DB2, Sybase, MS AccessC++
Database Workbench[12]Upscene Productionsv4.2.1 (2012-02-09)?ProprietaryYesNoNoYesYesNoYesYesNoNoInterBase, Sybase SQL Anywhere, Firebird, NexusDBDelphi
DataFlyer[13]Alvila Systems2.0?ProprietaryYesNoYesYesYesYesYes YesYesIBM DB2, Apache Derby, HSQLDB, MS ExcelJava
DatAdmin[14]JenaSoft3.6.3 (2010-05-18)3.7.3 (2010-05-16)ProprietaryYesNoNo YesYesYes  YesMS AccessC#
DataGlass[15]Impathic3.0 (2010-12-04)?ProprietaryNoiOS (iPhone, iPad, iPod Touch)NoYesYesYesYes   Microsoft Access, IBM DB2, Sybase ASEObjective-C
DBConvert migration software[16]DMSoft Technologies20122012ProprietaryYesNoNoYesYesYesYesNoNoYesMS Access, MS Excel, IBM DB2, Foxpro, Firebird, InterBaseC++ / MFC
DBeauty[17]DBeauty1.0 (2011-08-15)1.0 (2011-08-15)Apache 2.0YesYesYesYesYesYesYesYes  JDBCJava
DBeaver[18]Serge Rieder2.0.3 (2012-11-28)2.0.3 (2012-11-28)GPLYesYesYesYesYesYesYesYesYesYesAccess, Apache Derby, Firebird, HSQLDB, H2 (DBMS), IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, Mimer SQL, Oracle, SAPDB, Sybase, any JDBC compliant data source.Java
DBEditJef Van Den Ouweland2.4 (2011-03-18)?GPLYesYesYesYesYesYesYesNoYesYesIBM DB2, HSQLDB, Apache Derby, H2Java
dbForge SQL CompleteDevart3.5 (2012-02-02)3.5.6 (2012-04-10)Freeware and ProprietaryYesNoNoNoNoNoYes    C#
dbForge Studio for MySQLDevart5.0 (2011-04-19)5.0.72 (2012-04-23)ProprietaryYesNoNo Yes      C#
dbForge Studio for OracleDevart3.1 (2011-12-06)3.1.196 (2012-04-23)ProprietaryYesNoNoYes       C#
DBMan[19]SQLEXEC LLC5.0 (2009-10-01)5.0 (2009-10-01)?YesNoNoYesYesYesYesYes  DB2, Sybase (ASE/ASA), MS Access, FirebirdPowerBuilder/C++
DbNinja[20]Vayer Software Ltd.1.0.1 (2010-01-01)?ProprietaryYesYesYes Yes      ?
DbSchema[21]Wise Coders Solutions[22]6.1 (2012-03-20)?ProprietaryYesYesYesYesYesYesYesYesYesYesMySQL, Sybase ASE, Informix, Apache Derby, Mimer SQL, IBM DB2, H2, Oracle, Vertica, Postgres, Sqlite, MS SQL, Firebird, Ingres, Cache DB, and more...Java
DBStudio[23]VLINX3.6.1 (2012-06-20)?ProprietaryYesYesYesYesYesYesYesNoYesYesMySQL, IBM DB2, H2, database, Postgres, Sqlite, MS SQL], and more...Java
DBTyp.NET[24]BYPsoft20072008ProprietaryYesNoNoYesYes Yes    C#
dbTrends for Oracle[25]spViewer Software1.1 (2013-02-21)2012ProprietaryYesNoNoYesNoNoNo   Supported Oracle versions 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0C++
DbVisualizer[26]DbVis Software9.0 (2012-11-29)?ProprietaryYesYesYesYesYesYesYesYesYesYesIBM DB2, Sybase ASE, Informix, Apache Derby, Mimer SQL, HP Neoview, H2Java
Debugger for MySQL[27]MyDebugger.com1.2 (2010-06-02)1.2 (2010-06-02)ProprietaryYesNoNo Yes      Embarcadero Delphi
Devgems Data ModelerDevgems1.0.0 (2009-04-30)?ProprietaryYesNoNo   Yes   InterBase, FirebirdEmbarcadero Delphi
Dezign for DatabaseDatanamic6.3.3 (2011-06-01)?ProprietaryYesNoNoYesYesYesYes   InterBase, IBM DB2, Firebird, MS Access, Paradox, dBase, Pervasive, Informix, Clipper, Foxpro, Sybase, ElevateDB, NexusDB, DBISAM, SqliteEmbarcadero Delphi
DreamCoder[28]DreamCoder for MySQL/Oracle/PostgreSQL5.1.1 (2008-04-04)?ProprietaryYesNoNoYesYesYes     ?
DreamCoder[28]DreamCoder for MySQL/Oracle/PostgreSQL5.1.1 (2008-04-04)?ProprietaryYesNoNoYesYesYes     ?
DtSQL - Universal Database Tools[29]DigerTech Inc2.1.1 (2013-02-02)2.1.1 (2013-02-02)FreeYesNoNoYesYesYesYesYesYesYesApache Derby, Cache Database, Firebird, FrontBase, H2, HSQLDB, IBM DB2, Informix, Ingres (database), JDatastore, MaxDB, Mimer SQL, Microsoft SQL Server, Mckoi SQL Database, MySQL, Oracle, PointBase, PostgreSQL, Solid, SQLite, Sybase ASE, Sybase AnywhereJava
Embarcadero DBArtisanEmbarcadero Technologies9.0.19.1ProprietaryYesNoNoYesYes YesYesYes DB2, Sybase ASEC++ Java
EMS SQL Management StudioSQLManager.net1.1.01 (2007-12-13)?ProprietaryYesYesYesYesYesYesYes   DB2, InterBase/Firebird?
EpictetusAntilogic Software?1.0 (2009-06-17)ProprietaryYesYesYesYes YesYes   Sybase, InterBase/Firebird, H2, HSQLDBJava
ERwin Data Modelerca.com7.3?ProprietaryYesYesYesYesYesYesYesYes  MS Access, DB2, Foxpro, Informix, Ingres, Sybase, Teradata?
ESF Database Migration ToolkitEasyFrom Inc6.0.21 (2009-06-05)?ProprietaryYesNoNoYesYesYesYesYes  IBM DB2, MS Access, MS Excel, Firebird, Interbase, Foxpro, dBase, CSV/Text, any ODBCC++
Happy FishAutomatisering Polderij4.0.1 (2008-05-24)??YesNoNo    Yes   Borland Delphi
HeidiSQLHeidiSQL7.0 (2012-02-12)BetasGPLYesYesYes Yes Yes    Embarcadero Delphi
Jailer[30]Jailer3.5.6 (2011-06-07)3.5.6 (2011-06-07)Apache 2.0YesYesYesYesYesYesYesYes  JDBCJava
MaatkitBaron Schwartz5247 (2010-06-01)?GPLYesYesYes Yes      Perl
MicroOLAP Database DesignerMicrOLAP1.2.3 (2008-02-01)1.2.4-beta (2008-05-09)ProprietaryYesNoNo YesYes     ?
My Database OnLine[31]DataCast Technologies Inc.1.4 (2007-06-22)1.4 (2007-06-22)ProprietaryYesYesYesYesYesYesYesYesYesYes Mixed
Microsoft SQL Server Management StudioMicrosoft??ProprietaryYesNoNo   Yes    .Net
ModelRightModelRight3.63.7ProprietaryYesNoNoYesYes YesYes  SQL Server, Oracle, MySQL, PostgreSQL, DB2, DB2/zOS, MS AccessC++
MyOraJayam Systems LLC1.0.4 (2010-04-09)?ProprietaryYesNoNoYes       Java
MyQuery Builder[32]MyQuery Builder]2.0.4 (2011-08-04)2.0.4 (2011-08-04)ProprietaryYesYesYes Yes      PHP
MySql Lite AdministratorVladimir Carrer?0.8 (2008-06-11)GPLYesYesYes Yes      PHP
MySQL WorkbenchOracle Corporation5.2.47 (2013-02-15) ?GPLYesYesYes Yes      C++/C# Objective-C
NavicatNavicat10.1.5 (2012-08-23)10.1.5 (2012-08-23)ProprietaryYesYesrequires WineYesYesYesYesYes Yes Borland Delphi Objective-C
Navicat Data ModelerNavicat1.0.5 (2012-08-23)1.0.5 (2012-08-23)ProprietaryYesYesYesYesYesYesYesYes Yes Borland Delphi Objective-C
Nob Hill Database Compare[33]Nob Hill Software1.3.01?ProprietaryYesNoNo Yes Yes    .net
Online Data Modeler[34]JenaSoft1.0.01.0.0ProprietaryYesYesYesYesYesYesYes  YesEffiProzJavaScript, ASP.NET 
Oracle Enterprise ManagerOracle Corp.10gR5(2009-03-03)?ProprietaryYesNoYesYesYes Yes   DB2, Sybase, TimesTenJava
Oracle SQL DeveloperOracle Corp.2.1.1 (1 March 2010)3.0 early adopterProprietaryYesYesYesYesYesNoYesYesYes Microsoft Access, Sybase, DB2, TeradataJava
OrbadaAndrzej Ka?u?a1.0.4.109 (2011-02-08)1.0.4.109 (2011-02-08)GPLYesYesYesYesYesYesYesYesYesYesFirebird, HSQL, Interbase, Derby all with JDBC driverJava
pgAdmin IIIpgAdmin Development Team1.16.1 (2012-12-06)?PostgreSQL LicenseYesYesYes  Yes     C++
phpLiteAdminDane Iracleous1.9.2 (2012-5-31)?GPLYesYesYesNoNoNoNoNoNoYes PHP
phpMSAdminAdam Voigt0.18 (2006-07-23)?GPLYesYesYes   Yes    PHP
phpMyAdminphpMyAdmin Development Team3.5.2 (2012-07-07)noneGPLYesYesYes Yes     Drizzle, MariaDBphp
phpPgAdminThe phpPgAdmin Project5.0.4 (2012-03-22)?GPLYesYesYes  Yes     php
PL/SQL Developer[35]Allround Automations10.0.1 (2013-03-08)10.0.1 (2013-03-08)ProprietaryYesNoNoYes       Embarcadero Delphi
QuantumDB[36]Julen Parra3.3.3 (2009-08-27)?GPLYesYesYes  Yes  Yes  Java
QweryBuilder[37]Werysoft7.1.0 (2011-11-12)7.1.0 (2011-11-12)ProprietaryYesNoNoYes  YesYes  Sybase, SQL Anywhere?
RazorSQL[38]Richardson Software, LLC[39]5.1.2 (2010-04-14)?ProprietaryYesYesYes     Yes  Java
SchemaBankEzenso Limited??SaaSYesYesYes YesYes     ?
Silver Sash Administrator[40]silversash.com1.0.15?FreewareYesYesYesYes    Yes  Java
SQL Buddy[41]?1.3.3 (2011-01-18)?MITYesYesYesNoYes   Yes  php
SQL Developer[42]Jan Borchers2.3.0?ProprietaryYesYesYes     Yes  Java
SQL Edge[43]Bay Breeze Software, Inc.3.3?ProprietaryYesYesYesYesYesYesYes Yes DB2, Sybase, MaxDBJava
SQL MaestroSQL Maestro GroupvariousvariousEULAYesNoNoYesYesYesYesYes YesDB2, Firebird, MS AccessEmbarcadero Delphi
SQL NavigatorQuest Software6.1.1
(2009-02-17)		6.2ProprietaryYesNoNoYes       Embarcadero Delphi
SQL Server Comparison Expert[44]DatabaseComparer Ltd.2.41 (2010-01-23)2.41 (2010-01-23)ProprietaryYesNoNo   Yes    C++
SQLDetectiveConquest Software Solutions4.3.1 (2009-04-07)4.3.1 (2009-04-07)ProprietaryYesNoYesYes       Embarcadero Delphi
SQLPro SQL ClientVive1.4 (2008-02-04)?ProprietaryYesNoNoYesYesYesYes  Yes C++
SQLTool Pro Database EditorNic Raboy1.3.9 (2013-23-01)?ProprietaryNoNoAndroidYesYesYesYes    Java
SQLWavenerocode5.7.2Not AvailableProprietaryYesNoNo Yes      ?
SQLyogWebyog Softworks Pvt. Ltd.10.2?GPLv2Yesrequires Winerequires Wine Yes      C++
SQuirreL SQLColin Bell, Gerd Wagner, Rob Manning and others3.3.0 (2011-11-20)?GPLv2 & LGPLv2YesYesYesYesYesYesYesYesYes 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
ToadQuest SoftwareVariousBetasProprietaryYesNoNoYesYes YesYes  DB2, SybaseEmbarcadero Delphi, C#.NET
Toad Data ModelerQuest Software3.3.8 (2009-03-05)Betas[45]Freeware and ProprietaryYesNoNoYesYesYesYes   DB2, MS Access, SybaseEmbarcadero Delphi
TOraCommunity2.1.3 (2010-09-19) ?GPLYesYesYesYesYesYes    TeradataC++/Qt
Toolsverse Data ExplorerToolsverse3.1 (2012-12-01) ?LGPL and ProprietaryYesYesYesYesYesYesYesYesYesYesDB2, Sybase Adaptive Server, Informix, Excel, Delimited Text, Fixed Length Text, XMLJava and JavaScript
WWW SQL DesignerOnd?ej ?ára2.3.2 (2009-01-07)?GPLYesYesYes YesYesYes  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
ToolsUser InterfaceCreate & Alter wizardBrowseAuto CompletionSyntax coloredMulti server support
DatabaseTableProcedureTriggerDatabaseTableProcedureTrigger
ABIS-Query[1]desktopNoNoNoNoYesYesYesNoNoYes?
ACDB[3]desktopYesYesYesYesYesYesYesYesYesYes?
AdminerBrowser-basedYesYesYesYesYesYesYesYesNoYes?
Altova DatabaseSpydesktopYesYesYesYesYesYesYesYesYesYesYes
Aqua Data Studio[6]desktopYesYesYesYesYesYesYesYesYesYesYes
ARMS[7]Browser-basedYesYesYesYesYesYesYesYesNoNoYes
Caché Monitor[8]desktopNoYesNoYesYesYesYesYesYesYes?
CAM editor[9]desktopNoNoNoNoYesYesNoNoNoNo?
ChiveBrowser-basedYesYesYesYesYesYesYesYesNoYes?
DaDaBIKBrowser-basedNoSome[46]NoNoNoSome[47]NoNoNoNoNo
Data Visualization[11]desktopNoNoNoNoYesYesYesNoYesYesYes
Database Master with LINQdesktopYesYesYesYesYesYesYesYesYesYesYes
Database Deployment ManagerdesktopYesYesYesYesYesYesYesYesYesYesNo
Database Workbench[12]desktopYesYesYesYesYesYesYesYesYesYesYes
DatAdmin[14]desktopYesYesYesYesYesYesYesYesNoYesYes
DataGlass[15]mobile (iOS)NoNoNoNoYesYesNoNoNoNoYes
DataFlyer[13]desktop????YesYes?????
DBeauty[17]desktopNoNoNoNoYesYesNoNoYesYes?
DBEditdesktopNoNoNoNoYesYesYesNoNoYesNo
dbForge Studio for MySQLTDIYesYesYesYesYesYesYesYesYesYesYes
DBMan[19]desktopYesYesYesYesYesYesYesYesNoNo?
DbNinja[20]Browser-basedYesYesYesYesYesYesYesYesYesYesYes
DbSchema[21]desktopYesYesYesYesYesYesYesYesYesYesYes
DbVisualizer[26]desktopYesYesYesYesYesYesYesYesYesYesYes
Debugger for MySQL[27]desktopNoNoYesNoNoNoYesNoYesYesSome
Devgems Data ModelerdesktopYesYesYesYesYesYesYesYesNoYes?
DeZign for DatabasesdesktopYesSomeYesYesYesSomeYesYesNoYes?
DreamCoder[28]desktop????YesYesYesYesYes[28]Yes?
DtSQL[29]desktopYesYesYesYesYesYesYesYesYes[29]YesYes
Embarcadero DBArtisandesktopYesYesYesYesYesYesYesYesNoYes?
EMS SQL Management StudiodesktopYesYesYesYesYesYesYesYesYesYesYes
EpictetusdesktopNoYesNoNoYesYesYesYesYesYes?
Happy FishdesktopSome[48]Some?YesSome[49]Some?YesNoYes?
Jailer[30]desktopNoNoNoNoYesYesNoNoYesYes?
jfacedbcdesktop???????????
MicroOLAP Database DesignerdesktopYesSomeYesYesYesSomeYesYesNoYes?
Microsoft SQL Server Management StudiodesktopYesYesYesYesYesYesYesYesNoYesYes
ModelRightdesktopYesYesYesYesYesYesYesYesNoYes?
MyQuery Builder[32]Browser-basedNoNoNoNoYesYesNoNoNoNoYes
MySql Lite AdministratorBrowser-basedNoNoNoNoYesYesNoNoNoNo?
NavicatdesktopYesYesYesYesYesYesYesYesYesYesYes
Navicat Data ModelerdesktopNoYesNoYesNoNoNoNoNoNoYes
Online Data Modeler[34]Browser-basedNoYesYesYesYesNoNoNoNoYes?
Oracle Enterprise ManagerBrowser-basedYesYesYesYesYesYesYesYesYesYes?
Oracle SQL DeveloperdesktopNoYesYesYesYesYesYesYesNoYesYes
OraDeveloper StudioTDIYesYesYesYesYesYesYesYesYesYes?
OrbadadesktopYesYesYesYesYesYesYesYesYesYesYes
pgAdmin IIITDIYesYesYesYesYesYesYesYesYesYes 
phpliteadminBrowser-basedYesYesNoNoYesYesNoNoNoNo?
phpMSAdminBrowser-based???????????
phpMyAdminBrowser-basedYesYesYesYesYesYesYesYesNoYesYes
phpPgAdminBrowser-based???????????
PL/SQL Developer[35]desktopYesYesYesYesYesYesYesYesYesYes?
QuantumDB[36]desktop????YesYes??NoYes?
QweryBuilder[37]desktopNoNoNoNoYes[50]YesYesYesYes[51]YesYes
RazorSQL[38]desktop???????????
SchemaBankBrowser-basedYesYesYesYesNoNoNoNoNoNoNo
Silver Sash Administrator[40]desktopYesYesYesYesYesYesYesYesNoYesYes
SQL Developer[42]desktopYesSome[52]Yes?YesSome[53]Yes?YesYes?
SQL Edge[43]desktopYesSome[54]NoNoYesYesYes[55]Yes[55]NoYes?
SQL MaestroTDIYesYesYesYesYesYesYesYesYesYes?
SQL NavigatordesktopYesYesYesYesYesYesYesYesYesYes?
SQLDetectivedesktopYesYesYesYesYesYesYesYesYesYesNo
SQLyogdesktopYesYesYesYesYesYesYesYesYesYes?
SQuirreL SQLdesktop????YesYes??YesYesSome
SQLPro SQL ClientdesktopNoNoNoNoYesYesYesYesNoYes?
SQLWavedesktop????YesYesYesYes?YesYes
ToaddesktopYesYesYesYesYesYesYesYesYesYes?
Toad Data ModelerdesktopYesYesYesYesSomeSomeSomeSomeNoYes?
TOradesktopNoYesYesNoYesYesYesYesYesYesYes
Toolsverse Data Explorerdesktop and Browser-basedYesYesYesYesYesYesYesYesNoYesYes
WWW SQL DesignerBrowser-basedNoSomeNoNoNoNoNoNoNoNo?

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 managerPluginCompareImportExportDebuggerSource control
ABIS-Query[1]No?NoSQL script, ExcelSQL script, Excel multi-sheet, XML, XSDNo?
ACDB[3]Yes?NoSQL scriptSQL scriptOracle, MySQL?
AdminerYesYesYesSQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin)NoGit
Altova DatabaseSpyNoNoYesCSV, XMLXML, XML Structure, CSV, HTML, MS ExcelNo?
Aqua Data Studio[6]Yes?YesCSVCSV, SQL; diagram as JPEG, PNGOracle, Sybase, MS SQL Server, IBM DB2(SVN) Subversion (software), (CVS) Concurrent Versions System
ARMS[7]No??SQL scriptSQL scriptNo?
CAM editorNoNoNoXML, XSD schemaXML, HTML, Spreadsheet, Dictionary, XMI, ModelNoNo
ChiveSome?NoSQL scriptSQL scriptNo?
DaDaBIKSome[56]NoNoNoCSVYesNo
Data Visualization[11]NoNoNoCSV, XLS(X), ODS, XMLPDF, XML, CSV, RTF, MATLAB, TXT, XLS(X), HTML, DOCX, LaTeX, SQL, JSON, YAMLNoNo
Database Master with LINQYes?YesXML Files, CSV, Bulk SQL ScriptSQL Script, MS Excel, MS Word, PDF, RTF, XPS, CSV, HTML, XML, OpenOffice, DBF, Pack&Go Export/Import, ER DiagramNo?
Database Workbench[12]YesNoYesCSV, SQL ScriptXML, DBF, TXT, CSV, SQL Script, Lotus 123, DIFYesNo
DatAdmin[14]NoYesYesSQL script, CSV, HTML, text file using regular expressions, generic XMLSQL script, CSV, HTML, XML, DokuWIKI, MediaWIKI, generic text file, MS ExcelNoNo
DataGlass[15]NoNoNoNoCSVNoNo
DataFlyer[13]No?NoNoCSV, MS ExcelNo?
DBConvert migration software[16]NoNoYesMS Access, MySQL, MS SQL, MS Excel, PostgreSQL, SQLite, Oracle, IBM DB2, Foxpro, Firebird, InterBaseMS Access, MySQL, MS SQL, MS Excel, PostgreSQL, SQLite, Oracle, IBM DB2, Foxpro, Firebird, InterBaseNoNo
DBEditNoNoNoNoMS Excel, PDF, Text, SQL scriptNo?
dbForge Studio for MySQLYesYesYesYesCSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML[57]Yes?
<DBMan[19]YesNoYesSQL Script, TXT, CSVTXT, CSV, SQL, PDF, XLS, XML, HTML Table, WK1, WMF, DIF, DBF, ClipboardNoNo
DbNinja[20]YesYesYesSQL script, CSVSQL script, CSVNo?
DbSchema[21]No?YesYesSQL script, CSV, HTML 4, HTML 5, XML,Diagram as image (Png, Jpg, Gif),No(SVN) Subversion (software)
DbVisualizer[26]NoSomeNoYesCSV, HTML, Excel, XML, SQL, JSON, text,Diagram in PNG, JPEGNo?
Debugger for MySQL[27]NoNoNoNoNoYesNo
Devgems Data ModelerNoNoNoNoSQL; HTML report; diagram as EMF, BMPNo?
DeZign for DatabasesNoNoYesNoSQL; diagram as EMF, BMP, GIF, JPEG, PNGNo?
DreamCoder[28]NoNoYes[28]Yes[28]Yes[28]No[28]?
DtSQL[29]YesYesYes[28]CSV, Excel, SQL, textCSV, HTML, Excel, XML, SQL, textNo?
EMS SQL Management StudioYes?Yes[58]MS Excel/Access/Word, TXT, CSV, DBF, HTML, XML Datapacket, XML Generic, ODF Spreadsheets, ODF TextImported formats plus RTF, PDF, LaTeX, DIF file, SYLK??
EpictetusNoYesNoNoExcelNo?
ESF Database Migration ToolkitYesNoYesAny database/file systemsAny database/file systemsNo?
Happy FishNo?Yes?SQL; diagram as XML, BMP, JPEG, WMFNo?
Jailer[30]NoNoNoSQL scriptSQL script (topologically sorted), XML, DBUnit-XMLNo?
jfacedbc?????No?
MicroOLAP Database DesignerNo?NoSome[59]SQL; HTML report; diagram as BMP, EMF, GIF, JPEG, PNGNo?
ModelRightSomeYesYesYes - from supported databases using native interfaces, or from any ODBC sourceSQL; XML; DTD; Diagram as BMP, JPEGNo?
MyQuery Builder[32]NoNoNoMySQL scriptMySQL scriptNoNo
MySql Lite AdministratorNoNoNoNoNoNo?
NavicatYesNoYesYes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations[60])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[60])YesNo
Navicat Data ModelerNoNoYesYes - Import Database from server/ODBCYes - Export SQLNoNo
Oracle SQL DeveloperYes??YesYesYes?
OraDeveloper StudioYesNoYesNoCSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XMLYes?
OrbadaNoYesYesSQL scriptSQL script, CSV, XML, HTML, PDF, Excel, DBF, DataTextNoNo 
pgAdmin IIIYesYesNoCSV, Text, or binaryCSV, text, HTML, XMLYesNo
phpMSAdmin?????No?
phpMyAdminYesSomeYesYes - CSV, SQL, XML, Excel, ODSYes - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediawikiNoGit
phpPgAdmin?????No?
PL/SQL Developer[35]YesYesYesDump, SQLCSV, TSV, XML, SQL, HTML, MS ExcelYesMicrosoft Visual SourceSafe, Merant PVCS, MKS Source Integrity
QuantumDB[36]????CSV, XMLNo?
QweryBuilder[37]NoNoYes[61]YesYesYesNo
RazorSQL[38]?????No?
SchemaBankSomeSomeYesSQL scriptSQL script, HTML report, diagram as PNGNoYes
SQL Developer[42]NoYesYesclipboardSQL, CSV, XML, HTML; diagram as PNG, SVGNo?
SQL Edge[43]No?NoNodata as CSV or Tab-delimited; diagram as GIF, JPEG, PNG or SVG[62]No?
SQL MaestroYes[63]??MS Excel, MS Access, DBF, XML, TXT, CSVSQL, MS Excel/Access/Word, RTF, HTML, PDF, TXT, CSV, DIF file, SYLK, LaTeX, XML, DBF; diagram in XML formatYes?
SQL NavigatorSomeNoSomeYesYesYesCVS, ClearCase, PVCS, StarTeam, TFS, VSS
SQLDetectiveYesYesYesYesYesYesMicrosoft Visual SourceSafe, Merant PVCS
SQLPro SQL Client?????No?
SQLWave?No?????
SQLyogYes?YesYesYes??
SQL Server Management StudioYes????Yes?
SQuirreL SQL?Yes?Yes?No?
ToadSomeNoYesYesYesYesSVN, CVS, TFS, VSS
Toad Data ModelerNo?YesToad for Oracle ERD, ERWin 7.1(XML) via pluginSQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNGNo?
TOraSomeNoYesYesYesYesNo
TOraSomeNoYesYesYesYesNo
Toolsverse Data ExplorerYesYesNoJDBC compliant database,Excel,SQL,Delimited Text,Fixed Length Text,XML,XML with TransformationJDBC compliant database,Excel,SQL,Delimited Text,Fixed Length Text,XML,XML with TransformationNoNo
WWW SQL DesignerNoYesNo SQLNoNo

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 builderVisual schema/model/E-R diagram designReverse engineeringForward engineeringER diagram groupboxes
ABIS-Query[1]YesNoYesYesNo
ACDB[3]NoYesYesYesYes
AdminerYesYesYesNoNo
Altova DatabaseSpyYesYesYesYes?
Aqua Data Studio[6]YesYesSomeNo?
ARMS[7]YesNoNoNoNo
CAM editorYesYesYesYesNo
ChiveNoNoNoNoNo
DaDaBIKSome[64]NoNoNoNo
Database Master with LINQYesYesYesYesYes
Database Deployment ManagerYesYesYesNoNo
Database Workbench[12]YesYesYesYesYes
DatAdmin[14]YesYesYesYesNo
DataGlass[15]YesNoNoNoNo
DBEditNoNoNoNoNo
dbForge Studio for MySQLYesYesYesYesYes
DBMan[19]NoYesYesYesYes
DbNinja[20]YesYesYesNoNo
DbSchema[21]YesYesYesYesYes
DbVisualizer[26]YesYesSomeNoNo
Devgems Data ModelerNoYesYesYesYes
DeZign for DatabasesNoYesYesYes[65]Yes
DreamCoder[28]Yes????
DtSQL[29]Yes????
EMS SQL Management StudioYes[66]YesYesNoNo
Happy Fish?YesYesYesYes
Jailer[30]YesYesYesNoNo
jfacedbc?????
MicroOLAP Database DesignerNoYesSomeYes?
ModelRightNoYesYesYesYes
MyQuery Builder[32]YesNoNoNoNo
MySql Lite AdministratorNoNoNoNoNo
NavicatYesYesYesYesYes
Navicat Data ModelerNoYesYesYesYes
Online Data Modeler[34]NoYesYesYesNo
Oracle SQL DeveloperYesYesYesYes?
OraDeveloper StudioYesNoNoNoNo
OrbadaNoNoNoNoNo
pgAdmin IIIYesNoNoNoNo
phpMSAdminNo????
phpMyAdminYesYesYesNoNo
phpPgAdminNoNoNoNoNo
QuantumDB[36]No????
QweryBuilder[37]Yes[67]NoYesNoNo
RazorSQL[38]Yes[68]NoNoNoNo
SchemaBankNoYesYesYesYes
SQL Developer[42]NoYesYesNo[53]No
SQL Edge[43]Some[69]YesYesNo[54]No
SQL MaestroYes[70]YesYesYesNo
SQL NavigatorYesYesYesNo?
SQL Server Management Studio?YesYes??
SQLDetectiveYesNoNoNoNo
SQLPro SQL Client?NoNoNoNo
SQLWave?????
SQLyogYes[71]Yes[72]YesYes?
SQuirreL SQLYesYesYes[73]?No
ToadYesYesYesYes?
Toad Data ModelerNoYesYesYes[74]?
Toolsverse Data ExplorerNoNoYesYesNo
WWW SQL DesignerNoYesNoSomeNo

See also

Notes

  1. ^ a b c d ABIS-Query
  2. ^ BOS-Software Sarl
  3. ^ a b c d ACDB
  4. ^ Crudin
  5. ^ Cardett Associates Ltd
  6. ^ a b c d Aqua Data Studio
  7. ^ a b c d ARMS
  8. ^ a b Caché Monitor
  9. ^ a b CAM Editor
  10. ^ Data Analyst Toolkit
  11. ^ a b c Data Visualization
  12. ^ a b c d Database Workbench
  13. ^ a b c DataFlyer
  14. ^ a b c d DatAdmin
  15. ^ a b c d impathic DataGlass
  16. ^ a b DBConvert migration software
  17. ^ a b DBeauty Relational Data Browser
  18. ^ DBeaver
  19. ^ a b c d DBMan
  20. ^ a b c d DbNinja
  21. ^ a b c d DbSchema
  22. ^ Wise Coders Solutions
  23. ^ DBStudio
  24. ^ DBTyp.NET
  25. ^ dbTrends
  26. ^ a b c d DbVisualizer
  27. ^ a b c Debugger for MySQL
  28. ^ a b c d e f g h i j k DreamCoder for PostgreSQL feature list
  29. ^ a b c d e DtSQL - Universal Database Tools
  30. ^ a b c d Database Subsetting and Browsing
  31. ^ My DataBase OnLine
  32. ^ a b c d A MySQL query editor for PHP web developers
  33. ^ Nob Hill Database Compare
  34. ^ a b c Online Data Modeler
  35. ^ a b c PL/SQL Developer
  36. ^ a b c d QuantumDB
  37. ^ a b c d QweryBuilder
  38. ^ a b c d RazorSQL
  39. ^ Richardson Software, LLC
  40. ^ a b Silver Sash Administrator
  41. ^ SQL Buddy
  42. ^ a b c d SQL Developer
  43. ^ a b c d SQL Edge, Bay Breeze Software
  44. ^ SQL Server Comparison Expert
  45. ^ Toad Data Modeler Betas
  46. ^ create CRUD interfaces, so create table data, not table theriselves
  47. ^ browse table data, not table definitions
  48. ^ Via reverse and forward engineering; i.e. cannot set options such as the database encoding
  49. ^ Via reverse engineering
  50. ^ QweryBuilder - Object Browser
  51. ^ QweryBuilder - Auto Complete
  52. ^ SQL Developer 2.3.0 mixes up PostgreSQL indexes as tables
  53. ^ 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
  54. ^ a b SQL Edge can create and drop tables, edit table data, but cannot alter table structure
  55. ^ 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."
  56. ^ can manage its own users, which override the DBMS users
  57. ^ dbForge Studio features matrix
  58. ^ With the Database Comparer application from the Studio suite
  59. ^ Can import SQL via "Reverse Engineer - SQL Script"
  60. ^ a b title= Navicat feature matrix
  61. ^ QweryBuilder - Visual Difference
  62. ^ SQL Edge - Model Perspective screenshots
  63. ^ Individual table permissions can be applied from the Permissions tab of each table
  64. ^ the CRUD interface created includes a search form
  65. ^ Via SQL scripts for dropping and creating, which must be executed outside DeZign for Databases
  66. ^ With the SQL Query application from the Studio suite
  67. ^ QweryBuilder - Graphic Query Window
  68. ^ RazorSQL - SQL Query Builder
  69. ^ SQL query wizard
  70. ^ SQL Maestro query builder
  71. ^ SQLYog query builder
  72. ^ SQLYog schema designer
  73. ^ Only incremental, by manually going through each table and clicking "Add to graph"
  74. ^ Generated SQL must be executed outside Toad Data Modeler

External links

(Sebelumnya) Comparison of database accessComparison of defragmentation ... (Berikutnya)