Comparison of Database tools

In 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)ProprietaryYesNoNoYesYesYesYesYesSAP, Firebird, Advantage Database, MS Access, MS ExcelC#
ACDB[3]Electronic Experience2.0.1 (2010-04-25)?ProprietaryYesYesYesYesYesJava
AdminerJakub Vrána3.3.3 (2011-08-12)none distributedApache license or GPLYesYesYesYesYesYesYesYesphp
Advanced Query Tool (AQT)Cardett Associates Ltd[4]8.2.8 (2009-08-31)8.2.8 (2009-08-31)ProprietaryYesNoNoYesYesYesYesYesC++
Aqua Data Studio[5]AquaFold, Inc.9.0.0 (2010-10-04)?ProprietaryYesYesYesYesYesYesYesYesYesIBM DB2 iSeries, DB2 LUW, IBM DB2 z/OS, Netezza, Sybase ASE, Sybase Anywhere, Sybase (IQ), Teradata, Aster Data Systems (nCluster), Informix, Apache DerbyJava
ARMS[6]NovaQuantum1.0.2 (2010-03-10)1.0.2 (2010-03-10)ProprietaryYesYesYesYesJavaScript / PHP
Caché Monitor[7]Andreas Schneider20092009?YesYesYesInterSystems CachéJava
Chive (Software)Fusonic0.3.0?GPLYesYesYesYesphp
CompareDataZidsoft20082008ProprietaryYesNoNoYesC++
DaDaBIKEugenio Tacchini4.3 (2010-12-08)4.4 alpha (2010-02-02)GPLYesYesYesYesYesYesYesNoNoYesphp
Data Analyst Toolkit[8]LiveMeta1.1.0.3 (209-09-22)1.1.0.3 (2009-09-22)FreewareYesNoNoYesYesYesYesYesDB2 - All versions zOs and UDB, Any DB with an ODBC DriverC#
Data Visualization[9]Adam Witkowski1.1 (2011-11-27)Not AvailableFreewareYesYesYesYesYesYesYesYesYesFirebird, IBM DB2, Interbase, Amazon SimpleDB, Sybase, KDB_(database)Java
Database Deployment ManagerThe Unauthorized Frog projectv0.1a (2010-10-14)?LGPLYesNoYesYesQt/C++
Database Master with LINQ[10]Nucleon Softwarev3.0 (2010-06-15)?ProprietaryYesNoNoYesYesYesYesYesNoYesMongoDB, SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, Ingres (database), Firebird, SQLite, EffiProz, XML File, ODBC, OleDb, MS Access Netezza.Net / C#
DatabaseSpyAltovav2010r3 (2009-05-05)?ProprietaryYesNoNoYesYesYesYesIBM DB2, Sybase, MS AccessC++
Database Workbench[11]Upscene Productionsv4.2.1 (2012-02-09)?ProprietaryYesNoNoYesYesNoYesYesNoNoInterBase, Sybase SQL Anywhere, Firebird, NexusDBDelphi
DataFlyer[12]Alvila Systems2.0?ProprietaryYesNoYesYesYesYesYesYesYesIBM DB2 , Apache Derby , HSQLDB , MS ExcelJava
DatAdmin[13]JenaSoft3.6.3 (2010-05-18)3.7.3 (2010-05-16)ProprietaryYesNoNoYesYesYesYesMS AccessC#
DataGlass[14]Impathic3.0 (2010-12-04)?ProprietaryNoiOS (iPhone, iPad, iPod Touch)NoYesYesYesYesMicrosoft Access, IBM DB2, Sybase ASEObjective-C
DBeauty[15]DBeauty1.0 (2011-08-15)1.0 (2011-08-15)Apache 2.0YesYesYesYesYesYesYesYesJDBCJava
DBEditJef Van Den Ouweland2.4 (2011-03-18)?GPLYesYesYesYesYesYesYesNoYesYesIBM DB2, HSQLDB, Apache Derby, H2Java
dbForge SQL CompleteDevart2.00 (2011-21-01)2.00.46 (2011-24-01)Freeware and ProprietaryYesNoNoNoNoNoYesC#
dbForge Studio for MySQLDevart4.50 (2010-06-21)?ProprietaryYesNoNoYesC#
DBMan[16]SQLEXEC LLC5.0 (2009-10-01)5.0 (2009-10-01)?YesNoNoYesYesYesYesYesDB2, Sybase (ASE/ASA), MS Access, FirebirdPowerBuilder/C++
DbNinja[17]Vayer Software Ltd.1.0.1 (2010-01-01)?ProprietaryYesYesYesYes?
DbSchema[18]Wise Coders Solutions[19]5.1.2 (2008-08-13)?ProprietaryYesYesYesYesYesYesYesYesYesJava
DBTyp.NET[20]BYPsoft20072008ProprietaryYesNoNoYesYesYesC#
DbVisualizer[21]DbVis Software8.0 (2011-06-16)?ProprietaryYesYesYesYesYesYesYesYesYesYesIBM DB2, Sybase ASE, Informix, Apache Derby, Mimer SQL, HP Neoview, H2Java
Debugger for MySQL[22]MyDebugger.com1.2 (2010-06-02)1.2 (2010-06-02)ProprietaryYesNoNoYesEmbarcadero Delphi
Devgems Data ModelerDevgems1.0.0 (2009-04-30)?ProprietaryYesNoNoYesInterBase, FirebirdEmbarcadero Delphi
Dezign for DatabaseDatanamic6.3.3 (2011-06-01)?ProprietaryYesNoNoYesYesYesYesInterBase, IBM DB2, Firebird, MS Access, Paradox, dBase, Pervasive, Informix, Clipper, Foxpro, Sybase, ElevateDB, NexusDB, DBISAM, SqliteEmbarcadero Delphi
DreamCoder[23]DreamCoder for MySQL/Oracle/PostgreSQL5.1.1 (2008-04-04)?ProprietaryYesNoNoYesYesYes?
Embarcadero DBArtisanEmbarcadero Technologies9.0.19.1ProprietaryYesNoNoYesYesYesYesYesDB2, Sybase ASEC++ Java
EMS SQL Management StudioSQLManager.net1.1.01 (2007-12-13)?ProprietaryYesYesYesYesYesYesYesDB2, InterBase/Firebird?
EpictetusAntilogic Software?1.0 (2009-06-17)ProprietaryYesYesYesYesYesYesSybase, InterBase/Firebird, H2, HSQLDBJava
ERwin Data Modelerca.com7.3?ProprietaryYesYesYesYesYesYesYesYesMS Access, DB2, Foxpro, Informix, Ingres, Sybase, Teradata?
ESF Database Migration ToolkitEasyFrom Inc6.0.21 (2009-06-05)?ProprietaryYesNoNoYesYesYesYesYesIBM DB2, MS Access, MS Excel, Firebird, Interbase, Foxpro, dBase, CSV/Text, any ODBCC++
Happy FishAutomatisering Polderij4.0.1 (2008-05-24)??YesNoNoYesBorland Delphi
HeidiSQLHeidiSQL4.0 (2009-04-30)5.0 Beta (2010-01-30)GPLYesYesYesYesEmbarcadero Delphi
Jailer[24]Jailer3.5.6 (2011-06-07)3.5.6 (2011-06-07)Apache 2.0YesYesYesYesYesYesYesYesJDBCJava
MaatkitBaron Schwartz5247 (2010-06-01)?GPLYesYesYesYesPerl
MicroOLAP Database DesignerMicrOLAP1.2.3 (2008-02-01)1.2.4-beta (2008-05-09)ProprietaryYesNoNoYesYes?
My Database OnLine[25]DataCast Technologies Inc.1.4 (2007-06-22)1.4 (2007-06-22)ProprietaryYesYesYesYesYesYesYesYesYesYesMixed
Microsoft SQL Server Management StudioMicrosoft??ProprietaryYesNoNoYes.Net
ModelRightModelRight3.63.7ProprietaryYesNoNoYesYesYesYesSQL Server, Oracle, MySQL, PostgreSQL, DB2, DB2/zOS, MS AccessC++
MyOraJayam Systems LLC1.0.4 (2010-04-09)?ProprietaryYesNoNoYesJava
MyQuery Builder[26]MyQuery Builder]2.0.4 (2011-08-04)2.0.4 (2011-08-04)ProprietaryYesYesYesYesPHP
MySql Lite AdministratorVladimir Carrer?0.8 (2008-06-11)GPLYesYesYesYesphp
MySQL WorkbenchOracle Corporation5.2.35 (2011-09-23) ?GPLYesYesYesYesC++/C# Objective-C
NavicatNavicat9.0.10 (2010-06-23)9.0.10 (2010-06-23)ProprietaryYesYesYesYesYesYesYesYesYesBorland Delphi Objective-C
Nob Hill Database Compare[27]Nob Hill Software1.3.01?ProprietaryYesNoNoYesYes.net
Online Data Modeler[28]JenaSoft1.0.01.0.0ProprietaryYesYesYesYesYesYesYesYesEffiProzJavaScript, ASP.NET
Oracle Enterprise ManagerOracle Corp.10gR5(2009-03-03)?ProprietaryYesNoYesYesYesYesDB2, Sybase, TimesTenJava
Oracle SQL DeveloperOracle Corp.2.1.1 (1 March 2010)3.0 early adopterProprietaryYesYesYesYesYesNoYesYesYesMicrosoft Access, Sybase, DB2, TeradataJava
OraDeveloper StudioDevart2.55 (2007-11-28)?ProprietaryYesNoNoYesC#
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.14.0 (2011-09-12)?Artistic LicenseYesYesYesYesC++
phpliteadminDane Iracleous1.6 (2011-3-15)?GPLNoNoNoNoNoNoNoNoNoYesphp
phpMSAdminAdam Voigt0.18 (2006-07-23)?GPLYesYesYesYesphp
phpMyAdminphpMyAdmin Development Team3.4.2 (2011-06-07)?GPLYesYesYesYesDrizzle, MariaDBphp
phpPgAdminThe phpPgAdmin Project4.2.3 (2010-03-29)?GPLYesYesYesYesphp
PL/SQL Developer[29]Allround Automations8.0.0 (2009-08-24)8.0.0 (2009-08-24)ProprietaryYesNoNoYesEmbarcadero Delphi
QuantumDB[30]Julen Parra3.3.3 (2009-08-27)?GPLYesYesYesYesYesJava
QweryBuilder[31]Werysoft7.1.0 (2011-11-12)7.1.0 (2011-11-12)ProprietaryYesNoNoYesYesYesSybase, SQL Anywhere?
RazorSQL[32]Richardson Software, LLC[33]5.1.2 (2010-04-14)?ProprietaryYesYesYesYesJava
SchemaBankEzenso Limited??SaaSYesYesYesYesYes?
Silver Sash Administrator[34]silversash.com1.0.1?ProprietaryYesYesYesYesJava
SQL Buddy[35]?1.3.3 (2011-01-18)?MITYesYesYesNoYesYesphp
SQL Developer[36]Jan Borchers2.3.0?ProprietaryYesYesYesYesJava
SQL Edge[37]Bay Breeze Software, Inc.3.3?ProprietaryYesYesYesYesYesYesYesYesDB2, Sybase, MaxDBJava
SQL MaestroSQL Maestro GroupvariousvariousEULAYesNoNoYesYesYesYesYesYesDB2, Firebird, MS AccessEmbarcadero Delphi
SQL NavigatorQuest Software6.1.1
(2009-02-17)		6.2ProprietaryYesNoNoYesEmbarcadero Delphi
SQL Server Comparison Expert[38]DatabaseComparer Ltd.2.41 (2010-01-23)2.41 (2010-01-23)ProprietaryYesNoNoYesC++
SQLDetectiveConquest Software Solutions4.3.1 (2009-04-07)4.3.1 (2009-04-07)ProprietaryYesNoYesYesEmbarcadero Delphi
SQLPro SQL ClientVive1.4 (2008-02-04)?ProprietaryYesNoNoYesYesYesYesYesC++
SQLWavenerocode5.7.2Not AvailableProprietaryYesNoNoYes?
SQLyogWebyog Softworks Pvt. Ltd.9.2?GPLv2YesYesYesYesC++
SQuirreL SQL?3.1.2 (2010-12-31)?GPLYesYesYesYesYesYesYesYesYesAccess,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 SoftwareVariousBetasProprietaryYesNoNoYesYesYesYesDB2, SybaseEmbarcadero Delphi, C#.NET
Toad Data ModelerQuest Software3.3.8 (2009-03-05)Betas[39]Freeware and ProprietaryYesNoNoYesYesYesYesDB2, MS Access, SybaseEmbarcadero Delphi
TOraCommunity2.1.3 (2010-09-19) ?GPLYesYesYesYesYesYesTeradataC++/Qt
WWW SQL DesignerOndřej Žára2.3.2 (2009-01-07)?GPLYesYesYesYesYesYesYesJavaScript

