Anexo:Comparativa de herramientas de bases de datos
Comparación de herramientas de base de datos. La siguiente tabla compara información general y técnica de una variedad de herramientas del administrador de base de datos disponibles. Consultar los artículos de los productos particulares para más información. Este artículo no incluye toda la información disponible ni está necesariamente actualizado.
Información general
Producto | Creador | Última versión estable | Última versión de prueba | Licencia | Se ejecuta en Windows | Se ejecuta en Mac OS X | Se ejecuta en Linux | Oracle | MySQL | PostgreSQL | SQL Server | ODBC | JDBC | SQLite | Otros | Lenguaje de programación | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ABIS-Query[1] | BOS-Software Sarl[2] | 1.4 (2010-09-22) | 1.4 (2010-09-22) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | SAP, Firebird, Advantage Database, MS Access, MS Excel | C# | |||
ACDB[3] | Electronic Experience | 2.0.1 (2010-04-25) | ? | Donationware | ![]() | ![]() | ![]() | ![]() | ![]() | Java | |||||||
Crudin[4] | Smarc\Web Internet Agency | 8.1 (2012-05-01) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | PHP | |||||||
Adminer | Jakub Vrána | 3.3.3 (2011-08-12) | no distribuido | Apache license or GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | php | ||||
Advanced Query Tool (AQT) | Cardett Associates Ltd[5] | 8.2.8 (2009-08-31) | 8.2.8 (2009-08-31) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | C++ | ||||
Aqua Data Studio[6] | AquaFold, Inc. | 10.0.8 (2011-8-10) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | 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[7] | NovaQuantum | 1.0.2 (2010-03-10) | 1.0.2 (2010-03-10) | Propietaria | ![]() | ![]() | ![]() | ![]() | JavaScript / PHP | ||||||||
Caché Monitor[8] | Andreas Schneider | 2009 | 2009 | ? | ![]() | ![]() | ![]() | InterSystems Caché | Java | ||||||||
CAM editor[9] | Sourceforge | 2012 | 2012 | OSL Ver. 3 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Sourceforge | Java | |||||
Chive (Software) | Fusonic | 0.3.0 | ? | GPL | ![]() | ![]() | ![]() | ![]() | php | ||||||||
CompareData | Zidsoft | 2008 | 2008 | Propietaria | ![]() | ![]() | ![]() | ![]() | C++ | ||||||||
DaDaBIK | Eugenio Tacchini | 4.4 (2012-04-03) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | php | ||
Data Analyst Toolkit[10] | LiveMeta | 1.1.0.3 (209-09-22) | 1.1.0.3 (2009-09-22) | Freeware | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2 - All versions zOs and UDB, Any DB with an ODBC Driver | C# | |||
Data Visualization[11] | Adam Witkowski | 4.0 (2013-02-03) | Not Available | Freeware | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Firebird, IBM DB2, Interbase, Amazon SimpleDB, Sybase, Hsqldb, Apache Derby, KDB (database) | Java | |
Database Deployment Manager | The Unauthorized Frog project | v0.1i (2012-05-29) | ? | LGPL | ![]() | ![]() | ![]() | ![]() | Qt/C++ | ||||||||
Database Master with LINQ | Nucleon Software | v5.0 (2012-09-01) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | MongoDB, SQL Server, SQL Azure, 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) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | IBM DB2, Sybase, MS Access | C++ | ||||
Database Workbench[12] | Upscene Productions | v4.2.1 (2012-02-09) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | InterBase, Sybase SQL Anywhere, Firebird, NexusDB | Delphi | |
DataFlyer[13] | Alvila Systems | 2.0 | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | IBM DB2, Apache Derby, HSQLDB, MS Excel | Java | ||
DatAdmin[14] | JenaSoft | 3.6.3 (2010-05-18) | 3.7.3 (2010-05-16) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | MS Access | C# | ||||
DataGlass[15] | Impathic | 3.0 (2010-12-04) | ? | Propietaria | ![]() | iOS (iPhone, iPad, iPod Touch) | ![]() | ![]() | ![]() | ![]() | ![]() | Microsoft Access, IBM DB2, Sybase ASE | Objective-C | ||||
DBConvert migration software[16] | DMSoft Technologies | 2012 | 2012 | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | MS Access, MS Excel, IBM DB2, Foxpro, Firebird, InterBase | C++ / MFC | |
DBeauty[17] | DBeauty | 1.0 (2011-08-15) | 1.0 (2011-08-15) | Apache 2.0 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | JDBC | Java | |||
DBeaver[18] | Serge Rieder | 2.0.3 (2012-11-28) | 2.0.3 (2012-11-28) | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Access, 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 | |
DBEdit | Jef Van Den Ouweland | 2.4 (2011-03-18) | ? | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | IBM DB2, HSQLDB, Apache Derby, H2 | Java | |
dbForge SQL Complete | Devart | 3.5 (2012-02-02) | 3.5.6 (2012-04-10) | Freeware y Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | C# | |||||
dbForge Studio for MySQL | Devart | 5.0 (2011-04-19) | 5.0.72 (2012-04-23) | Propietaria | ![]() | ![]() | ![]() | ![]() | C# | ||||||||
dbForge Studio for Oracle | Devart | 3.1 (2011-12-06) | 3.1.196 (2012-04-23) | Propietaria | ![]() | ![]() | ![]() | ![]() | C# | ||||||||
DBMan[19] | SQLEXEC LLC | 5.0 (2009-10-01) | 5.0 (2009-10-01) | ? | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Sybase (ASE/ASA), MS Access, Firebird | PowerBuilder/C++ | |||
DbNinja[20] | Vayer Software Ltd. | 1.0.1 (2010-01-01) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ? | ||||||||
DbSchema[21] | Wise Coders Solutions[22] | 6.1 (2012-03-20) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | MySQL, Sybase ASE, Informix, Apache Derby, Mimer SQL, IBM DB2, H2, Oracle, Vertica, Postgres, Sqlite, MS SQL, Firebird, Ingres, Cache DB, y más... | Java | |
DBStudio[23] | VLINX | 3.6.1 (2012-06-20) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | MySQL, IBM DB2, H2, database, Postgres, Sqlite, MS SQL], y más... | Java | |
DBTyp.NET[24] | BYPsoft | 2007 | 2008 | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | C# | ||||||
dbTrends for Oracle[25] | spViewer Software | 1.1 (2013-02-21) | 2012 | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Versiones compatibles de Oracle 8.1.7, 9.0.1, 9.2.0, 10.1.0, 10.2.0, 11.1.0, 11.2.0 | C++ | ||||
DbVisualizer[26] | DbVis Software | 12.0.2 (2021-02-14) | 12.0.2 (2021-02-14) | Freeware y Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Amazon Redshift, Azure SQL Database, Exasol, Greenplum, IBM DB2, IBM DB2 on Cloud, MariaDB, MySQL Cloud, Netezza, NuoDB, Oracle Cloud, SAP ASE, Snowflake, Sybase ASE, Informix, Vertica, Yellowbrick, Apache Derby, Mimer SQL, HP Neoview, H2 | Java | |
Debugger for MySQL[27] | MyDebugger.com | 1.2 (2010-06-02) | 1.2 (2010-06-02) | Propietaria | ![]() | ![]() | ![]() | ![]() | Embarcadero Delphi | ||||||||
Devgems Data Modeler | Devgems | 1.0.0 (2009-04-30) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | InterBase, Firebird | Embarcadero Delphi | |||||||
Dezign for Database | Datanamic | 6.3.3 (2011-06-01) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | InterBase, IBM DB2, Firebird, MS Access, Paradox, dBase, Pervasive, Informix, Clipper, Foxpro, Sybase, ElevateDB, NexusDB, DBISAM, Sqlite | Embarcadero Delphi | ||||
DreamCoder[28] | DreamCoder for MySQL/Oracle/PostgreSQL | 5.1.1 (2008-04-04) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? | ||||||
DreamCoder[28] | DreamCoder for MySQL/Oracle/PostgreSQL | 5.1.1 (2008-04-04) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? | ||||||
DtSQL - Universal Database Tools[29] | DigerTech Inc | 2.1.1 (2013-02-02) | 2.1.1 (2013-02-02) | Gratuita | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Apache 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 Anywhere | Java | |
Embarcadero DBArtisan | Embarcadero Technologies | 9.0.1 | 9.1 | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Sybase ASE | C++ Java | |||
EMS SQL Management Studio | SQLManager.net | 1.1.01 (2007-12-13) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, InterBase/Firebird | ? | ||||
Epictetus | Antilogic Software | ? | 1.0 (2009-06-17) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Sybase, InterBase/Firebird, H2, HSQLDB | Java | |||||
ERBuilder Data Modeler | Softbuilder | 3.4 (2020-03-10) | 3.4 (2020-03-10) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Firebird, MariaDB, Azure SQL Database, Amazon Redshift, Amazon RDS | ? | |||
ERwin Data Modeler | ca.com | 7.3 | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | MS Access, DB2, Foxpro, Informix, Ingres, Sybase, Teradata | ? | |||
ESF Database Migration Toolkit | EasyFrom Inc | 6.0.21 (2009-06-05) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | IBM DB2, MS Access, MS Excel, Firebird, Interbase, Foxpro, dBase, CSV/Texto, cualquier ODBC | C++ | |||
Happy Fish | Automatisering Polderij | 4.0.1 (2008-05-24) | ? | ? | ![]() | ![]() | ![]() | ![]() | Borland Delphi | ||||||||
HeidiSQL | HeidiSQL | 7.0 (2012-02-12) | Betas | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | Embarcadero Delphi | |||||||
Jailer[30] | Jailer | 3.5.6 (2011-06-07) | 3.5.6 (2011-06-07) | Apache 2.0 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | JDBC | Java | |||
Maatkit | Baron Schwartz | 5247 (2010-06-01) | ? | GPL | ![]() | ![]() | ![]() | ![]() | Perl | ||||||||
MicroOLAP Database Designer | MicrOLAP | 1.2.3 (2008-02-01) | 1.2.4-beta (2008-05-09) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ? | |||||||
My Database OnLine[31] | DataCast Technologies Inc. | 1.4 (2007-06-22) | 1.4 (2007-06-22) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Mixed | ||
Microsoft SQL Server Management Studio | Microsoft | ? | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | .Net | ||||||||
ModelRight | ModelRight | 3.6 | 3.7 | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | SQL Server, Oracle, MySQL, PostgreSQL, DB2, DB2/zOS, MS Access | C++ | ||||
MyOra | Jayam Systems LLC | 1.0.4 (2010-04-09) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | Java | ||||||||
MyQuery Builder[32] | MyQuery Builder] | 2.0.4 (2011-08-04) | 2.0.4 (2011-08-04) | Propietaria | ![]() | ![]() | ![]() | ![]() | PHP | ||||||||
MySql Lite Administrator | Vladimir Carrer | ? | 0.8 (2008-06-11) | GPL | ![]() | ![]() | ![]() | ![]() | php | ||||||||
MySQL Workbench | Oracle Corporation | 5.2.44 (2012-09-27) | ? | GPL | ![]() | ![]() | ![]() | ![]() | C++/C# Objective-C | ||||||||
Navicat | PremiumSoft CyberTech Ltd. | 11.0.8 (2013-07-03) | 11.0.8 (2013-07-03) | Propietaria | ![]() | ![]() | Requiere Wine | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Borland Delphi Objective-C | |||
Navicat Data Modeler | PremiumSoft CyberTech Ltd. | 1.0.11 (2013-02-04) | 1.0.11 (2013-02-04) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Borland Delphi Objective-C | |||
Nob Hill Database Compare[33] | Nob Hill Software | 1.3.01 | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | .net | |||||||
Online Data Modeler[34] | JenaSoft | 1.0.0 | 1.0.0 | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | EffiProz | JavaScript, ASP.NET | |||
Oracle Enterprise Manager | Oracle Corp. | 10gR5(2009-03-03) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Sybase, TimesTen | Java | |||||
Oracle SQL Developer | Oracle Corp. | 2.1.1 (1 de marzo de 2010) | 3.0 early adopter | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Microsoft Access, Sybase, DB2, Teradata | Java | ||
Orbada | Andrzej Ka?u?a | 1.0.4.109 (2011-02-08) | 1.0.4.109 (2011-02-08) | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Firebird, HSQL, Interbase, Derby todos con driver JDBC | Java | |
pgAdmin III | pgAdmin Development Team | 1.14.0 (2011-09-12) | ? | Licencia artística | ![]() | ![]() | ![]() | ![]() | C++ | ||||||||
phpLiteAdmin | Dane Iracleous | 1.9.2 (2012-5-31) | ? | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | php | ||
phpMSAdmin | Adam Voigt | 0.18 (2006-07-23) | ? | GPL | ![]() | ![]() | ![]() | ![]() | php | ||||||||
phpMyAdmin | phpMyAdmin Development Team | 3.5.2 (2012-07-07) | none | GPL | ![]() | ![]() | ![]() | ![]() | Drizzle, MariaDB | php | |||||||
phpPgAdmin | The phpPgAdmin Project | 4.2.3 (2010-03-29) | ? | GPL | ![]() | ![]() | ![]() | ![]() | php | ||||||||
PL/SQL Developer[35] | Allround Automations | 8.0.0 (2009-08-24) | 8.0.0 (2009-08-24) | Propietaria | ![]() | ![]() | ![]() | ![]() | Embarcadero Delphi | ||||||||
QuantumDB[36] | Julen Parra | 3.3.3 (2009-08-27) | ? | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | Java | |||||||
QweryBuilder[37] | Werysoft | 7.1.0 (2011-11-12) | 7.1.0 (2011-11-12) | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Sybase, SQL Anywhere | ? | |||||
RazorSQL[38] | Richardson Software, LLC[39] | 10.4.2 (2023-05-26) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, SQL Azure, Redshift, Amazon DynamoDB, Sybase, Firebird, Informix, Derby, HSQLDB, Amazon SimpleDB, Salesforce, Cassandra, MariaDB, Amazon Athena, Amazon Aurora, Druid, Hive, Google BigQuery, kdb+, SQL Anywhere / iAnywhere, Sybase IQ, Microsoft Access, Teradata, MongoDB, Vertica, MonetDB, OpenBase, FrontBase, Daffodil, Interbase, Mckoi, H2, Ingres, DBASE, Pervasive, Pointbase, Solid, Cache, Filemaker, Mimer SQL, Netezza, Paradox | Java | |
SchemaBank | Ezenso Limited | ? | ? | SaaS | ![]() | ![]() | ![]() | ![]() | ![]() | ? | |||||||
Silver Sash Administrator[40] | silversash.com | 1.0.15 | ? | Freeware | ![]() | ![]() | ![]() | ![]() | ![]() | Java | |||||||
SQL Buddy[41] | ? | 1.3.3 (2011-01-18) | ? | MIT | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | php | ||||||
SQL Developer[42] | Jan Borchers | 2.3.0 | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | Java | ||||||||
SQL Edge[43] | Bay Breeze Software, Inc. | 3.3 | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Sybase, MaxDB | Java | |||
SQL Maestro | SQL Maestro Group | various | various | EULA | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Firebird, MS Access | Embarcadero Delphi | ||
SQL Navigator | Quest Software | 6.1.1 (2009-02-17) | 6.2 | Propietaria | ![]() | ![]() | ![]() | ![]() | Embarcadero Delphi | ||||||||
SQL Server Comparison Expert[44] | DatabaseComparer Ltd. | 2.41 (2010-01-23) | 2.41 (2010-01-23) | Propietaria | ![]() | ![]() | ![]() | ![]() | C++ | ||||||||
SQLDetective | Conquest Software Solutions | 4.3.1 (2009-04-07) | 4.3.1 (2009-04-07) | Propietaria | ![]() | ![]() | ![]() | ![]() | Embarcadero Delphi | ||||||||
SQLPro SQL Client | Vive | 1.4 (2008-02-04) | ? | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | C++ | ||||
SQLTool Pro Database Editor | Nic Raboy | 1.3.9 (2013-23-01) | ? | Propietaria | ![]() | ![]() | Android | ![]() | ![]() | ![]() | ![]() | Java | |||||
SQLWave | nerocode | 5.7.2 | Not Available | Propietaria | ![]() | ![]() | ![]() | ![]() | ? | ||||||||
SQLyog | Webyog Softworks Pvt. Ltd. | 10.2 | ? | GPLv2 | ![]() | Requiere Wine | Requiere Wine | ![]() | C++ | ||||||||
SQuirreL SQL | Colin Bell, Gerd Wagner, Rob Manning y otros | 3.3.0 (2011-11-20) | ? | GPLv2 & LGPLv2 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | 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, y cualquier origen de datos compatible con JDBC. | Java | ||
Toad | Quest Software | Various | Betas | Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Sybase | Embarcadero Delphi, C#.NET | ||||
Toad Data Modeler | Quest Software | 3.3.8 (2009-03-05) | Betas[45] | Freeware y Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, MS Access, Sybase | Embarcadero Delphi | ||||
TOra | Comunidad | 2.1.3 (2010-09-19) | ? | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Teradata | C++/Qt | |||||
Toolsverse Data Explorer | Toolsverse | 3.1 (2012-12-01) | ? | LGPL y Propietaria | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | DB2, Sybase Adaptive Server, Informix, Excel, Delimited Text, Fixed Length Text, XML | Java and JavaScript | |
WWW SQL Designer | Ond?ej ?ára | 2.3.2 (2009-01-07) | ? | GPL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | JavaScript |
Características
Leyenda
- Crear/modificar tabla:
- Sí: pueden crear una tabla, modificar su definición y datos y agregar nuevas filas
- Algunos: solo pueden crear/modificar la definición de una tabla, no sus datos
- Explorar tabla:
- Sí: pueden explorar definiciones y datos de una tabla
- Algunos: solo pueden explorar definiciones de una tabla
- Compatibilidad con varios servidores:
- Sí. pueden administrar varios servidores desde la misma ventana/sesión
- Algunos. pueden administrar varios servidores desde una ventana/sesión diferente
Herramientas | Interfaz de usuario | Asistente para crear y modificar | Explorar | Finalización automática | Sintaxis de color | Compatibilidad con varios servidores | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Base de datos | Tabla | Procedimiento | Disparador | Base de datos | Tabla | Procedimiento | Disparador | |||||
ABIS-Query[1] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
ACDB[3] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Adminer | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Altova DatabaseSpy | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Aqua Data Studio[6] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ARMS[7] | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Caché Monitor[8] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
CAM editor[9] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Chive | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
DaDaBIK | En explorador | ![]() | Algunos[46] | ![]() | ![]() | ![]() | Algunos[47] | ![]() | ![]() | ![]() | ![]() | ![]() |
Data Visualization[11] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Database Master with LINQ | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Database Deployment Manager | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Database Workbench[12] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DatAdmin[14] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DataGlass[15] | móvil (iOS) | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DataFlyer[13] | Escritorio | ? | ? | ? | ? | ![]() | ![]() | ? | ? | ? | ? | ? |
DBeauty[17] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
DBEdit | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
dbForge Studio for MySQL | TDI | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DBMan[19] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
DbNinja[20] | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DbSchema[21] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DbVisualizer[26] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Debugger for MySQL[27] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Algunos |
Devgems Data Modeler | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
DeZign for Databases | Escritorio | ![]() | Algunos | ![]() | ![]() | ![]() | Algunos | ![]() | ![]() | ![]() | ![]() | ? |
DreamCoder[28] | Escritorio | ? | ? | ? | ? | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
DtSQL[29] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Embarcadero DBArtisan | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
EMS SQL Management Studio | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Epictetus | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
ERBuilder Data Modeler | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Happy Fish | Escritorio | Algunos[48] | Algunos | ? | ![]() | Algunos[49] | Algunos | ? | ![]() | ![]() | ![]() | ? |
Jailer[30] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
jfacedbc | Escritorio | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
MicroOLAP Database Designer | Escritorio | ![]() | Algunos | ![]() | ![]() | ![]() | Algunos | ![]() | ![]() | ![]() | ![]() | ? |
Microsoft SQL Server Management Studio | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ModelRight | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
MyQuery Builder[32] | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
MySql Lite Administrator | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Navicat | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Navicat Data Modeler | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Online Data Modeler[34] | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Oracle Enterprise Manager | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Oracle SQL Developer | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
OraDeveloper Studio | TDI | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Orbada | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
pgAdmin III | TDI | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
phpliteadmin | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
phpMSAdmin | En explorador | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
phpMyAdmin | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
phpPgAdmin | En explorador | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
PL/SQL Developer[35] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
QuantumDB[36] | Escritorio | ? | ? | ? | ? | ![]() | ![]() | ? | ? | ![]() | ![]() | ? |
QweryBuilder[37] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
RazorSQL[38] | Escritorio | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
SchemaBank | En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Silver Sash Administrator[40] | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
SQL Developer[42] | Escritorio | ![]() | Algunos[52] | ![]() | ? | ![]() | Algunos[53] | ![]() | ? | ![]() | ![]() | ? |
SQL Edge[43] | Escritorio | ![]() | Algunos[54] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
SQL Maestro | TDI | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
SQL Navigator | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
SQLDetective | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
SQLyog | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
SQuirreL SQL | Escritorio | ? | ? | ? | ? | ![]() | ![]() | ? | ? | ![]() | ![]() | Algunos |
SQLPro SQL Client | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
SQLWave | Escritorio | ? | ? | ? | ? | ![]() | ![]() | ![]() | ![]() | ? | ![]() | ![]() |
Toad | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Toad Data Modeler | Escritorio | ![]() | ![]() | ![]() | ![]() | Algunos | Algunos | Algunos | Algunos | ![]() | ![]() | ? |
TOra | Escritorio | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
Toolsverse Data Explorer | Escritorio and En explorador | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
WWW SQL Designer | En explorador | ![]() | Algunos | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? |
Características (continuación)
Leyenda:
- Administrador de usuarios:
- Sí: administrador de usuarios que admite permisos de base de datos y esquemas y también permisos de objetos individuales (tabla, ver, funciones)
- Algunos: administrador de usuarios simple que admite permisos de base de datos y esquemas
- No: sin administrador de usuarios o administrador de usuarios con permiso de solo lectura
Administrador de usuarios | Complemento | Comparar | Importar | Exportar | Depurador | Control de versiones | ||
---|---|---|---|---|---|---|---|---|
ABIS-Query[1] | ![]() | ? | ![]() | SQL script, Excel | SQL script, Excel multi-sheet, XML, XSD | ![]() | ? | |
ACDB[3] | ![]() | ? | ![]() | SQL script | SQL script | Oracle, MySQL | ? | |
Adminer | ![]() | ![]() | ![]() | SQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2 | SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin) | ![]() | Git | |
Altova DatabaseSpy | ![]() | ![]() | ![]() | CSV, XML | XML, XML Structure, CSV, HTML, MS Excel | ![]() | ? | |
Aqua Data Studio[6] | ![]() | ? | ![]() | CSV | CSV, SQL; diagram as JPEG, PNG | Oracle, Sybase, MS SQL Server, IBM DB2 | (SVN) Subversion (software), (CVS) Concurrent Versions System | |
ARMS[7] | ![]() | ? | ? | SQL script | SQL script | ![]() | ? | |
CAM editor | ![]() | ![]() | ![]() | XML, XSD schema | XML, HTML, Spreadsheet, Dictionary, XMI, Model | ![]() | ![]() | |
Chive | Algunos | ? | ![]() | SQL script | SQL script | ![]() | ? | |
DaDaBIK | Algunos[56] | ![]() | ![]() | ![]() | CSV | ![]() | ![]() | |
Data Visualization[11] | ![]() | ![]() | ![]() | CSV, XLS(X), ODS, XML | PDF, XML, CSV, RTF, MATLAB, TXT, XLS(X), HTML, DOCX, LaTeX, SQL, JSON, YAML | ![]() | ![]() | |
Database Master with LINQ | ![]() | ? | ![]() | 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 | ![]() | ? | |
Database Workbench[12] | ![]() | ![]() | ![]() | CSV, SQL Script | XML, DBF, TXT, CSV, SQL Script, Lotus 123, DIF | ![]() | ![]() | |
DatAdmin[14] | ![]() | ![]() | ![]() | SQL script, CSV, HTML, text file using regular expressions, generic XML | SQL script, CSV, HTML, XML, DokuWIKI, MediaWIKI, generic text file, MS Excel | ![]() | ![]() | |
DataGlass[15] | ![]() | ![]() | ![]() | ![]() | CSV | ![]() | ![]() | |
DataFlyer[13] | ![]() | ? | ![]() | ![]() | CSV, MS Excel | ![]() | ? | |
DBConvert migration software[16] | ![]() | ![]() | ![]() | MS Access, MySQL, MS SQL, MS Excel, PostgreSQL, SQLite, Oracle, IBM DB2, Foxpro, Firebird, InterBase | MS Access, MySQL, MS SQL, MS Excel, PostgreSQL, SQLite, Oracle, IBM DB2, Foxpro, Firebird, InterBase | ![]() | ![]() | |
DBEdit | ![]() | ![]() | ![]() | ![]() | MS Excel, PDF, Text, SQL script | ![]() | ? | |
dbForge Studio for MySQL | ![]() | ![]() | ![]() | ![]() | CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML[57] | ![]() | ? | |
<DBMan[19] | ![]() | ![]() | ![]() | SQL Script, TXT, CSV | TXT, CSV, SQL, PDF, XLS, XML, HTML Table, WK1, WMF, DIF, DBF, Clipboard | ![]() | ![]() | |
DbNinja[20] | ![]() | ![]() | ![]() | SQL script, CSV | SQL script, CSV | ![]() | ? | |
DbSchema[21] | ![]() | ? | ![]() | ![]() | SQL script, CSV, HTML 4, HTML 5, XML,Diagram as image (Png, Jpg, Gif), | ![]() | (SVN) Subversion (software) | |
DbVisualizer[26] | ![]() | Algunos | ![]() | ![]() | CSV, HTML, Excel, XML, SQL, JSON, text,Diagram in PNG, JPEG | ![]() | ? | |
Debugger for MySQL[27] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
Devgems Data Modeler | ![]() | ![]() | ![]() | ![]() | SQL; HTML report; diagram as EMF, BMP | ![]() | ? | |
DeZign for Databases | ![]() | ![]() | ![]() | ![]() | SQL; diagram as EMF, BMP, GIF, JPEG, PNG | ![]() | ? | |
DreamCoder[28] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? | |
DtSQL[29] | ![]() | ![]() | ![]() | CSV, Excel, SQL, text | CSV, HTML, Excel, XML, SQL, text | ![]() | ? | |
EMS SQL Management Studio | ![]() | ? | ![]() | 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 | ![]() | ![]() | ![]() | ![]() | Excel | ![]() | ? | |
ERBuilder Data Modeler | ![]() | ![]() | ![]() | ![]() | SQL script, CSV, HTML 5 report, Diagram as image (Png) | ![]() | ![]() | |
ESF Database Migration Toolkit | ![]() | ![]() | ![]() | Any database/file systems | Any database/file systems | ![]() | ? | |
Happy Fish | ![]() | ? | ![]() | ? | SQL; diagram as XML, BMP, JPEG, WMF | ![]() | ? | |
Jailer[30] | ![]() | ![]() | ![]() | SQL script | SQL script (topologically sorted), XML, DBUnit-XML | ![]() | ? | |
jfacedbc | ? | ? | ? | ? | ? | ![]() | ? | |
MicroOLAP Database Designer | ![]() | ? | ![]() | Algunos[59] | SQL; HTML report; diagram as BMP, EMF, GIF, JPEG, PNG | ![]() | ? | |
ModelRight | Algunos | ![]() | ![]() | ![]() | SQL; XML; DTD; Diagram as BMP, JPEG | ![]() | ? | |
MyQuery Builder[32] | ![]() | ![]() | ![]() | MySQL script | MySQL script | ![]() | ![]() | |
MySql Lite Administrator | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ? | |
Navicat | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
Navicat Data Modeler | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
Oracle SQL Developer | ![]() | ? | ? | ![]() | ![]() | ![]() | ? | |
OraDeveloper Studio | ![]() | ![]() | ![]() | ![]() | CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, XML | ![]() | ? | |
Orbada | ![]() | ![]() | ![]() | SQL script | SQL script, CSV, XML, HTML, PDF, Excel, DBF, DataText | ![]() | ![]() | |
pgAdmin III | ![]() | ![]() | ![]() | ![]() | CSV, text, HTML, XML | ![]() | ![]() | |
phpMSAdmin | ? | ? | ? | ? | ? | ![]() | ? | |
phpMyAdmin | ![]() | Algunos | ![]() | ![]() | ![]() | ![]() | Git | |
phpPgAdmin | ? | ? | ? | ? | ? | ![]() | ? | |
PL/SQL Developer[35] | ![]() | ![]() | ![]() | Dump, SQL | CSV, TSV, XML, SQL, HTML, MS Excel | ![]() | Microsoft Visual SourceSafe, Merant PVCS, MKS Source Integrity | |
QuantumDB[36] | ? | ? | ? | ? | CSV, XML | ![]() | ? | |
QweryBuilder[37] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
RazorSQL[38] | ? | ? | ? | ? | ? | ![]() | ? | |
SchemaBank | Algunos | Algunos | ![]() | SQL script | SQL script, reportes HTML, diagramas como PNG | ![]() | ![]() | |
SQL Developer[42] | ![]() | ![]() | ![]() | clipboard | SQL, CSV, XML, HTML; diagramas como PNG, SVG | ![]() | ? | |
SQL Edge[43] | ![]() | ? | ![]() | ![]() | ![]() | ? | ||
SQL Maestro | ![]() | ? | ? | 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 | ![]() | ? | |
SQL Navigator | Algunos | ![]() | Algunos | ![]() | ![]() | ![]() | CVS, ClearCase, PVCS, StarTeam, TFS, VSS | |
SQLDetective | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Microsoft Visual SourceSafe, Merant PVCS | |
SQLPro SQL Client | ? | ? | ? | ? | ? | ![]() | ? | |
SQLWave | ? | ![]() | ? | ? | ? | ? | ? | |
SQLyog | ![]() | ? | ![]() | ![]() | ![]() | ? | ? | |
SQL Server Management Studio | ![]() | ? | ? | ? | ? | ![]() | ? | |
SQuirreL SQL | ? | ![]() | ? | ![]() | ? | ![]() | ? | |
Toad | Algunos | ![]() | ![]() | ![]() | ![]() | ![]() | SVN, CVS, TFS, VSS | |
Toad Data Modeler | ![]() | ? | ![]() | Toad for Oracle ERD, ERWin 7.1(XML) via plugin | SQL | ![]() | ? | |
TOra | Algunos | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
TOra | Algunos | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | |
Toolsverse Data Explorer | ![]() | ![]() | ![]() | Cualquier compatible con JDBC,Excel,SQL,Delimited Text,Fixed Length Text,XML,XML with Transformation | Cualquier compatible con JDBC,Excel,SQL,Delimited Text,Fixed Length Text,XML,XML with Transformation | ![]() | ![]() | |
WWW SQL Designer | ![]() | ![]() | ![]() | SQL | ![]() | ![]() |
Características: diseño visual e ingeniería inversa
Leyenda:
- Esquema visual/diseño ER: la habilidad de crear diagramas de relación de entidad para la base de datos. Si falta, también faltarán estas dos características
- Ingeniería inversa: La habilidad de producir un diagrama de ER desde una base de datos, completo con relaciones de clave externas
- Sí. Admite ingeniería inversa incremental y conserva las modificaciones del usuario en el diagrama e importa solo los cambios desde la base de datos
- Algunos. Solo puede realizarse la ingeniería inversa de la base de datos completa de una vez y se eliminan todas las modificaciones del usuario en el diagrama (no se puede "actualizar" el diagrama para que coincida con la base de datos)
- Sí: puede actualizar las entidades seleccionadas por el usuario
- Algunos: solo pueden actualizar la base de datos completa de una vez
Creador de consultas visuales | Diseño de esquema visual/modelo/diagrama ER | Ingeniería inversa | Ingeniería directa | Cuadros de grupos de diagramas de ER | |
---|---|---|---|---|---|
ABIS-Query[1] | ![]() | ![]() | ![]() | ![]() | ![]() |
ACDB[3] | ![]() | ![]() | ![]() | ![]() | ![]() |
Adminer | ![]() | ![]() | ![]() | ![]() | ![]() |
Altova DatabaseSpy | ![]() | ![]() | ![]() | ![]() | ? |
Aqua Data Studio[6] | ![]() | ![]() | Algunos | ![]() | ? |
ARMS[7] | ![]() | ![]() | ![]() | ![]() | ![]() |
CAM editor | ![]() | ![]() | ![]() | ![]() | ![]() |
Chive | ![]() | ![]() | ![]() | ![]() | ![]() |
DaDaBIK | Algunos | ![]() | ![]() | ![]() | ![]() |
Database Master with LINQ | ![]() | ![]() | ![]() | ![]() | ![]() |
Database Deployment Manager | ![]() | ![]() | ![]() | ![]() | ![]() |
Database Workbench[12] | ![]() | ![]() | ![]() | ![]() | ![]() |
DatAdmin[14] | ![]() | ![]() | ![]() | ![]() | ![]() |
DataGlass[15] | ![]() | ![]() | ![]() | ![]() | ![]() |
DBEdit | ![]() | ![]() | ![]() | ![]() | ![]() |
dbForge Studio for MySQL | ![]() | ![]() | ![]() | ![]() | ![]() |
DBMan[19] | ![]() | ![]() | ![]() | ![]() | ![]() |
DbNinja[20] | ![]() | ![]() | ![]() | ![]() | ![]() |
DbSchema[21] | ![]() | ![]() | ![]() | ![]() | ![]() |
DbVisualizer[26] | ![]() | ![]() | Algunos | ![]() | ![]() |
Devgems Data Modeler | ![]() | ![]() | ![]() | ![]() | ![]() |
DeZign for Databases | ![]() | ![]() | ![]() | ![]() | ![]() |
DreamCoder[28] | ![]() | ? | ? | ? | ? |
DtSQL[29] | ![]() | ? | ? | ? | ? |
EMS SQL Management Studio | ![]() | ![]() | ![]() | ![]() | ![]() |
ERBuilder Data Modeler | ![]() | ![]() | ![]() | ![]() | ![]() |
Happy Fish | ? | ![]() | ![]() | ![]() | ![]() |
Jailer[30] | ![]() | ![]() | ![]() | ![]() | ![]() |
jfacedbc | ? | ? | ? | ? | ? |
MicroOLAP Database Designer | ![]() | ![]() | Algunos | ![]() | ? |
ModelRight | ![]() | ![]() | ![]() | ![]() | ![]() |
MyQuery Builder[32] | ![]() | ![]() | ![]() | ![]() | ![]() |
MySql Lite Administrator | ![]() | ![]() | ![]() | ![]() | ![]() |
Navicat | ![]() | ![]() | ![]() | ![]() | ![]() |
Navicat Data Modeler | ![]() | ![]() | ![]() | ![]() | ![]() |
Online Data Modeler[34] | ![]() | ![]() | ![]() | ![]() | ![]() |
Oracle SQL Developer | ![]() | ![]() | ![]() | ![]() | ? |
OraDeveloper Studio | ![]() | ![]() | ![]() | ![]() | ![]() |
Orbada | ![]() | ![]() | ![]() | ![]() | ![]() |
pgAdmin III | ![]() | ![]() | ![]() | ![]() | ![]() |
phpMSAdmin | ![]() | ? | ? | ? | ? |
phpMyAdmin | ![]() | ![]() | ![]() | ![]() | ![]() |
phpPgAdmin | ![]() | ![]() | ![]() | ![]() | ![]() |
QuantumDB[36] | ![]() | ? | ? | ? | ? |
QweryBuilder[37] | ![]() | ![]() | ![]() | ![]() | ![]() |
RazorSQL[38] | ![]() | ![]() | ![]() | ![]() | ![]() |
SchemaBank | ![]() | ![]() | ![]() | ![]() | ![]() |
SQL Developer[42] | ![]() | ![]() | ![]() | ![]() | ![]() |
SQL Edge[43] | Algunos[65] | ![]() | ![]() | ![]() | ![]() |
SQL Maestro | ![]() | ![]() | ![]() | ![]() | ![]() |
SQL Navigator | ![]() | ![]() | ![]() | ![]() | ? |
SQL Server Management Studio | ? | ![]() | ![]() | ? | ? |
SQLDetective | ![]() | ![]() | ![]() | ![]() | ![]() |
SQLPro SQL Client | ? | ![]() | ![]() | ![]() | ![]() |
SQLWave | ? | ? | ? | ? | ? |
SQLyog | ![]() | ![]() | ![]() | ![]() | ? |
SQuirreL SQL | ![]() | ![]() | ![]() | ? | ![]() |
Toad | ![]() | ![]() | ![]() | ![]() | ? |
Toad Data Modeler | ![]() | ![]() | ![]() | ![]() | ? |
Toolsverse Data Explorer | ![]() | ![]() | ![]() | ![]() | ![]() |
WWW SQL Designer | ![]() | ![]() | ![]() | Algunos | ![]() |
Notas
- ↑ a b c d ABIS-Query
- ↑ BOS-Software Sarl
- ↑ a b c d ACDB
- ↑ Crudin
- ↑ Cardett Associates Ltd
- ↑ a b c d Aqua Data Studio
- ↑ a b c d ARMS
- ↑ a b Caché Monitor
- ↑ a b CAM Editor
- ↑ Data Analyst Toolkit
- ↑ a b c Data Visualization
- ↑ a b c d Database Workbench
- ↑ a b c DataFlyer
- ↑ a b c d DatAdmin
- ↑ a b c d impathic DataGlass
- ↑ a b DBConvert migration software
- ↑ a b DBeauty Relational Data Browser
- ↑ DBeaver
- ↑ a b c d DBMan
- ↑ a b c d DbNinja
- ↑ a b c d DbSchema
- ↑ Wise Coders Solutions
- ↑ DBStudio
- ↑ DBTyp.NET
- ↑ dbTrends
- ↑ a b c d DbVisualizer
- ↑ a b c Debugger for MySQL
- ↑ a b c d e f g h i j k DreamCoder for PostgreSQL feature list
- ↑ a b c d e DtSQL - Universal Database Tools
- ↑ a b c d Database Subsetting and Browsing
- ↑ My DataBase OnLine
- ↑ a b c d A MySQL query editor for PHP web developers
- ↑ Nob Hill Database Compare
- ↑ a b c Online Data Modeler
- ↑ a b c PL/SQL Developer
- ↑ a b c d QuantumDB
- ↑ a b c d QweryBuilder
- ↑ a b c d RazorSQL
- ↑ Richardson Software, LLC
- ↑ a b Silver Sash Administrator
- ↑ SQL Buddy
- ↑ a b c d SQL Developer
- ↑ a b c d SQL Edge, Bay Breeze Software
- ↑ SQL Server Comparison Expert
- ↑ Toad Data Modeler Betas
- ↑ create CRUD interfaces, so create table data, not table theriselves
- ↑ browse table data, not table definitions
- ↑ Via reverse and forward engineering; i.e. cannot set options such as the database encoding
- ↑ Via reverse engineering
- ↑ QweryBuilder - Object Browser
- ↑ QweryBuilder - Auto Complete
- ↑ SQL Developer 2.3.0 mixes up PostgreSQL indexes as tables
- ↑ 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
- ↑ a b SQL Edge can create and drop tables, edit table data, but cannot alter table structure
- ↑ 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."
- ↑ can manage its own users, which override the DBMS users
- ↑ dbForge Studio features matrix
- ↑ With the Database Comparer application from the Studio suite
- ↑ Can import SQL via "Reverse Engineer - SQL Script"
- ↑ QweryBuilder - Visual Difference
- ↑ Individual table permissions can be applied from the Permissions tab of each table
- ↑ QweryBuilder - Graphic Query Window
- ↑ RazorSQL - SQL Query Builder
- ↑ SQL query wizard
- ↑ SQL Maestro query builder
- ↑ SQLYog query builder
- ↑ SQLYog schema designer
Enlaces externos
- Database administration and schema design tools