Comparison of Database Tools - Features - Visual Design and Reverse Engineering

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
Visual query builder Visual schema/model/E-R diagram design Reverse engineering Forward engineering ER diagram groupboxes
ABIS-Query Yes No Yes Yes No
ACDB No Yes Yes Yes Yes
Adminer Yes Yes Yes No No
Altova DatabaseSpy Yes Yes Yes Yes ?
Aqua Data Studio Yes Yes Some No ?
ARMS Yes No No No No
CAM editor Yes Yes Yes Yes No
Chive No No No No No
DaDaBIK Some No No No No
Database Master with LINQ Yes Yes Yes Yes Yes
Database Deployment Manager Yes Yes Yes No No
Database Workbench Yes Yes Yes Yes Yes
DatAdmin Yes Yes Yes Yes No
DataGlass Yes No No No No
DBEdit No No No No No
dbForge Studio for MySQL Yes Yes Yes Yes Yes
DBMan No Yes Yes Yes Yes
DbNinja Yes Yes Yes No No
DbSchema Yes Yes Yes Yes Yes
DbVisualizer Yes Yes Some No No
Devgems Data Modeler No Yes Yes Yes Yes
DeZign for Databases No Yes Yes Yes Yes
DreamCoder Yes ? ? ? ?
DtSQL Yes ? ? ? ?
EMS SQL Management Studio Yes Yes Yes No No
Happy Fish ? Yes Yes Yes Yes
Jailer Yes Yes Yes No No
jfacedbc ? ? ? ? ?
MicroOLAP Database Designer No Yes Some Yes ?
ModelRight No Yes Yes Yes Yes
MyQuery Builder Yes No No No No
MySql Lite Administrator No No No No No
Navicat Yes Yes Yes Yes Yes
Navicat Data Modeler No Yes Yes Yes Yes
Online Data Modeler No Yes Yes Yes No
Oracle SQL Developer Yes Yes Yes Yes ?
OraDeveloper Studio Yes No No No No
Orbada No No No No No
pgAdmin III Yes No No No No
phpMSAdmin No ? ? ? ?
phpMyAdmin Yes Yes Yes No No
phpPgAdmin No No No No No
QuantumDB No ? ? ? ?
QweryBuilder Yes No Yes No No
RazorSQL Yes No No No No
SchemaBank No Yes Yes Yes Yes
SQL Developer No Yes Yes No No
SQL Edge Some Yes Yes No No
SQL Maestro Yes Yes Yes Yes No
SQL Navigator Yes Yes Yes No ?
SQL Server Management Studio ? Yes Yes ? ?
SQLDetective Yes No No No No
SQLPro SQL Client ? No No No No
SQLWave ? ? ? ? ?
SQLyog Yes Yes Yes Yes ?
SQuirreL SQL Yes Yes Yes ? No
Toad Yes Yes Yes Yes ?
Toad Data Modeler No Yes Yes Yes ?
Toolsverse Data Explorer No No Yes Yes No
WWW SQL Designer No Yes No Some No

Read more about this topic:  Comparison Of Database Tools, Features

Famous quotes containing the words visual, design, reverse and/or engineering:

    “Unlike any other visual image, a photograph is not a rendering, an imitation or an interpretation of its subject, but actually a trace of it. No painting or drawing, however naturalist, belongs to its subject in the way that a photograph does.”
    —John Berger (b. 1926)

    “You can make as good a design out of an American turkey as a Japanese out of his native stork.”
    —For the State of Illinois, U.S. public relief program (1935-1943)

    “During the late war [the American Revolution] I had an infallible rule for deciding what [Great Britain] would do on every occasion. It was, to consider what they ought to do, and to take the reverse of that as what they would assuredly do, and I can say with truth that I was never deceived.”
    —Thomas Jefferson (1743–1826)

    “Mining today is an affair of mathematics, of finance, of the latest in engineering skill. Cautious men behind polished desks in San Francisco figure out in advance the amount of metal to a cubic yard, the number of yards washed a day, the cost of each operation. They have no need of grubstakes.”
    —Merle Colby, U.S. public relief program (1935-1943)