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)
“Dialogue should simply be a sound among other sounds, just something that comes out of the mouths of people whose eyes tell the story in visual terms.”
—Alfred Hitchcock (1899–1980)
“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)
“They shall beat their swords into plowshares, and their spears into pruninghooks: nation shall not lift up sword against nation, neither shall they learn war any more.”
—Bible: Hebrew Isaiah, 2:4.
The words reappear in Micah 4:3, and the reverse injunction is made in Joel 3:10 (”Beat your plowshares into swords ...”)
“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)