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 | ||
---|---|---|---|---|---|---|---|---|
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, 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) | No | Git | |
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 | ? | |
CAM editor | No | No | No | XML, XSD schema | XML, HTML, Spreadsheet, Dictionary, XMI, Model | No | No | |
Chive | Some | ? | No | SQL script | SQL script | No | ? | |
DaDaBIK | Some | No | No | No | CSV | Yes | No | |
Data Visualization | No | No | No | CSV, XLS(X), ODS, XML | PDF, XML, CSV, RTF, MATLAB, TXT, XLS(X), HTML, DOCX, LaTeX, SQL, JSON, YAML | No | No | |
Database Master with LINQ | 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 | ? | |
Database Workbench | Yes | No | Yes | CSV, SQL Script | XML, DBF, TXT, CSV, SQL Script, Lotus 123, DIF | Yes | 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 | ? | |
DBConvert migration software | No | No | Yes | 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 | No | 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 | Yes | ? | |
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 4, HTML 5, XML,Diagram as image (Png, Jpg, Gif), | No | (SVN) Subversion (software) | |
DbVisualizer | No | Some | No | Yes | CSV, HTML, Excel, XML, SQL, JSON, 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 | Yes | Yes | No | ? | |
DtSQL | Yes | Yes | Yes | CSV, Excel, SQL, text | CSV, HTML, Excel, XML, SQL, text | No | ? | |
EMS SQL Management Studio | Yes | ? | Yes | 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 | ? | |
Jailer | No | No | No | SQL script | SQL script (topologically sorted), XML, DBUnit-XML | No | ? | |
jfacedbc | ? | ? | ? | ? | ? | No | ? | |
MicroOLAP Database Designer | No | ? | No | Some | 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) | 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) | Yes | No | |
Navicat Data Modeler | No | No | Yes | Yes - Import Database from server/ODBC | Yes - Export SQL | No | 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 | 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 | No | ? | |
SQL Maestro | Yes | ? | ? | 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 | |
TOra | Some | No | Yes | Yes | Yes | Yes | No | |
Toolsverse Data Explorer | Yes | Yes | No | JDBC compliant database,Excel,SQL,Delimited Text,Fixed Length Text,XML,XML with Transformation | JDBC compliant database,Excel,SQL,Delimited Text,Fixed Length Text,XML,XML with Transformation | No | No | |
WWW SQL Designer | No | Yes | No | SQL | No | No |
Read more about this topic: Comparison Of Database Tools
Famous quotes containing the word features:
“Art is the child of Nature; yes,
Her darling child, in whom we trace
The features of the mothers face,
Her aspect and her attitude.”
—Henry Wadsworth Longfellow (18071882)