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, visual, design, reverse and/or engineering:

    “The chess pieces are the block alphabet which shapes thoughts; and these thoughts, although making a visual design on the chess-board, express their beauty abstractly, like a poem.... I have come to the personal conclusion that while all artists are not chess players, all chess players are artists.”
    —Marcel Duchamp (1887–1968)

    “To write well, to have style ... is to paint. The master faculty of style is therefore the visual memory. If a writer does not see what he describes—countrysides and figures, movements and gestures—how could he have a style, that is originality?”
    —Rémy De Gourmont (1858–1915)

    “Nowadays the host does not admit you to his hearth, but has got the mason to build one for yourself somewhere in his alley, and hospitality is the art of keeping you at the greatest distance. There is as much secrecy about the cooking as if he had a design to poison you.”
    —Henry David Thoreau (1817–1862)

    “We came home from the ridotto so late, or rather so early, that it was not possible for me to write. Indeed we did not go ... till past eleven o’clock: but nobody does. A terrible reverse of the order of nature! We sleep with the sun, and wake with the moon.”
    —Frances Burney (1752–1840)

    “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)