Jump to content

Comparison of database administration tools

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by RaviKartheek (talk | contribs) at 16:05, 28 January 2008 (→‎Features (continued)). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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
Toad ? ? ? ? ? ? ? No

See also

External links

Retrieved from "https://en.wikipedia.org/w/index.php?title=Comparison_of_database_administration_tools&oldid=187484826"