Comparison_of_database_administration_tools

Comparison of database administration tools

Comparison of database administration tools

Add article description

The following tables compare general and technical information for a number of available database administration 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

More information Product, Creator ...

Features

Legend

  • User Interface:
  • 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
More information Tools, User Interface ...

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
More information user manager, Plugin ...

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 - 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
More information Visual query builder, Visual schema/model/E-R diagram design ...

See also

Notes

  1. [N 1]
    Only incremental, by manually going through each table and clicking "Add to graph".
  2. [N 2]
    Generated SQL must be executed outside Toad Data Modeler.

References

  1. [1]
    "What's New in DatabaseSpy". altova.com. Retrieved 2019-07-24.
  2. [2]
    "Release 23.2.5". GitHub. 2023-11-20. Retrieved 2023-11-29.
  3. [3]
    "Releases - HeidiSQL/HeidiSQL". github.com. Retrieved 2022-08-26.
  4. [4]
    "Download SQL Server Management Studio (SSMS)". 9 April 2024.
  5. [5]
    "An Overview of Database Diagram Tools Available for PostgreSQL". Severalnines. 2019-07-05. Retrieved 2019-07-24.
  6. [6]
    "ModelRight Download full version trials". www.modelright.com. Retrieved 2019-07-24.
  7. [7]
    "Releases - mysql/mysql-workbench". github.com. Retrieved 2020-11-19.
  8. [8]
    "Welcome to Navicat's Press Center - Navicat". www.navicat.com. Retrieved 2022-04-17.
  9. [9]
    "Orbada - Database manager - Browse /Orbada at SourceForge.net". sourceforge.net. Retrieved 2019-07-24.
  10. [10]
    "pgAdmin - PostgreSQL Tools". www.pgadmin.org. Retrieved 2020-03-18.
  11. [11]
    "Phpliteadmin / Public / Downloads — Bitbucket".
  12. [12]
    "phpMyAdmin 5.2.1". 8 February 2023. Retrieved 8 February 2023.
  13. [13]
    "SQLyog MySQL GUI v13.1.9 Released". sqlyog.com. Retrieved 2021-01-11.
  14. [14]
    "SQuirrel SQL Client - Browse/1-stable". sourceforge.net. Retrieved 2023-11-25.
  15. [15]
    "Toad Data Modeler 7.3 - Release Notes". support.quest.com. Retrieved 2022-04-17.
  16. [16]
    custom system via TeamServer in Enterprise Edition
  17. [17]
    title= Navicat feature matrix
  18. [18]
    "Source Control in SQL Server Management Studio (SSMS)". 21 November 2016.
  19. [19]
    "SQLYog query builder". Archived from the original on 2010-10-26. Retrieved 2008-05-29.
  20. [20]
    "SQLYog schema designer". Archived from the original on 2010-10-26. Retrieved 2008-05-29.
Share this article:

This article uses material from the Wikipedia article Comparison_of_database_administration_tools, and is written by contributors. Text is available under a CC BY-SA 4.0 International License; additional terms may apply. Images, videos and audio are available under their respective licenses.