Features:
Legend
  •     Create/alter table:
  1.         Yes - can create table, alter its definition and data, and add new rows
  2.         Some - can only create/alter table definition, not data
  •     Browse table:
  1.         Yes - can browse table definition and data
  2.         Some - can only browse table definition
  •     Multi-server support:
  1.         Yes - can manage from the same window/session multiple servers
  2.         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[5]desktopYesYesYesYesYesYesYesYesYesYesYes
ARMS[6]Browser-basedYesYesYesYesYesYesYesYesNoNoYes
Caché Monitor[7]desktopNoYesNoYesYesYesYesYesYesYes?
ChiveBrowser-basedYesYesYesYesYesYesYesYesNoYes?
DaDaBIKBrowser-basedNoSome[40]NoNoNoSome[41]NoNoNoNoNo
Data Visualization[9]desktopNoNoNoNoYesYesNoNoYesYesYes
Database Master with LINQ[10]desktopYesYesYesYesYesYesYesYesYesYesYes
Database Workbench[11]desktopYesYesYesYesYesYesYesYesYesYesYes
DatAdmin[13]desktopYesYesYesYesYesYesYesYesNoYesYes
DataGlass[14]mobile (iOS)NoNoNoNoYesYesNoNoNoNoYes
DataFlyer[12]desktop????YesYes?????
DBeauty[15]desktopNoNoNoNoYesYesNoNoYesYes?
DBEditdesktopNoNoNoNoYesYesYesNoNoYesNo
dbForge Studio for MySQLTDIYesYesYesYesYesYesYesYesYesYesYes
DBMan[16]desktopYesYesYesYesYesYesYesYesNoNo?
DbNinja[17]Browser-basedYesYesYesYesYesYesYesYesYesYesYes
DbSchema[18]desktopYesYesYesYesYesYesYesYesYesYes?
DbVisualizer[21]desktopYesYesYesYesYesYesYesYesYesYesYes
Debugger for MySQL[22]desktopNoNoYesNoNoNoYesNoYesYesSome
Devgems Data ModelerdesktopYesYesYesYesYesYesYesYesNoYes?
DeZign for DatabasesdesktopYesSomeYesYesYesSomeYesYesNoYes?
DreamCoder[23]desktop????YesYesYesYesYes[23]Yes?
Embarcadero DBArtisandesktopYesYesYesYesYesYesYesYesNoYes?
EMS SQL Management StudiodesktopYesYesYesYesYesYesYesYesYesYesYes
EpictetusdesktopNoYesNoNoYesYesYesYesYesYes?
Happy FishdesktopSome[42]Some?YesSome[43]Some?YesNoYes?
Jailer[24]desktopNoNoNoNoYesYesNoNoYesYes?
jfacedbcdesktop???????????
MicroOLAP Database DesignerdesktopYesSomeYesYesYesSomeYesYesNoYes?
Microsoft SQL Server Management StudiodesktopYesYesYesYesYesYesYesYesNoYesYes
ModelRightdesktopYesYesYesYesYesYesYesYesNoYes?
MyQuery Builder[26]Browser-basedNoNoNoNoYesYesNoNoNoNoYes
MySql Lite AdministratorBrowser-basedNoNoNoNoYesYesNoNoNoNo?
NavicatdesktopYesYesYesYesYesYesYesYesYesYesYes
Online Data Modeler[28]Browser-basedNoYesYesYesYesNoNoNoNoYes?
Oracle Enterprise ManagerBrowser-basedYesYesYesYesYesYesYesYesYesYes?
Oracle SQL DeveloperdesktopNoYesYesYesYesYesYesYesNoYesYes
OraDeveloper StudioTDIYesYesYesYesYesYesYesYesYesYes?
OrbadadesktopYesYesYesYesYesYesYesYesYesYesYes
pgAdmin IIITDIYesYesYesYesYesYesYesYesYesYes
phpliteadminBrowser-basedYesYesNoNoYesYesNoNoNoNo?
phpMSAdminBrowser-based???????????
phpMyAdminBrowser-basedYesYesYesNoYesYesYesYesNoYesYes
phpPgAdminBrowser-based???????????
PL/SQL Developer[29]desktopYesYesYesYesYesYesYesYesYesYes?
QuantumDB[30]desktop????YesYes??NoYes?
QweryBuilder[31]desktopNoNoNoNoYes[44]YesYesYesYes[45]YesYes 
RazorSQL[32]desktop???????????
SchemaBankBrowser-basedYesYesYesYesNoNoNoNoNoNoNo
Silver Sash Administrator[34]desktopYesYesYesYesYesYesYesYesNoYesYes
SQL Developer[36]desktopYesSome[46]Yes?YesSome[47]Yes?YesYes?
SQL Edge[37]desktopYesSome[48]NoNoYesYesYes[49]Yes[49]NoYes?
SQL MaestroTDIYesYesYesYesYesYesYesYesYesYes?
SQL NavigatordesktopYesYesYesYesYesYesYesYesYesYes?
SQLDetectivedesktopYesYesYesYesYesYesYesYesYesYesNo
SQLyogdesktopYesYesYesYesYesYesYesYesYesYes?
SQuirreL SQLdesktop????YesYes??YesYesSome
SQLPro SQL ClientdesktopNoNoNoNoYesYesYesYesNoYes?
SQLWavedesktop????YesYesYesYes?YesYes
ToaddesktopYesYesYesYesYesYesYesYesYesYes?
Toad Data ModelerdesktopYesYesYesYesSomeSomeSomeSomeNoYes?
TOradesktopNoYesYesNoYesYesYesYesYesYesYes
WWW SQL DesignerBrowser-basedNoSomeNoNoNoNoNoNoNoNo?

