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:
“The features of our face are hardly more than gestures which force of habit made permanent. Nature, like the destruction of Pompeii, like the metamorphosis of a nymph into a tree, has arrested us in an accustomed movement.”
—Marcel Proust (1871–1922)