StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>If you're looking for a free/open source tool to achieve this, you could try:</p> <p><a href="http://fabforce.net/dbdesigner4/index.php" rel="nofollow noreferrer">DBDesigner</a></p> <p>From the website:</p> <blockquote> <p>DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.</p> <p>It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.</p> <p>DBDesigner 4 compares to products like Oracle's Designer©, IBM's Rational Rose©, Computer Associates's ERwin© and theKompany's DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.</p> </blockquote> <p>And it supports the following features:</p> <blockquote> <ul> <li>Available on Linux / MS Windows</li> <li>User Interfaced based on industry standard layouting software</li> <li>Design Mode / Query Mode</li> <li><strong>Reverse engineering MySQL, Oracle, MSSQL and any ODBC databases</strong></li> <li>Userdefined schema-generation</li> <li><strong>Model-To-Database syncronisation</strong></li> <li>Index support</li> <li>Automatic foreign key placement</li> <li>Weak entity support</li> <li>Standard Inserts storing and sync</li> <li>Full documentation capabilities</li> <li>Advanced model printing</li> <li>Output as image</li> <li>All MySQL datatypes with all options</li> <li>User defined datatypes</li> <li>Database storage, ability to save model within database</li> <li>Network-/Multiuser access through database storage</li> <li>Version control*</li> <li>SQL Query Builder</li> <li>SQL Command History</li> <li>SQL Command storage within model</li> <li>Plugin interface</li> </ul> </blockquote> <p>I think the bolded ones above (my own emphasis) should give you what you require (i.e. effectively two-way database/model synchronization).</p> <p>I have used the tool in the past to reverse engineer an existing database to an ER diagram. From what I remember, it wasn't the most stable software I'd ever used (I seem to recall it crashed a couple of times) however, this was a little while ago so it may be more stable now. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload