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:

    “Nowadays people’s visual imagination is so much more sophisticated, so much more developed, particularly in young people, that now you can make an image which just slightly suggests something, they can make of it what they will.”
    —Robert Doisneau (b. 1912)

    “If I knew for a certainty that a man was coming to my house with the conscious design of doing me good, I should run for my life ... for fear that I should get some of his good done to me,—some of its virus mingled with my blood.”
    —Henry David Thoreau (1817–1862)

    “Now listen, buddy, there are a few corny ideas you got to get out of your head if you’re going to fly an airplane. Most things are just the reverse from what people think. The higher you are the safer you are. The Earth down there, that, that’s your enemy because once you hit that, boy, you splatter.”
    —Dalton Trumbo (1905–1976)

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