Comparison of database administration tools
Appearance
![]() | This article needs attention from an expert in Databases. Please add a reason or a talk parameter to this template to explain the issue with the article. |
The following tables compare general and technical information for a number of available database administrator tools. Please see the individual products' articles for further information. This article is neither all-inclusive nor necessarily up-to-date.
You can check some features from the Database java tools. .
General
Creator | Latest stable release | Latest testing release | License / Price (USD) | Runs on Windows | Runs on Mac OS X | Runs on Linux | Database | Programming language | |
---|---|---|---|---|---|---|---|---|---|
Aqua Data Studio | ? | ? | ? | Proprietary / $399 | Yes | Yes | Yes | JDBC | Java |
DbVisualizer | ? | ? | ? | $149,free | Yes | Yes | Yes | JDBC | Java |
jfacedbc | ? | ? | ? | GPL, $ | Yes | Yes | Yes | JDBC | Java |
pgAdmin III | ? | ? | ? | GPL | Yes | Yes | Yes | PostgreSQL | ? |
phpMSAdmin | ? | ? | ? | GPL | Yes | ? | ? | MS SQL Server | php |
phpMyAdmin | ? | ? | ? | GPL | Yes | Yes | Yes | MySQL | php |
phpPgAdmin | ? | ? | ? | GPL | Yes | Yes | Yes | PostgreSQL | php |
QuantumDB | ? | ? | ? | GPL | Yes | Yes | Yes | JDBC, Eclipse plugin | Java |
RazorSQL | ? | ? | ? | Proprietary / $49.95 | Yes | Yes | Yes | JDBC | Java |
SQL Developer | ? | ? | ? | Proprietary / $99 | Yes | Yes | Yes | JDBC | Java |
SQL Manager | ? | ? | ? | $ | Yes | No | No | MySQL, oracle, MS SQL Server, Interbase, Firebird, DB2 | ? |
SQL Server Configuration Manager | Microsoft | ? | ? | Proprietary / $ | Yes | No | No | MS SQL Server | ? |
SQLyog | ? | ? | ? | Proprietary / $ | Yes | No | No | MySQL | ? |
SQuirreL SQL | ? | ? | ? | GPL | Yes | Yes | Yes | JDBC | Java |
Toad | Quest Software | ? | ? | Proprietary | Yes | No | No | Oracle, MS SQL Server, DB2 | ? |
BYPsoft | BYPsoft | 2007 | 2008 | GPL | Yes | No | No | MySQL, Oracle, MS SQL Server | C# |
Creator | Latest stable release | Latest testing release | Licence | Runs on Windows | Runs on Mac OS X | Runs on Linux | Database | Programming language |
Features
Tools | web interface | Create & Alter wizard | Browse | Auto Completion | Syntax colored | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Database | Table | Procedure | Trigger | Database | Table | Procedure | Trigger | ||||
Aqua Data Studio | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
DbVisualizer | No | ? | Yes | ? | ? | Yes | Yes | Yes | Yes | Yes | Yes |
jfacedbc | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
pgAdmin III | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
phpMSAdmin | Yes | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
phpMyAdmin | Yes | Yes | Yes | No | No | Yes | Yes | No | No | No | No |
phpPgAdmin | Yes | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
QuantumDB | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
RazorSQL | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
SQL Developer | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
SQL Manager | No | ? | ? | ? | ? | ? | ? | ? | ? | Yes | Yes |
SQL Server Configuration Manager | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes |
SQLyog | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
SQuirreL SQL | No | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? |
Toad | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes |
Features (continued)
Query Builder | user manager | Graph | Plugin | Compare | Import | Export | Debugger | |
---|---|---|---|---|---|---|---|---|
Aqua Data Studio | ? | ? | ? | ? | ? | ? | ? | oracle,sybase |
DbVisualizer | Yes | ? | ? | ? | ? | Yes | csv,html,xls,xml,sql,text | No |
jfacedbc | ? | ? | ? | ? | ? | ? | ? | No |
pgAdmin III | ? | ? | ? | ? | ? | ? | ? | No |
phpMSAdmin | No | ? | ? | ? | ? | ? | ? | No |
phpMyAdmin | No | Yes | No | ? | ? | ? | csv,latex,Excel,xml,sql | No |
phpPgAdmin | No | ? | ? | ? | ? | ? | ? | No |
QuantumDB | No | ? | ? | ? | ? | ? | ? | No |
RazorSQL | ? | ? | ? | ? | ? | ? | ? | No |
SQL Developer | ? | ? | ? | ? | ? | ? | ? | No |
SQL Manager | ? | ? | ? | ? | ? | ? | ? | No |
SQL Server Configuration Manager | ? | Yes | ? | ? | ? | ? | ? | No |
SQLyog | ? | ? | ? | ? | ? | ? | ? | No |
SQuirreL SQL | ? | ? | ? | ? | ? | ? | ? | No |
See also
- List of relational database management systems
- Comparison of object-relational database management systems
- Comparison of relational database management systems