Comparison of Database Tools - Features (continued)

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:

    Each reader discovers for himself that, with respect to the simpler features of nature, succeeding poets have done little else than copy his similes.
    Henry David Thoreau (1817–1862)