Features (Continued)
Legend:
  •     User manager:
  1.         Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
  2.         Some - simple user manager with support for database and schema permissions
  3.         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, CSVSQL script, CSVNoSVN
Altova DatabaseSpyNoNoYesCSV, XMLXML, XML Structure, CSV, HTML, MS ExcelNo?
Aqua Data Studio[5]Yes?YesCSVCSV, SQL; diagram as JPEG, PNGOracle, Sybase, MS SQL Server, IBM DB2(SVN) Subversion (software), (CVS) Concurrent Versions System
ARMS[6]No??SQL scriptSQL scriptNo?
ChiveSome?NoSQL scriptSQL scriptNo?
DaDaBIKSome[50]NoNoNoCSVYesNo
Data Visualization[9]NoNoNoCSV, XLS(X), ODS, XMLPDF, XML, CSV, RTF, MATLAB, TXT, XLS(X), HTML, DOCXNoNo
Database Master with LINQ[10]Yes?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[11]YesNoYesCSV, SQL ScriptXML, DBF, TXT, CSV, SQL Script, Lotus 123, DIFYesNo
DatAdmin[13]NoYesYesSQL script, CSV, HTML, text file using regular expressions, generic XMLSQL script, CSV, HTML, XML, DokuWIKI, MediaWIKI, generic text file, MS ExcelNoNo
DataGlass[14]NoNoNoNoCSVNoNo
DataFlyer[12]No?NoNoCSV , MS ExcelNo?
DBEditNoNoNoNoMS Excel, PDF, Text, SQL scriptNo?
dbForge Studio for MySQLYesYesYesYesCSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML[51]Yes?
<DBMan[16]YesNoYesSQL Script, TXT, CSVTXT, CSV, SQL, PDF, XLS, XML, HTML Table, WK1, WMF, DIF, DBF, ClipboardNoNo
DbNinja[17]YesYesYesSQL script, CSVSQL script, CSVNo?
DbSchema[18]No?YesYesSQL script, CSV, HTML, XML,Diagram as imageNo?
DbVisualizer[21]NoSomeNoYesCSV, HTML, Excel, XML, SQL, text,Diagram in PNG, JPEGNo?
Debugger for MySQL[22]NoNoNoNoNoYesNo
Devgems Data ModelerNoNoNoNoSQL; HTML report; diagram as EMF, BMPNo?
DeZign for DatabasesNoNoYesNoSQL; diagram as EMF, BMP, GIF, JPEG, PNGNo?
DreamCoder[23]NoNoYes[23]Yes[23]Yes[23]No[23]?
EMS SQL Management StudioYes?Yes[52]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[24]NoNoNoSQL scriptSQL script (topologically sorted), XML, DBUnit-XMLNo?
jfacedbc?????No?
MicroOLAP Database DesignerNo?NoSome[53]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[26]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[54])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[54])YesNo
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 IIIYesYesNoNoCSV, 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[29]YesYesYesDump, SQLCSV, TSV, XML, SQL, HTML, MS ExcelYesMicrosoft Visual SourceSafe, Merant PVCS, MKS Source Integrity
QuantumDB[30]????CSV, XMLNo?
QweryBuilder[31]NoNoYes[55]YesYesYesNo
RazorSQL[32]?????No?
SchemaBankSomeSomeYesSQL scriptSQL script, HTML report, diagram as PNGNoYes
SQL Developer[36]NoYesYesclipboardSQL, CSV, XML, HTML; diagram as PNG, SVGNo?
SQL Edge[37]No?NoNodata as CSV or Tab-delimited; diagram as GIF, JPEG, PNG or SVG[56]No?
SQL MaestroYes[57]??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
WWW SQL DesignerNoNoNoNoSQLNo?

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
  1.         Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
  2.         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
  1.         Yes - can update user-selected entities
  2.         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[5]YesYesSomeNo?
