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:
“All visible objects, man, are but as pasteboard masks. But in each eventin the living act, the undoubted deedthere, some unknown but still reasoning thing puts forth the mouldings of its features from behind the unreasoning mask. If man will strike, strike through the mask!”
—Herman Melville (18191891)