The following tables compare general and technical information for a number of available

database administration Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use D ...

tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date. Systems listed on a light purple background are no longer in active development.

General

Features

Legend * User Interface: ** Browser based - executes on a computer server and is accessed via a network using a

web browser A web browser, often shortened to browser, is an application for accessing websites. When a user requests a web page from a particular website, the browser retrieves its files from a web server and then displays the page on the user's scr ...

** desktop - executes on a

personal computer A personal computer, commonly referred to as PC or computer, is a computer designed for individual use. It is typically used for tasks such as Word processor, word processing, web browser, internet browsing, email, multimedia playback, and PC ...

* Create/alter table: ** Yes - can create table, alter its definition and data, and add new rows ** Some - can only create/alter table definition, not data * Browse table: ** Yes - can browse table definition and data ** Some - can only browse table definition * Multi-server support: ** Yes - can manage from the same window/session multiple servers ** Some - can manage from a different window/session multiple servers * Monitoring server: ** Yes - includes a headless server, that runs checks and reports failures

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

Features - visual design and reverse engineering

Legend: * Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing *

Reverse engineering Reverse engineering (also known as backwards engineering or back engineering) is a process or method through which one attempts to understand through deductive reasoning how a previously made device, process, system, or piece of software accompl ...

- the ability to produce an ER diagram from a database, complete with foreign key relationships ** Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database ** Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't "refresh" the diagram to match the database) * Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer ** Yes - can update user-selected entities ** Some - can only update the entire database at once

Notes

References

{{DEFAULTSORT:Comparison Of Database Tools