ARMS[6]YesNoNoNoNo
ChiveNoNoNoNoNo
DaDaBIKSome[58]NoNoNoNo
Database Master with LINQ[10]YesYesYesYesYes
Database Workbench[11]YesYesYesYesYes
DatAdmin[13]YesYesYesYesNo
DataGlass[14]YesNoNoNoNo
DBEditNoNoNoNoNo
dbForge Studio for MySQLYesYesYesYesYes
DBMan[16]NoYesYesYesYes
DbNinja[17]YesYesYesNoNo
DbSchema[18]YesYesYesYesYes
DbVisualizer[21]YesYesSomeNoNo
Devgems Data ModelerNoYesYesYesYes
DeZign for DatabasesNoYesYesYes[59]Yes
DreamCoder[23]Yes????
EMS SQL Management StudioYes[60]YesYesNoNo
Happy Fish?YesYesYesYes
Jailer[24]YesYesYesNoNo
jfacedbc?????
MicroOLAP Database DesignerNoYesSomeYes?
ModelRightNoYesYesYesYes
MyQuery Builder[26]YesNoNoNoNo
MySql Lite AdministratorNoNoNoNoNo
NavicatYesYesYesYesYes
Online Data Modeler[28]NoYesYesYesNo
Oracle SQL DeveloperYesYesYesYes?
OraDeveloper StudioYesNoNoNoNo
OrbadaNoNoNoNoNo
pgAdmin IIIYesNoNoNoNo
phpMSAdminNo????
phpMyAdminYesYesYesNoNo
phpPgAdminNoNoNoNoNo
QuantumDB[30]No????
QweryBuilder[31]Yes[61]NoYesNoNo
RazorSQL[32]Yes[62]NoNoNoNo
SchemaBankNoYesYesYesYes
SQL Developer[36]NoYesYesNo[47]No
SQL Edge[37]Some[63]YesYesNo[48]No
SQL MaestroYes[64]YesYesYesNo
SQL NavigatorYesYesYesNo?
SQL Server Management Studio?YesYes??
SQLDetectiveYesNoNoNoNo
SQLPro SQL Client?NoNoNoNo
SQLWave?????
SQLyogYes[65]Yes[66]YesYes?
SQuirreL SQLYesYesYes[67]?No
ToadYesYesYesYes?
Toad Data ModelerNoYesYesYes[68]?
WWW SQL DesignerNoYesNoSomeNo

source: wikipedia
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)